Event aquery_decode_criteria_after

This event is used for representations, when a query facet is requested. It allows the development partner to add properties to the columns that can be criteria for the query in the &where=... filtering option.

• If the class is persistent, the columns are already defined, but they can be completed or changed.
• If the class is an Interface type, no table description is filled. The development partner must fill the parameters.

Available variables

• No current instance is defined. this is not available.
• The tables that are read when the request is done on a query facet are in a Link abbreviated with [LNK_], but the columns are present in the class [F:abbrev] (where abbrev is the abbreviation used to declare the table in the class definition).
• NBPRO is the variable defining the number of properties present in the query facet.
• TPPTH is an array containing the properties present by default in the query facet.
• TBPRO is an array containing the alias associated with the properties present by default in the query facet.
• TBFIL is an array containing the column name in the table that fills the query facet.
• TBTYP is an array containing the data types of the properties present by default in the query facet. The different values available for TBTYP are the following:

Example

# This piece of code has to be called by Gosub on the AQUERY_DECODE_CRITERIA_AFTER event# Here, the class managed is an interface class# So the "pseudo table" has directly been declared with [LNK_] abbreviation.$ FILL_CRITERIANBPRO += 1 TBPRO(NBPRO) = "VOLUME"TBTYP(NBPRO) = 7 TBPTH(NBPRO) = "AVOLFIL.VOLUME"TBFIL(NBPRO) = "[LNK_]VOLUME"NBPRO += 1 TBPRO(NBPRO) = " FULLNAME"TBTYP(NBPRO) = 7 TBPTH(NBPRO) = "AVOLFIL.FULLNAME"TBFIL(NBPRO) = "[LNK_]FULLNAME"Return