Dynamic display of rows in data grid 2

0
Hello,  I want to provide a data grid to customer, where he can type the row range he needs (Ex: 200-350) and then respective rows needs to be displayed. Anyone has idea how do we achieve this?   Thanks in Advance
asked
2 answers
0

All you simply do is that:

Place two Number Text Box fields on the Data Grid (for example, bound to attributes called StartIndex and EndIndex). The user will enter values such as 200 and 350. Set the Data Grid’s datasource to a microflow. Inside the microflow, first retrieve the values of these two fields, then calculate limit = EndIndex - StartIndex. Next, use a Retrieve from database activity with offset = StartIndex and amount = limit, and return the resulting list. This will make the Data Grid display only the rows within the selected range. When the user updates the values, use On change to Call microflow to refresh the grid.

 

answered
0

Hi Karuna,

 

Create two input fields:

 

StartRow (Integer)

 

EndRow (Integer)

 

 

 

2. Add a button → call a microflow to:

 

Retrieve the full list from database

 

Apply filtering using offset and amount logic:

 

Offset = StartRow - 1

Amount = EndRow - StartRow + 1

 

Return the filtered list

 

 

 

3. Bind the Data Grid 2 datasource to this microflow → It will show only the selected row range.

answered