Quick start with Hybris Development

Scenario 1: I want to remove all the data from the Hybris ItemType. Solution: If you want to remove all records for particular itemType. Then you can do it using HAC Impex import. Open HAC (/hac) Go to console > ImpEx Import Run the below Impex (Change MyItemType with the ItemType for which you want to remove the data) $targetType=MyItemType REMOVE $targetType[batchmode=true];itemtype(code)[unique=true] ;$targetType Scenario 2: Sometimes, you want to remove selected data based on some condition or probably want to run complex SQL query. Then we wish if we could do it by writing SQL query, as many of developers are aware of syntax and its resources are easily available. Solution: Yes, you can do it in Hybris HAC also. Only thing is you should know the appropriate table and attribute/fields names in DB. If you don't, you can always run the select flexible search query and can see generated SQL query. Open HAC (/hac) Go to console > FlexibleSearch Se

In this post, you will learn how to install and configure a standalone Solr server in a way that can be used in SAP Hybris Commerce. Prerequestion solrserver  extension should be there in your  localextensions.xml  file Hybris OOTB Solr configuration background The default configuration is as follows: solrserver . instances . default . autostart = true solrserver . instances . default . mode = standalone solrserver . instances . default . hostname = localhost solrserver . instances . default . port = 8983 solrserver . instances . default . memory = 512m Here, you can see  autostart=true  which tell Solr server to start and stop together with the Hybris platform. In another word, we can say default configuration ensures that a standalone Solr server is configured, started and stopped together with the platform. Setup external Standalone Server As we have seen, OOTB (post hybris v5.5) solr server is already configured as standalone server  mode=standalone . It mean

Use of Enum in the query Find all running Solr Index jobs select {cj.code},{enum:code},{cj.startTime},{cj.endTime} from { SolrIndexerCronJob! as cj join EnumerationValue as enum on {cj.status}={enum.pk} } where {enum:code} = 'RUNNING' Compare Date in the flexiblesearch query Find all running Solr Index jobs from the given date select {cj.code},{enum:code},{cj.startTime},{cj.endTime} from { SolrIndexerCronJob! as cj join EnumerationValue as enum on {cj.status}={enum.pk} } where {enum:code} = 'RUNNING' and {cj.startTime} >= TO_DATE('2021/12/25','YYYY/MM/DD') Basic  JOIN  and  IN  query Get the most recent order for each customer using flexible search. select {o.code} as orderCode, {c.name} as name, {a.cellphone} as cellphone from {order as o join Customer as c on {c.pk} = {o.user} join Address as a on {o.deliveryaddress} = {a.pk} } where {o.code} in ({{select max({cod