mwo object sync based on customer

Hi, 

You may use the Equipment object entity delivery method as Batch and use the filter method as Include.

Did you try that?

@Dakshinie Wickramasinghe 

Yes,  

whether this syntax is correct or anything need to be changed which used in the where condition.

&0.MCH_CODE IN (SELECT t.mch_code FROM EQUIPMENT_OBJECT_UIV t,  JT_TASK_LIGHT_UIV jt WHERE t.owner = jt.customer_no AND t.owner = &0.OWNER)

Hi @archarisp , 

If you want to add the entity filter, in sync rule filter method change to include if you want to include that filter. 

Filter Method can be Exclude or Include, which determines how Permission Set Filters will be combined with the default where condition.

By default, the Filter Method is set to Exclude, combining the default where condition and the Permission Set filters with an AND, effectively restricting the dataset.

Furthermore, add the user permission set to the Security Group and Entity Filters and clear the cache. 

Best Regards,
Kalana

@Kalana Rathnayake @Dakshinie Wickramasinghe ..

Thank you

"I followed the steps mentioned above, but I didn't get the desired output. 

I'm suspecting an issue with the syntax of the following query:

Any suggestions would be appreciated.

`&0.MCH_CODE IN (SELECT t.mch_code FROM EQUIPMENT_OBJECT_UIV t, JT_TASK_LIGHT_UIV jt WHERE t.owner = jt.customer_no AND t.owner = &0.OWNER)`"

Hi @archarisp , 

EQUIPMENT_OBJECT_LEVEL doesn’t contain MCH_CODE. That is the syntax issue with this code. 

Best Regards,
Kalana

Hi @Kalana Rathnayake,   we have chosen the entity equipmentobject .. only.. but still not getting the desired output..Thanks for confirming on the Syntax.