Support calculated(virtual) fields in the query builder #2359

Activity

1. maxpatiiuk

   added

   1 - RequestA request made by a member of the communityA request made by a member of the community

   back-end

   on Oct 27, 2022
2. maxpatiiuk

   assigned

   benanhalt

   on Oct 27, 2022
3. benanhalt commented on Oct 27, 2022

   

   benanhalt

   on Oct 27, 2022

   Contributor

   More actions

   Probably using database views would be the most principled way of doing this. Then Specify queries and other APIs could access these fields in a consistent way as if they were normal fields. There would need to be a way to add the views to the database. Presumably this could be done using custom Django migrations. Also there would need to be some way to cause the backend to use the views when retrieving data from such tables but continue to issue updates and inserts to the underlying bare tables. MySQL does support updatable and insertable views, but I wouldn't bet on them being fit for use.
4. grantfitzsimmons

   assigned

   acwhite211

   and unassigned

   benanhalt

   on Dec 6, 2022
5. grantfitzsimmons

   added this to Back-End Backlogon Feb 14, 2023
6. grantfitzsimmons

   removed

   back-end

   on Feb 14, 2023
7. grantfitzsimmons

   moved this to 📋 Backlog in Back-End Backlogon Mar 9, 2023
8. grantfitzsimmons

   added

   2 - QueriesIssues that are related to the query builder or queries in generalIssues that are related to the query builder or queries in general

   on Jul 2, 2023
9. grantfitzsimmons

   added this to the Grant's issue list milestone on Aug 6, 2023
10. maxpatiiuk

    changed the title [-]Support calculated fields in the query builder[/-] [+]Support calculated(virtual) fields in the query builder[/+] on Sep 30, 2023
11. maxpatiiuk commented on Sep 30, 2023

    

    maxpatiiuk

    on Sep 30, 2023

    MemberAuthor

    More actions

    From @grantfitzsimmons:

    This includes isOnLoan and actualCountAmt

    The "Is on Loan" indicator that you can see in the preparation section of a form is not currently a field option in the query builder:

    

    Requested By: Dan Baker at CSIRO (Asana)
12. grantfitzsimmons

    added

    SeparationFrom6

    on Apr 17, 2024
13. grantfitzsimmons

    added

    1 - EnhancementImprovements or extensions to existing behaviorImprovements or extensions to existing behavior

    and removed

    1 - RequestA request made by a member of the communityA request made by a member of the community

    on Dec 20, 2024
14. bhumikaguptaa commented on Sep 3, 2025

    

    bhumikaguptaa

    on Sep 3, 2025

    More actions

    Philippe Verely, IRD, requested this feature.

    https://discourse.specifysoftware.org/t/count-rows-from-the-query-builder/2787
15. specifysoftware commented on Sep 12, 2025

    

    specifysoftware

    on Sep 12, 2025

    Collaborator

    More actions

    This issue has been mentioned on Specify Community Forum. There might be relevant details there:

    https://discourse.specifysoftware.org/t/count-rows-from-the-query-builder/2787/2
16. specifysoftware commented on Dec 1, 2025

    

    specifysoftware

    on Dec 1, 2025

    Collaborator

    More actions

    This issue has been mentioned on Specify Community Forum. There might be relevant details there:

    https://discourse.specifysoftware.org/t/show-calculated-virtual-fields-in-the-statistics-page/3178/1
17. grantfitzsimmons commented on May 14, 2026

    

    grantfitzsimmons

    on May 14, 2026

    Member

    More actions

    We had a crash today in PRI's database due to the virtual count amount fields being present in a query, but Specify 7 being unable to return them.