Getting the value of Catalog from Approval table

[n20]

Hi All

For the RITM records in sysapproval_approver table, I'm trying to get the value of catalog that the item belongs to.

I'm using 'sysapproval.cat_item.sc_catalogs' (taskGR.addQuery('sysapproval.cat_item.sc_catalog','catalogs');) to get this value but that does not give me the correct value I guess because there is no change in the number of records queried after applying this filter.

Can anyone help me to know what query should be used to get the catalog name from sc_catalog table for a given approval record.

Thanks,

Nisha

[n20]

yes, I'm passing the sys_id of catalog.

But now we are filtering with another field present in sc_eq_item table instead of catalog ,

This field is of type choice and the query is not working. Posted above.

Thanks,

Nisha

[SanjivMeher]

Try below. Make sure PT is the backend value for the display value PT.

taskGR.addQuery('sysapproval.cat_item.sc_catalog','catalog sysid');

taskGR.addQuery('u_request_type','PT');

[n20]

That is not working ,

I also tried with encoded query

taskGR.addEncodedQuery('u_request_type=PT');

Nisha

[SanjivMeher]

Can you confirm u_request_type is a String or Choice field?

Would you be able to send a screenshot of you catalog item?

[n20]

Hi sanjiv,

It is of type choice.

Nisha