How to Store and Reuse Filtered Data in Bubble Without Repeated Searches?

[ezduriez]

@jenil.kukadiya

What I Want to Achieve:

1. Store the filtered Billing Run Worklog entry only once per Employee-Date combination.
2. Use the stored value in multiple conditions (e.g., conditional formatting) without re-running the search.
3. Optimize workload usage by avoiding repeated database queries.

Insert a hidden RG anywhere in the page. Do the repeated search you need in this RG. E.g. search for logs and use the conditional for all searches like “mail id” or “date”. If you don’t have any filter that is common for every conditional try to do 2 hidden RG.

Then in the text conditional insert "rg logs list of logs filtered “hours”.

If this solution doesn’t work for you try to use the function after the search “cached aggregation”. This is useful when you don’t need to update the informations repeatedly. This function will store the counts for 30 minutes. I’m not sure this is the best solution in your case but you can try.