Query Attributes
At times, it can be useful to define an attribute whose value is determined when it is used, not when it is defined. To this end, DataSplice allows for query-based attributes to be set up. These types of attributes get their values by performing dynamic lookups against DataSplice views. When online, these lookups are done against the underlying database tables. When offline, they are performed against the view data that has been downloaded to the DataSplice Remote Client.
DataSplice 2.3.x
In DataSplice 2.3.x, dynamically-evaluated attributes were strictly limited to query attributes. These attributes were created by prefacing the attribute value with the word QUERY: . This was then followed the view and field in question, the criteria to evaluate, and optionally an order by clause:
viewis the DataSplice view to query. View names containing white space should be quoted, e.g. view = "View Name";.fieldcontains the name of the field of interest. The field must match the corresponding field’s display name from the DataSplice view. If the display name contains white space, then the value should be quoted, e.g. field = "field display name";.wheredetermines which row will match. Again, field references must match their corresponding display names, and any names containing white space need to be surrounded by double-quotes.
DataSplice 3.0.x
In DataSplice 3.0.x, query attributes are still supported, but the functionality has been expanded to incorporate a robust attribute expression language. Any type of complex attribute, including query attributes, now begins with := and is then followed by basic logical operators and functions.
Traditional query attributes can still be used by prefacing the attribute value with := query. The information that then follows is similar to the syntax format of query attributes in DataSplice 2.3.x.
Additional Information
For additional information about the syntax and supported functions of the attribute expression language, see the corresponding attribute expression language reference section of the DataSplice Administration Client manual.
Last modified 2005-12-08 12:25 PM
