On the "Query Type"="SQL/AI Query" and "Advanced/AI mode"=false when we build some query with calculated columns and need some "where criteria" (i.e. smart filter) there is necessary multiples group by criteria and it's not available.
In my case I'm trying to use JetSmart Filter with a value that determines a "where criteria" on on this type query. I got difficult do use JSF on this case and found this leak of resource on Jet Query Builder.
I think that adding " group by possibility for multiples columns " will improve this awesome tool.
Hope helping and thanks in advance.
On the "Query Type"="SQL/AI Query" and "Advanced/AI mode"=false when we build some query with calculated columns and need some "where criteria" (i.e. smart filter) there is necessary multiples group by criteria and it's not available.
In my case I'm trying to use JetSmart Filter with a value that determines a "where criteria" on on this type query. I got difficult do use JSF on this case and found this leak of resource on Jet Query Builder.
I think that adding " group by possibility for multiples columns " will improve this awesome tool.
Hope helping and thanks in advance.