In a Interface I want to show a Paging Grid with multiple columns and multiple r

I think you should look at this recipe example which shows how to select data from a grid and provide further information. It won't be difficult to tweak this to do as you're asking.

forum.appian.com/.../SAIL_Recipes.html

Providing you with wholesale code to meet your requirement won't aid your learning in my opinion.....

@clarke. In the sample code, it throws an error.
load(
local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 10,
sort: a!sortInfo(
field: "m_id",
ascending: false
)
),
with(
local!data:rule!sampleTable_db(),
local!datasubset:todatasubset(local!data,local!pagingInfo),
a!gridField(
totalCount: local!datasubset.totalCount,
columns: {
a!gridTextColumn(
label: "ID",
field: "m_id",
data: index(local!datasubset.data, "m_id", null)
),
a!gridTextColumn(
label: "Name",
field: "name",
data: index(local!datasubset.data, "name", null)
),
a!gridTextColumn(
label: "Number",
field: "number",
data: index(local!datasubset.data, "number", null)
)
},
value: local!pagingInfo
)
)
)

Error ("Expression evaluation error at function a!formLayout: Error evaluating function 'todatasubset' : [Ljava.lang.Object; cannot be cast to com.appiancorp.suiteapi.common.paging.DataSubset").

@anilkumark I suspect there could be a problem with the data type being returned by local!data. What is the method you are using to query RDBMS - Query rule or a!queryEntity() or queryrecord()? Refer https://forum.appian.com/suite/help/7.9/Querying_Data_From_an_RDBMS.html for the return types of these functions . Ensure that you use a todatasubset() function based on the return types of the functions.

Note: If you haven't made a search in the forum about the issue, please follow tim.clarke's suggestion at /search?q=OriginalPostID-133961 for digging deep into the error.

@sikhivahan. I am using a!queryEntity(), when tested the rule. Its working fine, but in interface throwing an exception "Interface Definition: Expression evaluation error at function a!formLayout: Error evaluating function 'todatasubset' : null"

rule content-1.txt

@anilkumark Please update the contents of rule!sampleTable_db() with the contents of attached file and test the rule again. Please do let me know if you have any issues. The attached content is one of the ways of doing it.

As already said, please go through the links (post in which tim.clarke participated and documentation) as it will give you an idea of using the todatasubset, cast or query rdbms functions at appropriate places.

As you are bringing all the data at a time (i.e. batchSize:-1), making a query again isn't needed in your case. So I would like to suggest to move local!data:rule!sampleTable_db() into load() to avoid querying every time when you interact with any of the components on the SAIL interface.

Thanks @sikhivahan. Its working fine. But not showing check boxes in the grid.

It might be worth going through this: forum.appian.com/.../SAIL_Components.html

'Selectable' attribute of paging grid should be set to true, as it's default value is false.

Please have a look at the following recipe for grid selection. I would suggest you review all of the recipes to give you a better understanding of SAIL functionality and consider attending some of Appian's training classes.
forum.appian.com/.../SAIL_Recipes.html

Can anyone shed some light on code attached. Populating that GridField target is missing.

GridSelection.txt