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

How do I wrap brackets around parameter values when using jOOq?

I am using jOOq to write queries except I am using a vendor specific type of SQL... to be specific flexible search. The main difference between SQL and flexiSearch is that parameter values are enclosed in a curly bracket. e.g. SELECT * FROM…
user1272052
  • 51
  • 3
2
votes
2 answers

Create a Report in SAP Hybris to Fetch Employees based on a User Group

I need help for creating a report in SAP Hybris which essentially would be used for fetching out the names of "Employees" not "Customers" based on the "User Group" they're assigned. For example : X employee has usergroup : "admingroup". Like that I…
minimalistic
  • 21
  • 1
2
votes
1 answer

How to exclude sub type in the hybris flexible search

In hybris, I have Created ArchivalOrderModel extends orderModel Moved Data from OrderModel To ArchivalOrderModel. (Deleted Record from OrderModel) When I fired query select {pk} from {order} In result Im getting Records of ArchivalOrderModel…
Manigandan Karthick
  • 49
  • 1
  • 6
2
votes
2 answers

How can I translate my flexible search query properly for a Java Final String query?

I'm trying to make a webservice on Hybris Commerce to return data from models. My query works for flexible search console, but I have syntax problems with my method in Java. My flexible search query: select * from {address as a join…
Emanuel Valenzuela Rolack
  • 25
  • 1
  • 7
2
votes
2 answers

Hybris relational FlexibleSearch selection

Hybris creates several carts for the user for the same base store. How to select users who have more than one cart per one store? Later on I will sort them and remove the oldest one. SELECT {u.code} as userCode, {c.code} as cartCode, …
Alexander Golovinov
  • 456
  • 7
  • 14
2
votes
2 answers

How to bump most helpful reviews to the top?

Picture this, I have a bunch of products, each product has a review section, if someone leaves a good review their review gets a like to inform that other users found it helpful. I have a table named CustomerReview, and another table named…
Felipe Marcelo
  • 73
  • 10
2
votes
3 answers

Combine Hybris Impex Remove with Flexible Search

I would like to remove some items from a table using Impex. The following example throws no errors, but nothing is removed. REMOVE ProductReference;pk[unique=true] "#% impex.exportItemsFlexibleSearch(""select {pk} from {ProductReference as pr} where…
NaN
  • 7,441
  • 6
  • 32
  • 51
2
votes
1 answer

Trying to retrieve column header of flexible search thru java

Im currently trying to retrieve the column header used in a flexible search using java. However i cannot find any method in hybris to do so. Here is my method to process the flexible search: private List> processFlexibleQuery(final…
Djamaster
  • 29
  • 1
  • 7
1
vote
1 answer

How can I get all PriceRow there are 2 at least with the same prices in the same baseStore in flexible query

I need a flexible query to get all PriceRowModel with at least 2 same prices in the same base store. It's that possible or I need a groovy script for select them?
Tomás Pizarro
  • 21
  • 2
1
vote
2 answers

How to write Flexible Search for joined tables in Hybris

I am trying to get all users which don't have addresses, there is a relation between user and address tables(one to many) and the address has an owner attribute that refers to Users pk. how can I achieve that ?? SELECT {u:pk} FROM {User AS u …
Pertsh Galstyan
  • 41
  • 7
1
vote
1 answer

Hybris OOTB ProductService can't find an existing product

I have several products registered in Backoffice, If I perform a flexible search query directly from HAC I can see any of them, however, If I use ProductService#getProductForCode that performs the same query as I do it doesn't find any products. How…
Nexussim Lements
  • 535
  • 1
  • 15
  • 47
1
vote
2 answers

Search in database table using FlexibleSearchService Hybris

I try to make a DAO what needs to search for an item in the database table. I'm pretty new in Hybris so I don't know what is wrong exactly here (query or my junk code). That is the error that appears in cmd. SEVERE: Servlet.service() for servlet…
Robert Vasile
  • 111
  • 1
  • 9
1
vote
1 answer

unable to evaluate the expression method threw 'java.lang.illegalargumentexception' exception while excuting the flexible search query

hai i am getting products details from db while exceuting the flexiblesearchservice.search(query) it is throwing this error.my flexible search query is working fine with hac. but throwing error from flexible search service. my query and service is…
mani sanakar
  • 21
  • 4
1
vote
1 answer

order entryes have multiple product with sold quantity how to get the top sold products based on how many products are sold

like i have 1000 order entry in each entry i have multiple products with sold quantity for top selling products.heaare my challange is i need return the top sold products example: order entry : product id :sold quantity;;;; entry 1 : productA …
Mani Sankar
  • 41
  • 9
1
vote
1 answer

Flexible search query works on hac, but not on Java code

I created a new ItemType (SalesData), and trying to execute a simple query via program, it's not returning any results. Where as while debugging, I copied the query and the associated query parameters and executed on hac, that query returned…
SyAu
  • 1,651
  • 7
  • 25
  • 47
1
2 3 4