How can i use Lookup Key with order by or group by

Suppose i have a look up key definded at user level as

“sp_access” : “928” => {sp_access}

So when i login as this user for every query it is just appending "AND sp_access = 928"
so if i use order by on my query , it gives a MySQL error.

How can i solve this?

We only recently fixed group by. Have you tested this on the latest release?

1 Like