Join two tables in Related List Condition

[Greg92]

Hi! Is there any way to join two tables in Related List Condition, instead of doing to via DatabaseViews?

[Greg92]

I need to create a report of Change Requests, waiting to be approved. The report should be grouped by the approvers name. I was able to do it via database views by joining change_request and sysapproval_approver tables, but wondering if I can do the same via related list

Thank you

[Adam Stout]

Related List Conditions don't work on views and I believe sysapproval_approver has a document id field and not a real reference.  You may have to use a dynamic filter option to get this.  Can you just report on the view that joins change_request and sysapproval_approver or do you need only one record per change?

[Sushant Kadam1 · Accepted solution]

Hi,

You can specify single to query on a current table record while creating a related list.

Please mark correct/helpful if my response helps you.

Regards,

Sushant