Stack Overflow
Stack Overflow

Questions tagged [flexible-search]

Flexible Search is query language used to search over SAP Commerce.

Flexible Search is query language, based on SQL, that can be used to search for Commerce types and items on SAP Commerce.

Queries are written using an augmented query syntax that is automatically converted into SAP SQL behind the scenes when running the query. Flexible Search simplifies parts the queries by automatically resolving namespaces, tables and views for each data element (column).

54 questions
0
votes
2 answers

How to fetch only immediate categories of a category in Hybris?

I only expect to fetch the direct children to the parent category. But instead I get all the children to that category by using getAllSubcategories method of DefaultCategoryService class. Example: Say I have categories "Men" which has subcategories…
Techie
  • 45
  • 1
  • 1
  • 7
0
votes
1 answer

Flexible search for categories included product

I tried to create a flexible search for depending on a specific category. What I am trying to do, attract products of supercategory code '3741' but products must only belong to this category and no subcategories or supercategories. There is my…
Batuhan Doyranlı
  • 1
  • 1
0
votes
2 answers

Retrive items from database where DATE format is older than x hours or sec

I have a Cronjob that needs to take some items from DB by a condition clause. In that condition, I need to compare some Date's time and they are like (Fri Dec 18 12:36:07 EET 2020)(java.util.Date) in the database. When the query is executed, I need…
Robert Vasile
  • 111
  • 1
  • 9
0
votes
1 answer

How to get products from order, order entries, and orders status from query

I prepared a flexible search query. Here, I developed a condition like: Order status is completed in orders And order entries which are present in order Getting products which are in orderentries For this I wrote a query select {p.pk} from { …
mani sanakar
  • 21
  • 4
0
votes
1 answer

Count(*) not showing null values

I'm using Hybris by SAP for a small project and almost got this down. Im trying to find the amount of Point of Service locations with 0 Orders in the past 7 days using Flexible Search. Here is the HAC script i used: select count(*),…
HybrisNoob
  • 1
  • 1
0
votes
1 answer

How to create flexible search query with UNION & IN operator?

After executing below query i am getting UNION of all products from both catalogs "catalogA" & "catalogB" Query : SELECT uniontable.PK, uniontable.creationtime AS TIMECREATED FROM ( {{ SELECT {p:mode},{p:brandno},{creationtime}…
Raj Raichand
  • 97
  • 2
  • 9
0
votes
1 answer

How to Use ORDERBY in the flexible serach query (UNION)

I am trying to create flexible search query as below : SELECT uniontable.PK FROM ( {{ SELECT {p1:PK} AS PK FROM {Product AS p1},{Product AS p2} WHERE {p1.code} = {p2.Att1} }} UNION ALL {{ SELECT {p:PK} AS PK FROM…
ASMA2412
  • 61
  • 1
  • 5
0
votes
3 answers

SELECT random rows with flexible search query

I am trying to create a Flexible Search that retrieves 10,000 random rows out of 3M. Tried with different syntax like LIMIT, but i cannot make it work, I need to add this query to a Groovy Script. Thought about creating a random number and retrieve…
Mauricio Jimenez
  • 11
  • 1
-1
votes
1 answer

Flexible Search Query UNION

I would like to add a UNION to this query , Where exactly Should I put any UNION (doesn't matter the code of the UNION , I just want to know where can I put it) in the following Flexible Search Query (I'm not familiar with the Syntax) SELECT…
Nexussim Lements
  • 535
  • 1
  • 15
  • 47
1 2 3
4