Covering OroCommerce, OroCRM, OroPlatform topics, including community updates and company announcements.

Forums OroPlatform OroPlatform – How do I? Questions Filter on a date field which is not part of the grid group results with "having"

This topic contains 1 reply, has 2 voices, and was last updated by  mmiasnikov 11 months ago.

  • Creator
  • #36515



    I am trying to filter the results of a grouped grid which pulls some summary statistic. My main file contains an Identification Date, which is part of the file, but not selected in the final output, but I would still like to be able to filter on the date range.

    The grid code does compile and the filter shows up on screen, but when I enter a date range with existing dates, it does not properly select the appropriate transactions with the Having clause and returns the whole dataset with all dates results;

    Here is the Datagrid code:

    My understanding is that the filter by having should work just like the SQL Having clause in MYSQL which actually works in that case.

Viewing 1 replies (of 1 total)
  • Author
  • #36516


    Hello, phil5.

    As I can understand from your code example you should add Identity.identifiedAt to ‘groupBy’ clause or filter it on ‘where’ conditions, not in ‘having’.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

You will be redirected to [title]. Would you like to continue?

Yes No