Possible Values Paging and Grouping
If you have a long list of choices resulting from your possible values (PV) operation, you may see the choices "— Next – " and "— Previous – " (added automatically by WOW). You can click on the "-Next-" to see the next result of Possible Values. If you want to eliminate those choices or increase the # returned for each page of PV, increase the Row Count value in the Advanced section of your possible values operation. For example, if your Row Count is set to 25 and the total number of choices returned from your PV operation is 35, increase the Row Count to a value larger than 35. A better option for a large # of Possible Values is the Possible Values Search operation.
[Minimum Version: WOW 6.6 beta]
Recently, functionality was added to allow developers to group their Possible Values inside the drop-down menu itself. For example, a drop down may contains states and provinces that you want grouped by country to allow a more user friendly approach to find states/provinces directly for that country. Technically, behind the scenes, this new functionality uses the standard HTML optgroup element and then a padding-left CSS style added to our default theme to indent options when inside an option group. Here is an example of a possible value with the new grouping feature, in this example we’re looking at subsystems which are grouped by system area:
In the above screen shot, the following property group is set on the Possible Values operation:
PossibleValues { optgroup:AreaName; }
To use, add the PossibleValues{ } property group to the Possible Values operation and set optgroup to the name of the field that contains the optional group value.
PossibleValues { optgroup:<field name>; }
NOTE: During generation, a new option group is started when the next option group field's value changes.
NOTE: Developers should also sort their Possible Values Operation's SQL first by the optgroup field, otherwise options in the same group could/will not actually be grouped together.
TAGS: Grouping possible values, HTML SELECT OPTGROUP, drop down list grouping, Lookup list group
TODO: Add examples of the SQL for possible values.