Dear Team,
I have a table X, where there are 100 records. When i fetch the data using a query rule from an expression rule.
Few of the records are not getting returned, when i tried in DB directly using SQL , i am able to see the records.
Even i tried with filter and didn't helped, tried multiple solutions from the community and this issue looks strange.
Can some provide me a solution ? Even we tried restarting the Appian and didn't helped.
Thanks,
Sunil Mohan
Discussion posts and replies are publicly visible
Hi Sunil - that's not a lot to go on. Have you tried an alternate retrieval method e.g. a Query Entity? When you say "Few of the records are not getting returned" are you saying 90% (or some other figure) ARE being returned?
3 records are not getting fetched among 100. But from back end SQL query am able to see them.