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
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 12:03] (current) – [Outer joins] 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}}
 +WHERE {p.modifiedtime} >= '2020-10-01'
 +  OR {a.modifiedtime} >= '2020-10-01'
 +ORDER BY {p.baseStore}, {p.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