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
1 answer

Join Table condition

I have a query with columns (code, store, slotAvailable) in which results will be shown. As for the column "slotAvailable", it will contain the number of free slots for that particular "store". Now, to calculate how many free slots there are, I can…
John
  • 15
  • 3
0
votes
1 answer

Flexible Search dynamic attribute

I have a problem with Flexible Search, I have a dynamic attribute ("available parts") in the TimeSlotInstance entity, I would like to show the value of this dynamic attribute in the "remaining availability" column of my query (obviously for each…
John
  • 15
  • 3
0
votes
1 answer

Cannot find (visible) type for alias o within [aoe:AbstractOrderEntry, oe:OrderEntryItem]

I am trying to join 2 tables in flexible search query (OrderEntryItem and AbstractOrderEntry) filtering by BaseStoreModel select {oe.pk} from {OrderEntryItem as oe join AbstractOrderEntry as aoe on {oe.abstractOrderEntry} = {aoe.pk}} where…
Tom
  • 11
  • 4
0
votes
3 answers

Flexible search is asking for session country while called from REST api

I have a code which executes a flexible search. When i am calling that code locally to search data it gives expected output but when I try to call it using REST API (Through controller) it gives error as could not translate value expression…
KUNAL HIRANI
  • 641
  • 1
  • 7
  • 20
0
votes
3 answers

flexi search inside the impex

I want to write an impex to disable an account with an particular user-id which contains the particular email id. let's say if email xyz@abc.com is associated with the user id xyx then xyz account should be soft disabled (loginDisabled should be…
arvind panchal
  • 1
0
votes
1 answer

Hybris Flexible Search fetch records created 1 hour ago

I need a flexible search query in order to fetch the products created 1 hour ago from current date, I have tried this: select * from {product} where {creationtime} < current_date - INTERVAL 1 HOUR Also this: final FlexibleSearchQuery…
Nexussim Lements
  • 535
  • 1
  • 15
  • 47
0
votes
1 answer

How extract record that not exsist

I have a query that receive two date as input ("dateFrom" and "dateTo"), now this query retur only TimeSlotInstance that have an order. Exsample : I have only monday and tuesday that have an order, the rest of TimeSlotInstance not exsisting but I…
mike
  • 25
  • 10
0
votes
1 answer

How to limit the number of results by flexible search in hybris

I want to limit the number of result using JobSearchRestriction. I want to limit not by a condition, but by "hard coded" number. Somethig like "LIMIT 10". Is it possible to do that in hybris using JobSearchRestriction?
Ricardo Machado
  • 784
  • 6
  • 22
0
votes
1 answer

Flexible Search Issue SAP Hybris

I have a problem with a Flexible Query. This is my query: Select {pp.productCode} as 'Code', {p.descriptionCics} as 'Desc CISC', {bs.uid} as 'Store', {evo.code} as 'Status', {p.department} as 'Department', {pca.name} as 'Category', {p.grm} as…
mike
  • 25
  • 10
0
votes
1 answer

Flexible Search Query Condition (if else?)

I have a question, I have to make a query where I have to show in a column the value "yes" or "no" depending on whether or not there is an image on a product. I have to join the product table this is safe but how can I tell in the query if the…
mike
  • 25
  • 10
0
votes
3 answers

How to write flexibleSearch query in hybris HAC for one too many relation?

This one doesn't work: SELECT *FROM {User as u JOIN Address as a ON {u:a} = {a:pk}} .
Roman Lototskyi
  • 692
  • 1
  • 5
  • 13
0
votes
1 answer

Need help on Flexible search query to retrieve the classification atrributes values matches with one of the classification attribute

Iam new to Flexible Search Query, I am trying to write flexible search query to retrieve the classification atrributes values matches with one of the classification attribute as below: select {ca.code} from {ProductFeature as pf join Product as p…
john
  • 15
  • 8
0
votes
0 answers

How resolve Custom Filter issue

I have create a report in myExtension-items-core.xml (that run a query where the condition is : "WHERE {bs.uid} in (?baseStorePk)") and I add a custom filter (BaseStore) in AdvancedSearch of an entity. Now when I click on button search (after choose…
mike
  • 25
  • 10
0
votes
1 answer

FlexibleSearch - search products & categories

I'm trying to do a flexibleSearch to retrieve Products and his Leaf Categories. The leaf categories are the last categories that have no other subcategories, and the categories must be of type "category" and "productTypeCategory". I try to make some…
Robert Vasile
  • 111
  • 1
  • 9
0
votes
2 answers

FlexibleSearch check null params in Report Definitions Hybris

I want to make a Report Definitions item in backoffice that will retrieve some columns. The query needs to be like this to retrieve what I need: SELECT {a}, {b} , {c} FROM {model} WHERE {d} IS NULL AND {e} IS NULL All values (a,b...e) are strings.…
Robert Vasile
  • 111
  • 1
  • 9
1 2
3
4