Filter data with conditions
A WHERE clause can be added to Alfabet queries to limit the search results to a subset of the objects defined for the base class or the object classes added to an Alfabet query by means of a JOIN . An object class property of an object class is compared to a given value in a WHERE clause. For example, you can limit the search output to objects with a name starting with "A" or with a start date before the current date.