Items
The Items form allows you to manage a reusable list of items that can be dynamically used in SQL queries ― for example, to populate a Select or Display Object in forms.
The advantage of this approach is that items can be managed in a central place, and there's no need to create a separate table just to use a (static) list of items in a select object.
Additionally, it supports managing the full lifecycle of each item ― including active/inactive status, creation and update timestamps ― and allows storing supplementary information such as tags, notes, icons, and other metadata.
Form: (Setup Dropdown →) Items
Table: zzzzsys_item
Field Descriptions
- Value – Value used in e.g. select objects (e.g., internal code or key)
- Description – User-facing, human-readable label
- Group – Logical grouping (optional)
- Category – Categorising related items (optional)
- Object ID – ID of the form or object using this item (used for filtering)
- Sort Order – Number that determines the item’s display order
- Tag – Keywords or tags for advanced filtering
- Additional 1 – Custom text data
- Additional 2 – Extra string field
- Notes – Internal notes or descriptions
- CSS – CSS class name for UI styling
- Icon – Icon class (e.g., Font Awesome)
- Language – Language code for localisation
- Parent ID – Used to define item hierarchies (for nested structures)
- Active – ‘1’ = Active, ‘0’ = Inactive (inactive items can be excluded)
- Created On – Timestamp when the item was created
- Updated On – Timestamp of the last modification
- Access Level – Role-based access control (JSON or delimited string)
- JSON – Flexible field for storing structured data (e.g., JSON object)
Example SQL Use Case
SELECT itm_value, itm_description FROM zzzzsys_item WHERE itm_object_id = '#OBJECT_ID#'
→ Where #OBJECT_ID# is a Hash Cookie which will be replaced with the object ID where this SQL is being used (e.g., Display Object ID, Select Object ID)
How to Use in Forms
- Add a Select object to your form.
- In the SQL field, use SQL like the example above.