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.

3.5 – The second widget, we will display the Order Details Inquiry.

4. Click the Run button on the toolbar.

Tutorials in the same category

Dashboard Application

In this example, a Dashboard application will be created showing a grid and a chart. Creating a...

Sales dashboard by region

In this tutorial we will be doing an example dashboard we will use the sales table. Creating...

Connections between applications

In this example we will be seeing how to make a connection between applications within the Dashboar...

Officials by Region

In this tutorial we will be creating a dashboard of officials for each region. Creating dash...

Comment this post