Restrictions are not applied on Catalog Sync Job

[Former Member]

Hi All, I have a requirement to synchronize only approved Products. For this I created a Search Restriction as

 {approvalStatus}=({{select {a.pk} from {ArticleApprovalStatus as a} where {a.code}='approved'}})

and associate a User for that restriction. Assigned the same User to CatalogVersionSyncJob as sessionUser. Now When am doing a single product synchronization, it synchronized even though approval status as Check.

Note: We are using Hybris 5.7 version.

If I missed anything to that work, please give me some pointers.

[Former Member]

Hi,

I think you need to create a JobSearchRestriction on the job

 INSERT_UPDATE JobSearchRestriction; code[unique = true] ; type(code); job(code); query
                                   ; approvedRestriction ; Product   ; yourJob  ; "{approvalStatus}=({{select {a.pk} from {ArticleApprovalStatus as a} where {a.code}='approved'}})"

[Former Member]

Tried, still not working.

[Former Member]

Another way is to assign a user for your job and apply a restriction on that user