From the Queries Manage Columns Form, select Path.
Use the Path Editor to choose the column, or related column, for an object.
Note: Go to the Path Editor section for more information on how to set up paths.
In the Property Name field, enter the column name.
Use the checkboxes to assign the column as one or more of the following:
Property: Property columns can be seen and used when a query is being built or maintained in Dovetail Agent.
Output Column: Output columns are seen in the Queries Results form.
Sort Column: Sort columns can be selected during query editing, and are reflected in the query result ordering.
Record ID: A Record ID column is used as the unique database identifier when a record is retrieved from the database. Database tables automatically get the objid field added to the end of the query record, so there is no need to add this column to the Queries object definition. Views, however, do not use the objid field in every case as the unique database identifier, so this column can be very useful. For example, the site_view database object uses the objid field to identify the site record, so this would be the column to add to the Queries object definition as the Record Id column. This would allow the OpenSiteWindow function to be used to open the site object from the query results grid.
Data Res.: Data Restriction columns are used for data restriction. See the data restriction section for more information.
To select the list type the column is associated with, use the radio buttons:
No List: Select if no pre-defined list is required.
Clarify List: Select if a pre-defined Clarify List is required. Once selected, use the new dropdown box to select the list.
User-Defined List: Select if a pre-defined User-Defined List is required. Once selected, use the new dropdown box to select the list.
To specify a function that will be applied to a query result column, enter a function in the Output Function field. You can enter a function or select one from the dropdown list which contains common Dovetail Agent functions. This list can be modified in the inc_functions.asp file found in the Dovetail Admin include folder. Any function can be called by specifying it on this form, and by supplying it as a server-side function to the Dovetail Agent grid_ce_results.asp page. Each Output Function definition must include the keyword value, which is what gets replaced with the query output column value when the function is executed. Some examples of usage for this functionality are listed here:
PrettyDate(value): This formats the date string as the Clarify GUI would, resulting in "January 1, 2005" or "?/?/?" for example.
Percentage(value): This will convert a fraction into a percentage, i.e. .22 becomes 22%.
formatDate(new Date(value),"MMM dd yyyy hh:mm a"): This converts the date string to a date object, and formats it as specified by the format clause.
