Advanced Display Options

Overview

Axiom features a number of style and display options accessible in the rightmost column of the query design.

Field Style

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:


FORMAT
DESCRIPTION
DATES
mMonth as a number with no leading zeros
mmMonth as a number with leading zeros
mmmThree letter abbreviation of the month (i.e. Dec)
mmmmFull name of the month (i.e. December)
dDay as a number with no leading zeros
ddDay as a number with leading zeros
dddThree letter abbreviation of the day of the week (i.e. Mon)
ddddFull name of the day of the week (i.e. Monday)
yyTwo digit year
yyyyFour digit year
TIMES
hHour as a number with no leading zeros (use capital H for 24-hr time)
hhHour as a number with leading zeros (use capital H for 24-hr time)
nMinutes as a number with no leading zeros
nnMinutes as a number with leading zeros
sSeconds as a number with no leading zeros
ssSeconds as a number with leading zeros

Column Groups

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.

Advanced Options

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:

COLUMN OPTION
DESCRIPTION
Highlight When PopulatedAny grid cells containing data in the column will be highlighted.
Highlight When Not PopulatedAny grid cells missing data in the column will be highlighted.
Highlight When Data InvalidGrid cells in the column where data is invalid will be highlighted.
Highlight Alternating GroupsSubsequent grid cells containing like data in this column will be grouped together by alternating highlights.
Lock ColumnFreezes 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 ExportColumn data is displayed in the results grid but is not included in a data export (currently only Excel is supported).
Suppress from ResultsColumn 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.

Keyboard Shortcuts

Several keyboard shortcuts exist to allow the user to more quickly navigate and manage queries. Available shortcuts include:

SHORTCUT
DESCRIPTION
(ENTER) key on keyboardEquivalent of clicking the “run query” button in query design.
( ` ) key on keyboardQuickly opens the rocket ship which shows a list of available user homepages.
(SHIFT) + ( ` ) keys on keyboardFrom a homepage, quickly opens user favorites window.
( / ) key on keyboardFrom a homepage, opens the search window.
PC: (CTRL) + (S)
or
Mac: (CMD) + (S)
From a detail screen, saves any updated data.