hybris: FlexibleSearch JOIN queries on particular CatalogVersion
by admin on Apr.27, 2020, under Programming, Random()
The following snippet is how to run a JOIN query in Flexible Search:
SELECT {pk} FROM {Media AS m JOIN CatalogVersion AS cv ON {cv.pk}={m.catalogVersion}} WHERE {cv.version}='Online'
This will return all Medias that are in an Online catalog version.
-
Welcome
This blog was designed to be filled with articles related to some of our more recent projects, macOS and linux guides (particularly Debian), coding and plenty of other topics.
Navigator:
