Tab SQL Clause is a property of an individual option within a tab group. The SQL Clause controls the display of the tab in the interface by using SQL to determine the whether the current state of the data matches the business rule expressed. We can decide whether a tab should display based on the information of the entity that is in context. If we are looking at a person screen the person entity is in context. If we are looking at the company screen then the company is in context.
The following articles explain how the SQL Tab Clause can used in both the user screens and the administrative screens.
Introduction to the Tab SQL Clause
- Hiding a tab with an SQL Clause
- Tab SQL clause
- Current Context and User data used to control a Tab
- More about using U:, C: and T: in the Tab SQL Clause
Specific Examples
- Hiding the Global Library (Shared Documents) by teams
- Controlling access to reports
- Restricting Access to a Report to Specific Times of Day
- Controlling the availability of a Company tab based on products purchased
Use in the Admin Screens