Maintenance List Filters

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.

You can modify the SQL that will be used for the list retrieval by writing an 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 there is one) 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. However, a select clause should not be specified; instead, results can be added in the bindList user exit (see below). And neither should be an order by (the order by is to be 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.

Finally, you can bind parameters and also specify extra results into the query in the bindList user exit specific for the given list.