[https://www.loom.com/share/4e04ef5d5c0a43fcad94c6951970e33a](https://www.loom.com/share/4e04ef5d5c0a43fcad94c6951970e33a "smartCard-embed")
- Take a look at factii engineering in subFactiii standards in far left Trello board
- Remove groupBy from queries
- Increment/Decrement the count on user, factiii, and post when postFactiiis are added/removed.
- Make sure this is tied to being Approved
- Need to check that we can have factiiis auto approved or not auto approved
- Change the returnPostObjectDto to be based off of PostFactiiiCount
- Make a 2nd query to pull any data attached to the postFactiii
- Final shape for factiis from returnPostObjectDto
- { factiiiId, count, data associations}
- Make sure front end can interpret new data shape
- Add admin function that will create counts from the current postFactiiis IE iterate through all posts with factiiis then count add add the approprate count to userFactiiiCount and PostFactiiiCount
Follow Up
[https://www.loom.com/share/6ed9d0888447463cb3d185da139344b6](https://www.loom.com/share/6ed9d0888447463cb3d185da139344b6 "smartCard-embed")
- Remove React from imports IE import Readct fro, “react”
- Convert to new schema
- This should make it so factiiis is 1 query vs the DataFactiiis and PostFactiiis query currently
- Rename DataFactiiiDto to `PostFactiiiCountDto then send as factiiis with post`
- Get tests to work again once everything is fixed