Fix cross database query for RefreshCacheDataService
Ref: #345867 (closed)
What does this MR do and why?
This commit fixes a cross database query between our 2 new databases which has been identified as a ~"sharding-blocker".
It's now making 2 SQL queries instead of one.
The queries remains the same and has been reviewed when introducing this new feature in !64443 (merged).
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Edited by Max Orefice