Help with the Databse view

[sk56]

Hi,

I need help with the database view. Please bring up the sc_req_item table. 

With the help of the database view below, we need to figure out the REQ and RITM approver for a few catalog items.

Records generated via catalog item A have the approval record on the RITM level, and the records generated via catalog item B have the approval records at the REQ level. 

Thanks

[anshul_goyal]

Hi @sk56,

You might want to try using an underscore (_) instead of a dot (.) in the WHERE clause of your query; that could work for you.

Please mark my solution as Helpful and Accepted, if it works for you in any way!

Thanks

[sk56]

I tried to replace Dot with _underscore. unfortunately, it didn't work

Thanks