catalgo task assignment group is different from assignment group

[Sathiskumar_D]

Hello,

I am trying to create a report where parent task type "catalog task" assignment group is not same as requested item?since I am pulling "task" table in the report, I can't get it done. Any help would be greatly appreciated.

[Bhavani Shankar]

Since you are comparing values from records of two different tables this cannot be done using the default filter condition options.

Using related conditions also won't work because of the same reason.

Please do leave a thumbs up if my response helped you.

[Sathiskumar_D]

nvm..I found the solution without script. 

[Bhavani Shankar]

Hey, please do share the solution here. It will be helpful for future readers.