Wildcard search (*) is not working on custom table

[Dipali_Pawar]

I have custome table which has number field and display value is true on that field when non admin user trying search number using * number it's showing no record found but same record is showing when user search with = number  and for same user description search is working correctly I have checked below configurations still not working please help me with this if anyone has faced similar kind of issue

1. there is one systempropery which is diabling search i tried to change value to true still not working

2. table levels acls has internal and other role , internal role user already have i have given other role as well still not working

3. I have maked display false for number still same issue 

4. There is no query BR is configured on that particular table 

[J Siva · Accepted solution]

Hi @Dipali_Pawar 

Please check whether a Query Range (query_range) ACL exists for the custom table. I suspect that there is currently no query_range ACL configured for this table.

If one does not exist, please create a Query Range ACL for the specific table and assign the necessary roles to it.

Also, could you please confirm whether this custom table is extending another table or if it is a standalone custom table?
Regards
Siva

[Ankur Bawiskar]

@Dipali_Pawar 

since users want to search only for number then create only for that field

if they want to use wildcard search on entire table then table level

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[J Siva]

@Dipali_Pawar It depends on your requirement..

If you create any additional fields on that table in the future, you will need to create a separate query_range ACL for each field. Therefore, it's better to use a table.* query_range ACL.