deleted-U06C7A8PVLJ
2025-05-07 14:00:12

@James Turner I am referring to this SQL query:

image.png
deleted-U06C7A8PVLJ
2025-05-07 14:00:31

The column / field name that isn't there anymore is called ioagentcommission_rate

James Turner (jturner@shield-legal.com)
2025-05-07 14:03:15

Taking a look now to see if that was preserved in the history table

deleted-U06C7A8PVLJ
2025-05-07 14:05:40

Thank you @James Turner

James Turner (jturner@shield-legal.com)
2025-05-07 14:05:55

Yeah that was stripped from the iolrcasetypesrevenueratehistory table when we removed it from the iolrcasetypesrevenue_rate so you will likely need to go with option 2, which is pull it from the other source ryan mentioned

James Turner (jturner@shield-legal.com)
2025-05-07 14:06:47

I'm checking now to see if it is within snapshot range

James Turner (jturner@shield-legal.com)
2025-05-07 14:07:51

Yeah it was over 7 days ago so It's not in the snapshot

deleted-U06C7A8PVLJ
2025-05-07 14:21:22

My guess is for me to run last month query in pgadmin to get those values and use those. I wonder if we were to create that column would that be okay too ?

deleted-U06C7A8PVLJ
2025-05-07 15:56:50

https://www.loom.com/share/daa14c63c1bc4760a2a1099ed3944dc7 @James Turner Solution for this above

Loom
Google Chrome - 7 May 2025
Original URL: https://www.loom.com/share/daa14c63c1bc4760a2a1099ed3944dc7
🙏:skin_tone_4: Ryan
Brian Hirst (brian@themedialab.agency)
2025-05-07 16:43:37

@Brian Hirst has joined the conversation

deleted-U06C7A8PVLJ
2025-05-07 16:44:12

Hi @Brian Hirst. After talking to Ryan, he had mentioned in retool we should recreate the option to include agent commission on there. ( I believe that is what it was called or something similar) From what Malissa and Ryan explained to me, it should be Category points ** Points denomination.

🙏:skin_tone_4: Ryan
deleted-U06C7A8PVLJ
2025-05-07 16:44:47

I also posted a video above which Ryan shared with me how that column is calculated

deleted-U06C7A8PVLJ
2025-05-07 16:45:31

Posting this so everyone is on the same page for @Brian Hirst to make those adjustments

👀 Brian Hirst
Brian Hirst (brian@themedialab.agency)
2025-05-08 09:55:36

@James Turner @Ryan Which field am I re adding into retool, and does it need to be re added to iolrcasetypesrevenue_rates as well?

Ryan (ryan@themedialab.agency)
2025-05-08 09:59:05

@Brian Hirst just add back agent commission, ever rates should still be the focal point field in case type pricing