Understanding Flexible Search Syntax

Objective

After completing this lesson, you will be able to Interpret various examples of syntax in Flexible Search queries to receive specified results from the SAP Commerce Cloud database.

Flexible Search Syntax

Now that you’re familiar with the capabilities of Flexible Search, let's focus on how to write Flexible Search queries.

The following eight videos present various aspects of writing and executing search queries.

  • View this video to know the basic Flexible Search syntax, including examples: 
  • View this demo to learn how to execute queries in the HAC Flexible Search Console: 
  • View this demo to learn about the Join syntax:
  • View this demo to learn how to use the Join syntax:
  • View this demo to learn how Joins for one-to-many relations works:
  • View this demo to learn how joins for many-to-many relations works:
  • View this demo to learn how subqueries in Flexible Search work: 
  • View this demo to learn to use dates in Flexible Search: ​

Log in to track your progress & complete quizzes