I need to populate a service desk custom form periodically... ideas ?
I know that I can use a query on the custom field to pick all possible responses. But I need to populate those responses (250 values). I need for this to happen on daily basis.
I could easily do it by updating HD_CUSTOM_FIELDS with something like:
update ORG1.HD_CUSTOM_FIELDS set ORG1.HD_CUSTOM_FIELDS.VALUES="HR, Facilities, Systems Engineering, Finance"
WHERE ID=0 AND HD_QUEUE_ID=3;
Problem is... user R1 doesn't have write permissions. Any other way to do it ? User with permissions to do it ? Any other table that can be used for this purpose ?