Page 1 of 1

[Improved] Display Object: Use a Procedure

Posted: Sun Jun 09, 2024 9:30 am
by admin
Up to now, the Display Object has been a read-only field that shows the first column of the first record retrieved by an SQL Select statement.
With the release of nuBuilder-4.5_June_2024.08, it is now possible to display the output of a procedure in a Display Field.

This new feature is particularly useful for running complex queries that cannot be executed in a single PDO query or for displaying values based on different user Access Levels or User Permissions.


How to Set It Up

1. Create a Procedure. Ensure your procedure outputs data using echo()

display_procedure_1.png


2. Link the procedure you have created to a Display Object:

display_procedure.png