Searching by app_metadata doesn't show results for family_name

Help
1

Hi, I’m using v3 user search.
https://auth0.com/docs/users/search/v3/query-syntax

I have a strange problem in that I cannot seem to search by an app_metadata property and the family_name at the same time.

Let’s say I have a user called Dave Smith, with a certain set of roles in app_metadata.
My query by first name would look like this -

app_metadata.company_name.userType:"EMPLOYEE" AND 
(name:Dave* OR given_name:*Dave* OR family_name:*Dave* OR email:Dave*) AND 
(app_metadata.company_name.roles:"Account Manager" OR 
  app_metadata.company_name.roles:"Account Owner") AND 
NOT blocked:true

I get Dave Smith to come up as a result.
If I search like this (i.e. search for ‘Smith’ instead) -

app_metadata.company_name.userType:"EMPLOYEE" AND 
(name:Smith* OR given_name:*Smith* OR family_name:*Smith* OR email:Smith*) AND 
(app_metadata.company_name.roles:"Account Manager" OR 
  app_metadata.company_name.roles:"Account Owner") AND 
NOT blocked:true

Dave Smith does not come up as a result.

If I use this -

app_metadata.company_name.userType:"EMPLOYEE" AND 
(name:Smith* OR given_name:*Smith* OR family_name:*Smith* OR email:Smith*) AND 
NOT blocked:true

Then Dave Smith does come up. So we can definitely search by his family_name.

So by adding app_metadata.company_name.roles search I somehow can’t search by family_name.
Anyone got any ideas?

Thanks,
Dan

2

btw, I have tried different combinations of wildcards, so don’t take the ones above as the only syntax I’m using