question

murat avatar image
murat asked

Search Profiles Query

Hello,

We want to search profiles like that who are purchaser and less than level 10 and have more than 500 hard currency. Our query does not work right.

virtualCurrencyBalances.HC: >500 AND totalValueToDateInUSD: >0 AND statistics.Level :< 10

Could you post the right query?

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JayZuo avatar image
JayZuo answered

The problem here is with statistics you've used in your query. Nested properties cannot be directly searched. So Statistics or PlayerStatistics won't work here. And Game Manager really isn't designed for this kind of query. The recommended way would be using the data warehouse (Snowflake, currently) for that sort of work. For more info, please see @Brendan's answer here: https://community.playfab.com/answers/23756/view.html.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.