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

Specific type code is invalid and Method Invocation impex.exportItemsFlexibleSearch error

Asking for your help, I don't know why I'm still getting these errors :( 20.06.25 18:47:40:992 ERROR line 3 at main script: Flexiblesearch error: type code 'StockLevel ' invalid 20.06.25 18:47:40:992 ERROR line 3 at main script: query was…
Gavz
  • 33
  • 8
1
vote
4 answers

FlexibleSearch query to fetch one-day old records

Is there a way to do flexiblesearch query for fetching one-day old records? Something like: select * from {table} where {conditions} where {conditions} are old-day old records?
vigneshwaran sundarrajan
  • 21
  • 6
1
vote
0 answers

Fetching a category and its sub/nested categories using Flexible Search

I am trying to prepare a dynamic flexible query to fetch a category including its all sub/nested categories. Hybris keeps category relation in CategoryCategoryRelation and if I join the table itself it doesn't give a category if it doesn't have any…
Winston
  • 1,800
  • 2
  • 20
  • 30
1
vote
2 answers

Oracle: How to check if value exists in a collection type column?

Let say I've two tables, Table A PK SIZE 89733 5 83644 3 87351 8 84423 11 Table B ID Table_A_PK 1 89733,83644,86455 2 87351,89542 3 84132 4 84566,84646 Note: Column Table_A_PK is…
Junaid
  • 664
  • 5
  • 18
  • 35
1
vote
1 answer

Hybris Flexible search union query to fetch products

code Attribute1(String) A C B D C Empty D Empty how to get the pk's of all A,B,C,D Note: Using the string value C,D I want to fetch pk of product C,D along with A,B using Flexible search…
User2413
  • 605
  • 6
  • 22
  • 51
0
votes
1 answer

Combining 2 different queries in flexible search

We plan to create a delete operation in one of our custom indexers. A document in this indexer consists of several categories and product. When we delete a category, we store it in a new table called SolrDeletedItem. For products, we only set the…
iamrooovic
  • 47
  • 6
0
votes
0 answers

flexiblesearch query parameter for list of orders

i have this flexisearch code: import de.hybris.platform.core.model.order.* import de.hybris.platform.core.model.product.* import de.hybris.platform.jalo.flexiblesearch.FlexibleSearch; query = """ Select {o:code}, {p:code}, {oe:rrp} from { …
dprian
  • 25
  • 7
0
votes
1 answer

Hybris ImpEx - how to export all Orders, which contain a specific coupon code

I want to export all items of type Order, which contain a coupon code named 'TESTCOUPON'. However, when I try to do it, I get this error: ERROR line 4 at main script: error executing code line at 4 : SQL search error - ORA-00932: inconsistent…
Vasil Peykov
  • 3
  • 1
0
votes
2 answers

Flexible Search for fetching Email

I am very new to SAP Commerce and have been experimenting with Flexible search. Some queries work i.e and some dont. Below one works fine. 1) Select * {User} SELECT {user.pk} FROM {User AS user} 2) SELECT {user.pk}, {ItemType} FROM {User AS user}…
user20819930
  • 3
  • 4
0
votes
2 answers

Need to retrieve orders from database based on below condition

I am writing a Flexible Search query to get the orders from database and delete them. The condition to get the orders is that : if the order is placed 3 months before the current date, I need those orders to be deleted from db. Example: currentDate:…
user19030239
0
votes
1 answer

How to concatenate multiple rows in flexibleSearch query in Hybris

My query is returning multiple rows for each group that the user is assigned to, example below: I need to concatenate each group on a single row for each user, like: groupA, groupB, groupC I tried using SUBSTRING, SUB SELECT, GROUP_CONCAT.. Nothing…
Teilor Miotto
  • 3
  • 1
0
votes
0 answers

At least one value is true in flexible query

I have this query SELECT {p.productId} as productId, {p.price} as price, {p.store} as store, count(*) FROM {PriceRow as p} where {p:isPromotional} = 1 GROUP BY {p:productId}, {p:store}, {p:price} HAVING count(*) > 1 And I need to add at least one…
Tomás Pizarro
  • 21
  • 2
0
votes
1 answer

Hybris export data of two joined tables using flexible search

I am new to Hybris. what I am trying to do is Export Data (code from product and name from catalog) of two joined tables using flexible search. I Wrote a query but cant understand how use it as impex export. This will be My Query SELECT…
Pertsh Galstyan
  • 41
  • 7
0
votes
0 answers

Get order code from order entry in flexible search

I'm trying to get the order code from an OrderEntry. For now I have this query, that brings me the PK from Order but I need the ordercode. SELECT * from ( {{ SELECT {o.order} FROM {OrderEntry as o} WHERE {o.message} is Null }} )
Tomás Pizarro
  • 21
  • 2
0
votes
2 answers

join in flexi search is not working with is null keyword

I have a table named as aviationDispute which has 2 columns deliveryId type=aviationdelivery and invoiceId type=AviationB2BDocuments , now when we raise a dispute from post man it will be eith against a delivery or either against an invoice both the…
siddarth
  • 1
  • 1
1
2
3 4