sysparm_fixed_query with Group By on a Module

[Elias11]

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 · Accepted solution]

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]

Hi Gurpreet

thanks for your reply

I have tried your query, it is not really working as something weird is then happening.

After I setup this query and I click on the Module to get the group by list, I get instead again a normal list sorted, but when I click on the user header to sort it will group by suddenly.

/time_card_list.do?sysparm_query=GROUPBYuser&sysparm_fixed_query=user.manager=javascript:gs.getUserID()

[Gurpreet07]

It should work fine. Please check out module TimeCardTest   in demo012 .

I changed the fixed query filter a little so that we will get some records in the list.

[Elias11]

I am not able to connect to your sandbox

I have noticed that al lmy headers are groupped.

Elias