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

[SanjivMeher]

Can you post the current script you have now?

[n20]

Hello everyone,

The query that worked is:

taskGR.addEncodedQuery('sysapproval.ref_sc_req_item.u_request_type=PT');

The field u_request_type is created in sc_req_item table, and so we use the above syntax to access the reference table and field.

Thanks for all your replies.

Nisha