DATABASICS Utilites Views

The JDBC views are simply an administrator’s advanced search filter that has been saved and exposed to an API user.

As seen below is an example saved advanced search in the Employee model where the list is filtered by a single ‘Company’.

Open

Important Items

The ability to create saved filters that can be exposed to JDBC requires all of the following conditions to be met.

1. Admin must have role access to Security > Api User Manager

2. The API User must have API Role Access to the view module

3. The exposed view must be active

4. The exposed view must have a valid schema setup in APIHub

Creating a new JDBC View

1. Login Into Admin

2. Open the desired module

3. Apply a filter ← IMPORTANT - be sure to click Apply before you attempt to save

4. Click Save

You will be presented with this popup

Open

Filter Name - Filter name which is visible in admin advanced search

Override If Exists - When checked, and the filter/view already exists, it will override the existing filter and view with your changes.

Expose To Api - Will make the View visible from JDBC

Api View Name - View name which will display in JDBC

Api Roles - Limits which API roles will be able to see the view from JDBC

Active - Active flag

5. Click Save

Now the View will be visible from the JDBC explorer as long as all the previous conditions were met.