If filters have been created for the table that a given node retrieves, they will automatically appear when you click on the node in the UDM Editor. You can choose to apply those filters and save the UDM. All applied filters will be applied together, in conjunction, like an AND connection.

Filters also appear when you click on a value range if they have been created for the table that the value range is dereferenced to. Consider a situation where you want to limit the data listed in a State combo to the states that a user has access to. You can create a predicate that expresses the business logic that generates such a list (states in the region that the user lives in, for example) and then apply that predicate on the value range.

Foreign keys have dereferencing values that automatically show meaningful values on screen. For example, when you include a foreign key to the State table from an Address tab le and include that relationship in the schema you submit to zeroCode at generation time, the UDM Editor recognizes the relationship and automatically dereferences the state ID to the state code. By default, dereferenced values come from the first column after the key column in the table. You can click on the foreign key column in the UDM Editor and select a different column to dereference to.

zeroCode, starting from the root, child and to the siblings, including the attributes in the corresponding nodes will generate the ID automatically. As an example 0 will be the ID for the root node and 1 will be the ID for the first child node that gets created for the root node and so on. The tag name will be 0-1 for the first created child node where 0 is the Id of the root node and 1 is the ID of the first child node. It is through this ID only that zeroCode identifies the references and passes/retrieves the values to/from the database.