Skip to Content
Former Member
Aug 06, 2014 at 10:12 AM

solrIndexerJob and user restrictions


Hi experts,

We need to deleted index data for some products because of the expiry date (offlineDate < currentDate).

We configured delete indexer query:

 SELECT {PK} FROM {Product} WHERE ({offlineDate} < ?currentDate) 

Then we created solrIndexerJob, running as "admin" user. Admin hasn't any restriction by offline date.

BUT, when we run this job, our query do not return any rows because restriction by product's offline date (and other restrictions) still exist in SQL query passed to RDMS engine, See below log from SQLProfiler

 ...AND (( item_t0.p_approvalstatus  =  8796107538523  ) AND ((  item_t0.p_onlinedate  IS NULL OR  item_t0.p_onlinedate  <= @P7) AND (  item_t0.p_offlinedate  IS NULL OR  item_t0.p_offlinedate  >= @P8))...

Whats we are doing wrong? How do disable any product's restrictions for solrIndexerJob running as admin user?

hybris B2BAccelerator ver. 5.1.0.