Presenting Data from DB

 Hello everyone,

I have a problem with presenting data from DB. There is short introdcution:

In SQL DB SERVER i have a table called  email request and there are rows called id, request number, sender, title, recieved at, email body and folder id. This is table stores data about emails. The problem is that you can have many mails from one person that are related to one request number and i would like to present them in one grid - all of them. 

I've created a expression rule to get request mail by request Number

 a!queryEntity(
entity: cons!SAMPLEDATASTOREENTITY,
query: a!query(
filter:
if(
rule!APN_isBlank(ri!requestNumber),
null,
a!queryFilter(
field: "requestNumber",
operator:"=",
value: ri!requestNumber
)
),
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: -1
)
)
).data

But the problem is when i would like to present this on my interface via TEST(for eg. rule!AA_getRequestMalByRequestNumber("SOME REQUEST NUMBER123")and this is presenting me just first row with this number 

Can somebody help me with this present all of them in this grid

Thank you in advance Dawid

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data