Catalog Data Lookup Definition - A zero code way to fetch data like requester Details in a catalog item

[suvro]

Hi Community Users,

To make data lookup more easier while working with Catalog Items, I would like to share the below zero code method to do lookup data like fetching requester details.

Go to Data Lookup and Click on New

Select Catalog Data Lookup Rule

Define the catalog item/variable set for which the rule applies and the matcher table which holds the data and do other configurations as below and submit the record.

Define the matcher variable on change of which you need to lookup data and which field from the matcher table will match its value using Catalog Matcher Variable Definition related list

Then define the mapping between the variables and fields from matcher table using Catalog Setter Variable Definitions

And you are done.

Please subscribe and bookmark this article so that you can frequently visit this page as and  when you like

[Prashant Ahire]

Hello i did this, but not working. i dont know why

[suvro]

What is the issue you are facing?

[suvro]

Hi @Prashant Ahire ,

As discussed, you department variable should reference to cmn_department table rather than sys_user table. In sys_user table as well, the department field is referencing to cmn_department table.

[M_lissa]

I am trying to use the Data lookup definition based on the sys_user table, however the setter fields are not updating if user is INACTIVE.  Any idea why?

[kush10]

I am using this method, but the catalog form is fetching sys id of department and not the department name, any leads what can be done?

[kush10]

I am using this method but its fetching sys id of department and not the department name, any idea how can department name will be visible?

[drrob]

Yes, it seems that if a record has Active = false then this does not work. I didn't find a way to toggle this so far.

[suvro]

There is a before query business rule on user table which restricts non-admin users to access inactive records. You may have to do something about this. You can disable the BR and write another one to suit your needs