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