How to get a report of the no of requested items tagged to a request which is more than 1 ?

[velvizhisujatha]

Hi Team, 

I wanted to generate a report to list the number of requested item records tagged to the request and display the result only if its more than one record. 

Please help!

[Maik Skoddow]

Hi @velvizhisujatha 

what exactly do you mean?

Do you want to find out records from table sc_request which have more than one referencing record at table sc_req_item?

If so you can use Related List Conditions at the Report Builder.

See the following video https://www.youtube.com/watch?v=gkzKzSXbwk0

Kind regards
Maik

[velvizhisujatha]

Thank you for the response. 

Requests might be having one or more requested items, I wanted a report to list the data which has requested item more than 1 alone. 

[Maik Skoddow]

You can also use the following URL

/sc_request_list.do?sysparm_query=%5ERLQUERYsc_req_item.request%2C>%3D1%5EENDRLQUERY

To understand how the URL is built you can read my article Bring back Related List Conditions

Kind regards
Maik

[Ankur Bawiskar]

Hi,

Are you saying you want REQ with more than 1 RITM?

Regards
Ankur