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 15:02] – [Conversion of Flexible Search to SQL] 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.