I am assuming the input you meant are query criteria:
Select * from /region where Id = 1 and Category = 'BANKING' and SubCategory
= '*'
A possible solution is to use OR or IN condition:
Select * from /region where Id = 1 and Category = 'BANKING' and SubCategory
IN ('*', CARDS)
If the subcategory is large, you can use inner/nested query to get those
values...
Select * from /region where Id = 1 and Category = 'BANKING' and (SubCategory
= '*' OR SubCategory IN (select SubCategory from....))
-Anil.
On Tue, Oct 31, 2017 at 9:23 PM, Dharam Thacker <[email protected]>
wrote:
> Hello Team,
>
> Is there any way I can satisfy below use case with wildcard based query in
> geode?
>
> *Cache Region Data:*
> RuleId,Id,Category,SubCategory,Group
> R1,1,*,*,A1
> R2,1,BANKING,CARDS,A2
>
>
> If input looks like [1,BANKING,*] then I should give group [A1,A2] in
> output as it matches to 2 rules above.
>
> Note : * represents don't care kind of criteria.
>
> Is there other better way to achieve the same thing?
>
> Thanks & Regards,
> - Dharam Thacker
>
