Need to update record's based on selection made in catalog request
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-19-2025 03:28 AM
I have one table called "xyz". In this table there are three columns called
configuration_item, key and value
configuration_item is a refernce field and it is referencing to cmdb_ci table.
1 CI from cmdb_ci table can have multiple records under xyz table like below
configuration_item key value
item1 A B
item1 E J
item2 K L
Now the ask is I have one catalog item which is used to update the key value records in xyz table for specific CI. As you can see in above example, the total count is 3... but if the user selects the count as 1 under one variable and then removes the random key value while raising the request then once the RITM generates the same count and with the same key value it should get update in the xyz table for that CI.
For example: Lets say we have above CI and its key value count and records.
while raising update request in service portal
User selected the count as 1 and kept the mapping as below
key value
Z N
now once the RITM generates the update should look like below in the xyz table
configuratio_item key value
item1 Z N
can u help me to build the logic for above ask
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-14-2025 10:18 PM
Hope you are doing good.
Did my reply answer your question?
If my response helped please mark it ✅ and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader