Axiom features a number of style and display options accessible in the rightmost column of the query design.
Changing Column Background Color
The background color of columns in the results grid can be changed. To do so, select the field from the query and click on the “Style” tab in the field properties section to the right. Click on the “Background Color” color menu and then select a color from the spectrum. Colors can also be selected by entering a hexadecimal code (a six-digit number used to represent colors) into the box below the color spectrum.
Date and Time Format
The following are supported date/time formats in Axiom:
- m/d/y, 12 hr
- d/m/y, 24 hr
- y-m-d, 24 hr
The format is set by an engineer, typically during implementation. Specific date/time fields might have their own display formatting and thus look different, but the underlying date/time data always conforms to one of the above formats.
Overriding Display Format
The format of certain data can be modified.
For example: a user may want a date to appear in the results with the month spelled out, rather than in the default mm/dd/yy format.
To change a display format in query results, select the field from the query, click on the “Style” tab of the field properties section, and enter the new format into the “override display format” box.
Override display formats are generally universal and are most often used with dates and times. The following are some of the more common format overrides:
|m||Month as a number with no leading zeros|
|mm||Month as a number with leading zeros|
|mmm||Three letter abbreviation of the month (i.e. Dec)|
|mmmm||Full name of the month (i.e. December)|
|d||Day as a number with no leading zeros|
|dd||Day as a number with leading zeros|
|ddd||Three letter abbreviation of the day of the week (i.e. Mon)|
|dddd||Full name of the day of the week (i.e. Monday)|
|yy||Two digit year|
|yyyy||Four digit year|
|h||Hour as a number with no leading zeros (use capital H for 24-hr time)|
|hh||Hour as a number with leading zeros (use capital H for 24-hr time)|
|n||Minutes as a number with no leading zeros|
|nn||Minutes as a number with leading zeros|
|s||Seconds as a number with no leading zeros|
|ss||Seconds as a number with leading zeros|
Users can group together columns of data to give a clearer visual display of results. Columns can be grouped together if they are next to each other in the query.
To create column groups, select a field from the query, click on the “Style” tab of the field properties section, and assign a column number in the “column group” box. Add subsequent columns to the group by repeating the process and assigning them the same column number. When columns are grouped together, the override description of the first field in the group will be used as the group header.
The description must be modified using the override description in order for column grouping to work.
In addition to adding background colors and grouping columns, users can also apply a series of advanced options to columns to further customize the visual display of query results:
|Highlight When Populated||Any grid cells containing data in the column will be highlighted.|
|Highlight When Not Populated||Any grid cells missing data in the column will be highlighted.|
|Highlight When Data Invalid||Grid cells in the column where data is invalid will be highlighted.|
|Highlight Alternating Groups||Subsequent grid cells containing like data in this column will be grouped together by alternating highlights.|
|Lock Column||Freezes that column, as well as all columns to the left, in place to allow the user to maintain a view of that column’s contents while simultaneously scrolling through the remaining columns.|
|Suppress from Export||Column data is displayed in the results grid but is not included in a data export (currently only Excel is supported).|
|Suppress from Results||Column data is not displayed in the results grid.|
To set an additional column option, select the field from the query and click on the “style” tab in the field properties section, and then choose the appropriate option from the “column options” drop-down list.
It is important to note that only one column option can be applied to a field at a time.
Several keyboard shortcuts exist to allow the user to more quickly navigate and manage queries. Available shortcuts include:
|(ENTER) key on keyboard||Equivalent of clicking the “run query” button in query design.|
|( ` ) key on keyboard||Quickly opens the rocket ship which shows a list of available user homepages.|
|(SHIFT) + ( ` ) keys on keyboard||From a homepage, quickly opens user favorites window.|
|( / ) key on keyboard||From a homepage, opens the search window.|
|PC: (CTRL) + (S)|
Mac: (CMD) + (S)
|From a detail screen, saves any updated data.|