meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
sap_hybris_commerce:import_export:examples-of-flexible-search-queries [2019/08/19 14:59] – Antonio Robirosasap_hybris_commerce:import_export:examples-of-flexible-search-queries [2020/06/29 11:51] – left outer join Antonio Robirosa
Line 39: Line 39:
  WHERE {vi.status} = 'confirmed'  WHERE {vi.status} = 'confirmed'
 </code> </code>
 +===== Outer joins =====
 +  * Modified point of services or their address
 +<code sql>
 +SELECT {p.pk }
 +FROM {PointOfService as p
 +LEFT OUTER JOIN Address as a
 +  ON {p.address} = {a.pk}
 +  AND {a.modifiedtime} >= '2020-10-01'}
 +WHERE {p.modifiedtime} >= '2020-10-01'
 +ORDER BY {p.baseStore}, {creationtime} DESC
 +</code>
 +
 ===== Subqueries ===== ===== Subqueries =====
   * Get the pk of the warehouses which have at least one plzRange.   * Get the pk of the warehouses which have at least one plzRange.
Line 135: Line 147:
   * The question marks must be replaced with the values of the Hybris' type and catalog versions PKs. You can see these values on the tab "Execution statistics"   * The question marks must be replaced with the values of the Hybris' type and catalog versions PKs. You can see these values on the tab "Execution statistics"
  
-{{:sap_hybris_commerce:import_export:hacrunflexiblesearchquery.png|HAC - Flexible Search console}}Running a Flexible Search Query on HAC+{{ :sap_hybris_commerce:import_export:hacrunflexiblesearchquery.png |HAC - Flexible Search console}}Running a Flexible Search Query on HAC
  
-{{:sap_hybris_commerce:import_export:hacrunrawsqlqueries.png|See the raw SQL on the flexible console}}How to see the raw SQL on the Flexible Search console on HAC+{{ :sap_hybris_commerce:import_export:hacrunrawsqlqueries.png |See the raw SQL on the flexible console }}How to see the raw SQL on the Flexible Search console on HAC
  
-{{:sap_hybris_commerce:import_export:hacflexiblesearchseereplacedparameters.png|Flexible Search query's replaced parameters}}How to see what parameters where replaced on the query+{{ :sap_hybris_commerce:import_export:hacflexiblesearchseereplacedparameters.png |Flexible Search query's replaced parameters}}How to see what parameters where replaced on the query
  
 -- Based on Hybris 6.6 -- Based on Hybris 6.6