opened_by on my Requests is empty - why?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2018 06:13 AM
after requesting an item through the catalog the Request is showing 'Opened By' as empty. When I look at the XML there is no value captured. Digging into the dictionary shows the OOB default value is set to dynamic, Sender. I have not scripts, business rules or ui policies running on this field that would clear a value. Why would it not be working? Should I create a business rule to set the opened_by same as sys_created_by?
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2018 06:30 AM
Couple of questions for you: Is this happening on all Requests, or isolated to one or a few users? Does your Request table have a dictionary override on the opened_by field?
I would not create a BR to set opened_by to sys_created_by. sys_created_by is a string field with the user's user_name in it. The opened_by field is a reference to the actual User record.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2018 06:50 AM
yep its not ideal.
it is only on requests and happening on all requests regardless of user - does not seem to be affecting incidents or anything else related to the task table, which makes it more strange as they all function properly.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2018 07:08 AM
To clarify, is it the sc_req_item table you are having issues with or sc_request? did you see if there are any dictionary overrides in place?
Also, can you check the audit history of one of the records to see if it was initially set correctly and then cleared, or if it was never set properly to begin with?
Is your "Sender" Dynamic Filter still active and is the script in it simply gs.getUserID();?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2018 08:47 AM