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"

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 ?
Kind regards,
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


I'm not sure what your context is but there are two ways you can do this:
Place the data in an asset and have the custom field reference the asset. Custom fields can have their value populated via a query, e.g query:select ASSET.NAME from ASSET where ASSET_TYPE_ID = 10
where 10 is the ID for the asset type you created. You can then update the asset via import or manually.

The other way to handle this is via a service desk rule. Rules can actually write to almost any part of the database which is why you need to be careful with them. You could conceivably craft a rule that would update the custom field values for you.

I would probably go the asset route as it is quite simple and should give you more flexibility for updating in the future.

Answered 11/17/2014 by: chucksteel
Red Belt

  • Hi Chuck ! Thank you for your answer. The context is the following: Each one of our users works for a specific project. The active project list is managed by another application (proprietary). What I want to achieve, is to sync on a daily basis the active project list. So when a user wants to create a SD ticket, he can choose the project he / she works for.
Please log in to comment