SUMMARY:
In this session we covered two interesting topics involving data sources in Nitro App Builder: (1) Pulling data from an outside JSON web service to populate a NAB widget, and (2) using the new vvIn_virtual helper function, introduced in Valence 6, through which a widget can apply filters to WITH clauses inside SQL statements.
URL: https://www.youtube.com/watch?v=trzcMgjiD2U
DD#16.jpg
TIMESTAMPS AND FEATURES COVERED:
1:23 - Creating a Grid in NAB
2:15 - Going over the usage of vvln_virtual helper function
3:50 - Syntax for vvln_virtual
5:50 - Setting up a filter in the new virtual column
7:58 - Creating a Data Source that is consuming an outside Web Service using an SQL statement
9:40 - Using an URL in the Data Source that returns an array
12:50 - Creating a Grid based on the Data Source
14:00 - Creating an App listing information from the outside service
14:30 - Setting up Filtering using the URL parameters
15:50 - Adding a filter for the user to change the results displayed in the app
17:35 - Using Outside Web Service with User and Password
20:20 - Accessing the Database on a Remote IBM i
In this session we covered two interesting topics involving data sources in Nitro App Builder: (1) Pulling data from an outside JSON web service to populate a NAB widget, and (2) using the new vvIn_virtual helper function, introduced in Valence 6, through which a widget can apply filters to WITH clauses inside SQL statements.
URL: https://www.youtube.com/watch?v=trzcMgjiD2U
DD#16.jpg
TIMESTAMPS AND FEATURES COVERED:
1:23 - Creating a Grid in NAB
2:15 - Going over the usage of vvln_virtual helper function
3:50 - Syntax for vvln_virtual
5:50 - Setting up a filter in the new virtual column
7:58 - Creating a Data Source that is consuming an outside Web Service using an SQL statement
9:40 - Using an URL in the Data Source that returns an array
12:50 - Creating a Grid based on the Data Source
14:00 - Creating an App listing information from the outside service
14:30 - Setting up Filtering using the URL parameters
15:50 - Adding a filter for the user to change the results displayed in the app
17:35 - Using Outside Web Service with User and Password
20:20 - Accessing the Database on a Remote IBM i