
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2019 03:17 PM
HI friends,
I have a requested item with variables. A used entered an end date in a "end date" variable while submitting the ticket. it was there before but somehow the end date has been vanished. I am trying to find out the history of the variable "end date".
Please advise.
Thanks in advance,
karthik.
Solved! Go to Solution.
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2019 04:29 PM
Yes, variables are not audited.
I remember a similar issue where the variable become empty and mandatory.There was an onload client script that was clearing the value of variables. You may have the similar script that is creating the issue. My point is there may be some value there in the variable but it is getting clear on load. Check the variables value on the list view
As mentioned earlier , it is not possible to find out the value what user has entered in variable as the variables are not audited.
Whenever user submit a request, then all the variables and its values are captured in the sc_item_option table. And there is another table sc_item_option_mtom relating these variable values to their respective Requested Items. You can check this table to check if the variable contains any value there or not. This table will help you to update the value of the required variables.
Hope this information will help you.
-Harsh

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2019 04:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2019 04:29 PM
Yes, variables are not audited.
I remember a similar issue where the variable become empty and mandatory.There was an onload client script that was clearing the value of variables. You may have the similar script that is creating the issue. My point is there may be some value there in the variable but it is getting clear on load. Check the variables value on the list view
As mentioned earlier , it is not possible to find out the value what user has entered in variable as the variables are not audited.
Whenever user submit a request, then all the variables and its values are captured in the sc_item_option table. And there is another table sc_item_option_mtom relating these variable values to their respective Requested Items. You can check this table to check if the variable contains any value there or not. This table will help you to update the value of the required variables.
Hope this information will help you.
-Harsh

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2019 04:37 PM
Thanks Harshtimes. This helped me.