Is there a way to make a server call to fetch players with a specific key value in their stored player data?
To clarify, let's say I'm collecting the last stage a player has visited in a title key called "LastStage". And then I want the current player to see an avatar of other players who have made it through the current stage the player is at using the key "LastStage." To clarify more, the SQL equivalent of what I'm looking for would be something like this:
SELECT TOP 5 p.displayName from PlayerData p where p.LastStage = :currentStage Order By p.displayName
I suspect that I should use a cloud script to get all user data and then filter the desired data from the returned list, but that would be a costly task if the number of players is high.
I was not able to find a server request to get all player data or a request which enables me to filter player data. I am pretty new to Microsoft Azure and Playfab and not sure if this sort of action is even possible. Could you please help me with executing this task and acheiving the desired outcome?
Thanks in advance.