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