Blog Elements

Half Sized Blog Element (Single Author Style)

Half Sized Blog Element (Multi Author Style)

Controls, Knowledge Base, PowerForms Siverlight

Taking advantage of the ListDataGrid ValueChange event

The ListDataGrid control is very useful for presenting data coming from other/related lists. Apart from displaying the results, the control does not provide a value to be used from other controls or formula expressions. The control however raises the ValueChange event and can be used from python script during run-time. The ListDataGrid control, has a […]

August 13, 2017/by Konstantinos

Controls, Knowledge Base, PowerForms Siverlight

The ListDataGrid control

The ListDataGrid control is useful to display data coming from other lists. Configuring the control only requires to define a list query. For example assume we have 2 custom lists : Customers and Orders. The requirement is display Customer Orders inside each Customer form. So we must define a query that will retrieve Orders using criteria from the existing customer […]

August 13, 2017/by Konstantinos

Controls, Knowledge Base, PowerForms Siverlight

Taking advantage of the ListDataGrid ValueChange event

August 13, 2017/by Konstantinos

Controls, Knowledge Base, PowerForms Siverlight

The ListDataGrid control

August 13, 2017/by Konstantinos

Taking advantage of the ListDataGrid ValueChange event

The ListDataGrid control is very useful for presenting data coming from other/related lists.

Apart from displaying the results, the control does not provide a value to be used from other controls or formula expressions.

The control however raises the ValueChange event and can be used from python script during run-time.

The ListDataGrid control, has a special method called GetGridItemValue(string) which can be used from script to get the attribute of the selected row in the grid.

In order to use the method, users should apply some code in the ValueChange script of the control.

In order to access the internal methods of the ListDataGrid, users have to use something like the following code :

Code

control.InputControl.GetGridItemValue(“Title”)

The parameter provided should be the attribute name (column name) of the bound list query.

Note : The InputControl property provides access to the methods of the actual control.

August 13, 2017/by Konstantinos

The ListDataGrid control

The ListDataGrid control is useful to display data coming from other lists. Configuring the control only requires to define a list query.

For example assume we have 2 custom lists : Customers and Orders.

The requirement is display Customer Orders inside each Customer form. So we must define a query that will retrieve Orders using criteria from the existing customer record.

In the runtime designer of the Customer form, we add a new ListQuery.

We define the query parameters :

Url : The orders list url

List : The orders list

Criteria : We must lookup orders using the ID of the current customer record.

Ignore Blank Criteria : we shoudl uncheck this option since it indicates if the filter will be applied when the ID control has no value. This would retrieve all records from the orders list every time we create a new Customer record.

Attributes : We select the columns we want to display in our data grid. Note that for lookup columns we can use the {name:ColumnInternalName} or {value:ColumnInternalName} in order to display the ID or the Name part of the lookup value.

Headers : We define the headers for data grid columns.

Now we can add the ListDataGrid on the form.

Define the required height and in the advanced properties of the control, select the list we defined in our previous step.

August 13, 2017/by Konstantinos

Half Sized Blog Element (Single Author Style)

Half Sized Blog Element (Multi Author Style)

Full Sized Blog Element (Big Preview Pic)