Skip to main content
Question

Group by aggregate in lobby projection datasource

  • September 10, 2026
  • 4 replies
  • 43 views
dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • dsj
  • Ultimate Hero (Partner)

Hi All,

 

I need to create a lobby element which shows not cerated external customer invoice load IDs per company in last 10 days.

 

I started with a Projection type datasource.

Projection: ExternalCustomerInvoiceLoadInformationHandling

Filter: (LoadDate gt #TODAY#-10) and ExtOutInvLoadState ne IfsApp.ExternalCustomerInvoiceLoadInformationHandling.ExtOutInvLoadState'Created'

 

It works upto here.

I need to show the  no of load ids per company.

the group by condition I need to use is: ((Company),aggregate($count as LoadIdCount))

 

URL would be:
.../main/ifsapplications/projection/v1/ExternalCustomerInvoiceLoadInformationHandling.svc/ExtOutInvLoadInfoSet?$apply=filter((LoadDate%20gt%202026-08-31)%20and%20ExtOutInvLoadState%20ne%20IfsApp.ExternalCustomerInvoiceLoadInformationHandling.ExtOutInvLoadState%27Created%27)/groupby((Company),aggregate($count%20as%20LoadIdCount))

 

URL is giving correct results but the datasource designer gives an error with the aggregate. It seems like the aggregate is not supported? Is there any other way to do this?
 


​@Marcel.Ausan ​@Tomas Ruderfelt  Please help 🥹

Cloud version 25R2 SU8

DSJ - https://dsj23.me

    4 replies

    PhillBronson
    Hero (Customer)
    Forum|alt.badge.img+13
    • PhillBronson
    • Hero (Customer)
    • September 10, 2026

    ​@LushaniAbey do you have any insight?

    https://www.linkedin.com/in/phillip-bronson/
      Superhero (Employee)
      Forum|alt.badge.img+21
      • Tomas Ruderfelt
      • Superhero (Employee)
      • September 11, 2026

      I was able to use an aggregate in a lobby data source in this way.
      Not exactly your example but it should not matter:

      1. Create the query in “Query Designer” and publish.
      2. Use the projection from the query in the lobby element.

      Simple and clean, no need to write any aggregate manually etc.

      I’m not sure if you can solve it directly in the Lobby Data Source. I could not find a way to add it properly.
       

        dsj
        Ultimate Hero (Partner)
        Forum|alt.badge.img+22
        • dsj
        • Author
        • Ultimate Hero (Partner)
        • September 11, 2026

        I was able to use an aggregate in a lobby data source in this way.
        Not exactly your example but it should not matter:

        1. Create the query in “Query Designer” and publish.
        2. Use the projection from the query in the lobby element.

        Simple and clean, no need to write any aggregate manually etc.

        I’m not sure if you can solve it directly in the Lobby Data Source. I could not find a way to add it properly.
         

        Thanks Tomas. I need to use #TODAY# -10 in the filter. Seems the query designer doesn't support dynamic syntax for date fields?

         

        BR,

        Damith

        DSJ - https://dsj23.me
        Superhero (Employee)
        Forum|alt.badge.img+21
        • Tomas Ruderfelt
        • Superhero (Employee)
        • September 11, 2026

        Could not make any workaround to get a condition like #TODAY# - 10 working.

        But using only substitution variables is possible. Not in query designer. Lobby Data Source supports use of substitution variables for date parameters. (
        https://docs.ifs.com/techdocs/26r1/040_tailoring/225_configuration/200_client_configurations/310_conditional_fields/300_condition_syntax/?h=%23TODAY%23#date_variables)

        This works for me:

        In combination with this parameter condition in the query filter:

         

        Terms & ConditionsAccessibility statement