beta.blog

Random()

hybris: FlexibleSearch JOIN queries on particular CatalogVersion

by 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.

Leave a Comment :, more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!