There is a new feature that allows you to manage object access by applying an access condition using an SQL query.
This feature provides greater flexibility and control over the visibility and editability of objects based on specified conditions.
The SQL query is required to yield one of the following values:
0. Editable/Visible
1. Readonly
2. Hidden
3. Hidden (User)
4. Hidden (User) + Readonly
You can also utilise hash variables in these queries to dynamically evaluate conditions.
Example Conditions:
1. Hide a Button for 'Guest' Users:
Code: Select all
SELECT IF('#ACCESS_LEVEL_CODE#' = 'Guest', 2, 0)
2. Show the Object for New Records:
Code: Select all
SELECT IF('#NEW_RECORD#' = '1', 0, 1)
3. Show the Object if 'cust_name' is Blank:
Code: Select all
SELECT IF('#cust_name#' = '', 0, 2)
This new feature empowers you to customise object access based on your specific requirements, giving you more control and flexibility.
If you have any questions or need assistance with implementing these SQL conditions, please feel free to ask in our community forum. We're here to help!