Columns Heading: How to use their action menu

Columns Heading: How to use their action menu



Column Heading Menu 

Clicking on any column heading exposes a column heading menu.

 

Options include:
Sort Ascending           icon sorts the report by the column in ascending order.
Sort Descending        icon sorts the report by the column in descending order.
Hide Column              hides the column. Not all columns can be hidden. If a column cannot be hidden, there will be no Hide Column icon.
Break Column            creates a break group on the column. This pulls the column out of the report as a master record.

Column Information displays help text about the column, if available.
Text Area is used to enter case insensitive search criteria (no need for wild cards). Entering a value reduces the list of values at the bottom of the  menu. You can then select a value from the bottom and the selected value will be created as a filter using '=' (for example, column = 'ABC'). Alternatively, you can click the Flashlight icon and enter a value to be created as a filter with the 'LIKE' modifier (for example, column LIKE  '%ABC%').
List of Unique Values contains the first 500 unique values that meets your filter criteria. If  the column is a date, a list of date ranges is displayed instead. If you select a value, a filter will be created using '=' (for example, column = 'ABC').



    • Related Articles

    • Action Menu: How to build up a User-defined View

      HOW TO CREATE A USER-DEFINED REPORT VIEW : ACTION MENU Many pages in Optima offer the powerful ACTION MENU, a core feature of Oracle APEX, which facilitates the creation of personalised visualisations of compiled information that can be saved as ...

    • Action Menu: How to use it

      HOW TO USE THE ACTION MENU The Actions Menu appears to the right of the Go button on the Search bar. Use this menu to customise an interactive report. action menu Select Columns Used to modify the columns displayed. Columns You can reorder the ...

    • REPORT MENU

      ACCESS TO THE OUT OF THE BOX REPORTS This page offers a set of pre-made reports related to instruments, people, tasks, and more, to provide useful information about occupancy, dedication, productivity, and capacity. Default reports are based on our ...

    • Report Optima Use

      Use of Optima The two sections below give a view of how the system Optima is used by all users allocated to a specific location. Optima Use This section allows to view the user's activities on Optima at the different hours of the day, based on a ...

    • Report Use of Scheduling Features

      How to work with the Report page of "Use of Scheduling Features" Access to the Use of scheduling features report is from the Icon below on main report page. In this section, it is possible to select a specific timeframe (ranging from 15 minutes to 4 ...