These settings allow you to Group and/or Sort the online Grid results by selected Columns.
Group Index
To group the Grid by a particular Column, set that Column's Grid Index to a number above 0 (zero).
If you are grouping by one Column, you can just set that Column's Group Index to 1, and leave the other Column Group Index numbers set at 0 (zero).
If you are grouping by multiple Columns, set their Group Index numbers in the order you want them grouped, e.g. the grid will be grouped by the Column with Group Index 1 first, then the Column with Group Index 2, then 3, and so on.
If you are not grouping by certain Columns, their Group Index numbers can be left as 0 (zero).
Sort Index
To sort the Grid by a particular Column, set that Column's Sort Index to a number above 0 (zero), AND set the Sort Direction you want to use.
If you are sorting by one Column, you can just set that Column's Sort Index to 1 and select a Sort Direction. You can leave the other Column Sort Index numbers set at 0 (zero).
If you are sorting by multiple Columns, set their Sort Index numbers in the order you want them sorted, e.g. the grid will be sorted by the Column with Sort Index 1 first, then the Column with Sort Index 2, then 3, and so on. Remember to set their Sort Directions, as well.
If you are not sorting by certain Columns, their Sort Index numbers can be left as 0 (zero).
Sort Direction
After you set a Sort Index for a particular Column, you also need to specify in which direction you want the Grid sorted by that Column.
For each Column assigned a Sort Index number above 0, select a Sort Direction from the drop-down: Ascending or Descending.
Leaving the Sort Direction set to None means that the Grid will not be sorted by that Column.
Sorting Example
In this example of the Event Grid on the Home page, we have adjusted the Sorting settings as follows:
1.Date From:
a.Sort Index: 1
b.Sort Direction: Ascending
2.Function Start Time:
a.Sort Index: 2
b.Sort Direction: Ascending
For the rest of the Columns - Date Range and Event - the Sort Index stays at 0, and the Sort Direction stays as None.
Note: We have also unchecked the Visible checkboxes for the Date From and Function Start Time columns, so that they will not be visible in the online Grid. We wanted to use these Columns for sorting purposes, but not actually display them online
Figure 681: Sorting Columns
The resulting online grid will display the Events sorted first by Date From, and then by Function Start Time (although you won't actually see the Date From or Function Start Time columns).
Figure 682: Sorted Grid in EPConnect
Grouping & Sorting Example
In this example of the Location Information Grid on the New Booking Location Info page, we have adjusted the Grouping and Sorting settings as follows:
1.Booked Date:
a.Group Index: 1
2.Function Start Time:
a.Sort Index: 1
b.Sort Direction: Ascending
3.Function End Time:
a.Sort Index: 2
b.Sort Direction: Ascending
4.Other Columns (Location, Description, Charge):
a.Group Index: 0
b.Sort Index: 0
c.Sort Direction: None
Figure 683: Sorting & Grouping Columns
The resulting online grid will display the Booked Locations grouped by Date.
Within those groups, the Booked Locations will be sorted by Function Start Time, and then Function End Time.
Return to Common Column Settings
