...
| Property | Description |
|---|---|
| General | Aside from the basic information, you'll have to make a decision whether to deploy the View as a database element or a function. |
| Objects | All of the Busines Objects that are related... |
| Fields | All the columns associated with the view |
| Where | Clause that filters the retrieved columns |
| Sort By | Used to sort view by a specific column(s) |
| Group By | Used to group columns and perform aggregate function on other columns. For example finding the total number of employees grouped by position |
| Having | Used in conjunction with the Group By statement. Used to Filter the result statement. For example finding number of employees grouped by position having position not equal to 'QA'. |
NOTE: For naming issues please refer AppBase Black List of Names.
Create a View with simple SELECT statement and SORT BY clause
...