a user sees a portal of a list of tasks on an inactive tab on a dashboard layout.
I want to display a count of how many tasks where user_task::isNew = 1
at this point I have a bunch of TOs for this type of functionality all over my solution.
Many of them also exist for the function of getting a list of PKs of related records that meet specific criteria that the relationship filters.
This works great my some of my main relational tables are showing signs of slow record creation and I am investigating ways to reduce my TO count to hopefully speed this up.
I am wondering if there is a way to get that calc without create a specific TO for things like that.
PS on a dashboard, i would probably leave the dedicated TO but i would use this for less used functions.