vita icon indicating copy to clipboard operation
vita copied to clipboard

Functions like createdOn.Date are ignored in GroupBy

Open rivantsov opened this issue 1 year ago • 6 comments

See issue #225

rivantsov avatar Jul 14 '23 19:07 rivantsov

May I know will this be fixed as well? Thanks.

jasonlaw avatar May 06 '24 15:05 jasonlaw

yes, it will be fixed as well, will try to focus on this and other general restructuring issues in the next few weeks. I will post more about the plans in a separate post.

rivantsov avatar May 06 '24 18:05 rivantsov

Thanks for the update, looking into the new release. :)

jasonlaw avatar May 07 '24 06:05 jasonlaw

I have one request that would like to get your attention.

Base on the discussion we have before at https://github.com/rivantsov/vita/issues/150, may I know if the filtered relation supported in v1.9 before is part of the sql query or post filtering after retrieving from database?

If it is part of sql query, may I request the feature again? Here is my use case:

  1. A store have many members.
  2. The member can unregister themselves from the store, which will be marked as soft deleted.
  3. Those soft deleted members will be treated as "deleted record", and should not be retrieved in all the query.
  4. Now, for all the members relationship related query, we always need to add the IsDeleted checking explicitly. It would be nice if this can be handled implicitly by the filtered relation.

Thank you.

jasonlaw avatar May 07 '24 06:05 jasonlaw

I will definitely look at that, no promises or dates yet, but I am looking at soft deletes

rivantsov avatar May 08 '24 15:05 rivantsov

sorry for the delay but the problem #225 with expressions in GroupBy is fixed now

rivantsov avatar Jul 10 '24 05:07 rivantsov