sysparm_fixed_query with Group By on a Module

Elias11 · ‎11-27-2015

Hi Experts

I have a List Module for Time Card and I have on the Argument a &sysparm_fixed_query to having a restricted filter.

this is working well.

now I need to add Group by on in this List but this is not working?

I know that group by works with normal sys_parm_query but it isnt working with fixed one.

What am I doing wrong?

Thanks

Elias

Gurpreet07 · ‎11-29-2015

Hi Elias,

Change module type to 'Url from arguments' and then in arguments provide url with groupp by statement and fixed query in following format

/time_card_list.do?sysparm_query=GROUPBY<fieldName>&sysparm_fixed_query=<fixedQuery>

Elias11 · ‎11-30-2015

Hi again

now it is working .. thanks for your help

your query was correct. only the user that I was testing was not ok.

I changed the user and now it is grouping

thanks a lot

Elias