I am using queryEntityData SAIL tag to retrieve the data from database and calli

ramakg

A Score Level 1

over 8 years ago

I am using queryEntityData SAIL tag to retrieve the data from database and calling multiple time based on the different inputs(using apply function) . I want to display this record details in the Single Grid. how can i merge result and display the same on the Grid?

Thanks in advance.

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 8 years ago

@ramakg You may do something as follows:

fn!load(
\tlocal!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 5,
sort: a!sortInfo(
field: "",
ascending: true()
)
),
\tlocal!data: ,
\t/* Data obtained by querying entity in an iterative manner or data obtained by merging the query entity results. Make sure that a!queryEntity().data for each query is finally merged while forming the resultant array. */
\t
\t/* Replace myCDT in the type!myCDT() with the name of the CDT which you have been using. */
\tlocal!myCDTData: fn!cast(
\ tfn!typeof({type!myCDT()}),
\ tlocal!data
\t),
\t
\t/* Paginate the local!myCDTData and provide the same to the Paging Grid */
\t
\t
\tfn!with(
\ tlocal!myCDTDataSubset: fn!todatasubset(local!myCDTData,local!pagingInfo),
\ t/*
\ tPaging Grid that surfaces the data from local!myCDTDataSubset
\ t*/
\t)
)

But I believe that you will get suggestions from the practitioners re the iterative application of query rule. As per my experience, I know that, some times it's inevitable but I would suggest to stay away from it as much as possible.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 8 years ago

@ramakg You may do something as follows:

fn!load(
\tlocal!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 5,
sort: a!sortInfo(
field: "",
ascending: true()
)
),
\tlocal!data: ,
\t/* Data obtained by querying entity in an iterative manner or data obtained by merging the query entity results. Make sure that a!queryEntity().data for each query is finally merged while forming the resultant array. */
\t
\t/* Replace myCDT in the type!myCDT() with the name of the CDT which you have been using. */
\tlocal!myCDTData: fn!cast(
\ tfn!typeof({type!myCDT()}),
\ tlocal!data
\t),
\t
\t/* Paginate the local!myCDTData and provide the same to the Paging Grid */
\t
\t
\tfn!with(
\ tlocal!myCDTDataSubset: fn!todatasubset(local!myCDTData,local!pagingInfo),
\ t/*
\ tPaging Grid that surfaces the data from local!myCDTDataSubset
\ t*/
\t)
)

But I believe that you will get suggestions from the practitioners re the iterative application of query rule. As per my experience, I know that, some times it's inevitable but I would suggest to stay away from it as much as possible.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data