unable apply filter condition on schedule task assigned to

[Former Member]

Actually i'm getting an error msg wen trying to apply the filter condition on below t2.rem_receiver_object_name join fci_contract table as t1

and fci_con_scheduleitem t2

then i want to add filter prompt based on condition t2.rem_receiver_object_name i.e under schedule task assigned receiver name.

kindly find the below code & error message

<%AND_OP("UPPER(T2.REM_RECEIVER_OBJECT_NAME)",<%?T2.REM_RECEIVER_OBJECT_NAME%> ==>under query tab in query definition

error message:

"more informtiona is needed to identify a query group or query .contact ur system adminstractor.

[former_member207877 · Accepted solution]

Hi Siva,

Use REM_RECEIVER_OBJECT_ID instead of  REM_RECEIVER_OBJECT_NAME and check.

Regards,

Raj