Tutorial: Passing parameters in a Container

In this example, we will see how to pass PHP parameters from one application to a widget from a dashboard to another application in another widget. In the dashboard, we will create a widget with an application that shows a grid with orders and another widget with the details of the order selected in the first widget.

1. Creation of the application for order details.

1.1- Create a new Grid based on the application of the order_details table, but let’s change the Select command to add a WHERE clause with a variable (where [ord]).

1.2- Go to the Events >> onScriptInit item in the application menu to assign values to the variable used in the application’s SQL command.

onScriptInit

if(empty([ord])){
	sc_select_where(add) = "where orderid > 1 = 1";}
else{
	sc_select_where(add) = "where orderid = [ord]";}
sc_reset_global([ord]);

3. Generate the source code of the application.

2. Creating the Order application

2.1- Create a new Grid application based on the “orders” table.

2.2- Access the item “Fields >> New field” in the application menu.

2.3- Create a text field of type called “details“.

2.4- Go to the “Events >> onRecord” item in the application menu

2.5- Copy and paste the following code

onRecord

{details} = "<img src='../_lib/img/grp__NM__ico__NM__cross.png' border = '0' Title='Details'/></a>";

2.6- Access the item “Application Links“.

2.7– Create a “Field Link” in the “details” field.

2.8 – Select the Detail Grid created earlier, and the parameter passed will be the “orderid” field.

2.9 – Generate the source code of the application.

Creating a new Dashboard

3.1 – Now let’s create the Dashboard.

3.2 – In the application menu, go to Settings >> Add connection widget.

3.3 – Click on the pencil icon to edit and select the applications that will be displayed in the widgets.

3.4 – The first widget, we will display the Order Inquiry, and we will select that the details field link in it will be opened in the other widget.