List is loaded with all items instead of applying restrictions

[kartikchoum]

Hi Community,

We have developed a custom application using App Engine studio, we are seeing a very unusual thing here. There is a applicable list filter applied which is supposed to load a list based on pre-set conditions. Apparently this filter does not works when the form is loaded freshly, but it will work if we select anything from the list first, and then do a re-search. 

Has any one faced the problem before? if yes, any solutions?

[Tony Chatfield1]

Hi, your post doesn't provide any details of how your data is being filtered?
Perhaps you can clarify\provide specific details?
Also, the second screenshot shows ACL hiding data, but this is not visible in the first screenshot>
Are these different views\users? or do your acl's have scripted conditions? if scripted I suspect something is not returning consistent results?

[kartikchoum]

Thanks for getting back to me. I tried disabling all the ACLs on that application scope related to the field. But it still gives me the same error. Both screenshot are of same table, as soon as I select anything from first screenshot, the second time when i load the list it gives me that ACL restriction message.

[Tony Chatfield1]

Hi, unfortunately the detail you have provided in your post does not make your configuration clear. I would suspect that the ACL is doing its job and hiding records at table level, but I would expect the results to be consistent.

Have you added debugging\logging to confirm the list popup is returning\showing the same 11 records each time the list is loaded?

You mention selecting something and then loading the list a second time, which indicates that something may be cached or some query is not returning consistent results, but with no clear details of your configuration it is not possible to evaluate your issue further.