Useful links : |
|---|
Search & filters (Action Button)
Filters hide superfluous data. So you can focus on what you want to see
In AGILAB you will have the possibility to perform several actions, reorganize the default view and customize
an interactive report by using the filters in the Actions button that appears to the right of the Go button on the Search bar.
Description of filters in the action button :
| Filters | Description | |
|---|---|---|
| 1 | Columns | This button allows you to reorganize the table by default by hiding the unwanted columns and showing the desired columns |
| 2 | Filter | This button allows you to choose the column or row on which you are going to filter and to add the value we are looking for, in order to have the information easily, Example: filter in the status column the approved chemical references so that the table only displays these results there |
| 3 | Data | This filter includes four buttons Sort : Used to change the columns to sort on and determines whether to sort in ascending or descending order Aggregate : Aggregates are mathematical computations performed against a column. Aggregates display after each control break and at the end of the report within the column they are defined Compute : Enables you to add computed columns to your report. These can be mathematical computations or standard Oracle functions applied to existing columns Flashback : A flashback query enables you to view the data as it existed at a previous point in time |
| 4 | Format | This filter includes three buttons : Control break : Used to create a break group on one or several columns Highlight : You can choose by filter on columns by adding conditions and color codes (Example: I want all my status "in use" to be in red color) Rows per page : You can choose how many rows to display on the table |
| 5 | Chart | This filter makes it possible to filter and organize the information sought in the form of visuals : Bar, line, line with Area or Pie |
| 6 | Group by | You can define one Group By view per saved report. Once defined, you can switch between the group by and report views using view icons on the Search bar |
| 7 | Pivot | You can choose the pivot column and row column, and the functions in order to display the matrix |
| 8 | Report | This filter includes two buttons : Save report : Once you use the filters you want, you will be able to save this report so that you always have two versions: primary report (the default view) and the one you have created with and saved Reset : Used to restore report to the default settings. |
| 9 | Download | You will be able to download the view you see, according to the formats you want: CSV, HTML, EXCEL and PDF |
| 10 | Subscription | You will be able to fill in your email address and choose according to the frequency and the date, the sending of the report |
The best way to get IT support is to use the new
Service One Platform.