A given list on a maintenance may not need to return all the data in the list. Instead, a filter can be applied to return a subset of the data. You get the main list by default. And now, you can modify the SQL that will be used for the list retrieval by writing HQL to filter the list. This HQL goes into the @List annotation's "fromClause" and "whereClause" properties. This is written as an HQL filter HQL, where the main table (and its language alias, if one exists) already "exists" in the background, and can be referenced by the alias "this" (and "thisLang" for the language row). New entities can be added to the 'from' clause, and a 'where' clause can be specified. A select clause should not be specified (instead results can be added in the bindList user exit - see below), and neither should an order by (the order by is specified separately).

Additionally, if there are extra values that can be retrieved via a join, the loose data fields can be specified as @ListDataField , with an hqlPath property specifying the hql path to select the result. And finally, you can bind parameters and also specify extra results into the query in the bindList user exit specific for the given list.