How to Create Application Restrictions via Presentation.xml

You can use Application Designer to define restrictions on what records can display in an application. You can filter what data a user can see when opening an application by entering a query in the application’s presentation control. You might want to filter what records a specific application displays when it and several other applications use the same data source, but not all of the data records in the set are applicable to all of the applications.

To define an application restriction, complete the following steps:

1. Open Application Designer by choosing Go To > Configuration > Application Designer.
2. Type the name of the application you wish to open, or press Enter to display a list of applications.
3. As an example, open the Assets application in the Workspace tab.
4. Click Select Action > Toggle Show All Controls.
5. Click the "presentation..." control.
6. Click the Control Properties button to open the Presentation Properties dialog box.
7. In the Where Clause field, enter "inactive=’0’". Application Designer interprets the query as "select * from asset where inactive=’0’".
8. Click Save.

When you open the Assets application, you will only see records where the inactive attribute has a value of "0".