data lookups for custom table

Hazarath
Kilo Contributor

i need to create data lookups in custom table based on impact and urgency,priority field should be populate

1 ACCEPTED SOLUTION

ghsrikanth
Tera Guru

You have to create a custom data lookup table extending dl_matcher table - this custom lookup table should have the same columns as your Custom table (that is u_urgency, u_impact, u_priority)


Screen Shot 2016-03-19 at 2.05.08 PM.png



Then go to the module System Policy -> Rules -> Data lookup definitions


The module will list out of box lookup definitions, there you can see there are two defined for Incident table as Source table


Create new data lookup definitions -


In the source table - select your custom table


In the matcher table - select the matcher table that you have created before


You can always use the OOB definitions for more reference


After you save, the related list opens up in which you can select Matcher fields and Setter fields



Screen Shot 2016-03-19 at 2.06.27 PM.png


Screen Shot 2016-03-19 at 2.07.18 PM.png



Screen Shot 2016-03-19 at 2.14.36 PM.png



Hope the screenshots are helpful



Mark if it is helpful or correct, feedback is appreciated


View solution in original post

4 REPLIES 4

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Aneef,



Please go through the below link and let me know if you have any questions.


http://wiki.servicenow.com/index.php?title=Data_Lookup_and_Record_Matching_Support#gsc.tab=0


Hi pradeep sharma,



where can i add urgency,impact values? it shows the add values   data lookup table where can i add those values?if tehere any screen shots?


ghsrikanth
Tera Guru

You have to create a custom data lookup table extending dl_matcher table - this custom lookup table should have the same columns as your Custom table (that is u_urgency, u_impact, u_priority)


Screen Shot 2016-03-19 at 2.05.08 PM.png



Then go to the module System Policy -> Rules -> Data lookup definitions


The module will list out of box lookup definitions, there you can see there are two defined for Incident table as Source table


Create new data lookup definitions -


In the source table - select your custom table


In the matcher table - select the matcher table that you have created before


You can always use the OOB definitions for more reference


After you save, the related list opens up in which you can select Matcher fields and Setter fields



Screen Shot 2016-03-19 at 2.06.27 PM.png


Screen Shot 2016-03-19 at 2.07.18 PM.png



Screen Shot 2016-03-19 at 2.14.36 PM.png



Hope the screenshots are helpful



Mark if it is helpful or correct, feedback is appreciated


bvs
Tera Contributor

this is for the Newyork version ..

 

system policy>> priority lookup rules

There you find priority data lookups..