Thanks Anil! Thank works well Dharam
- Dharam Thacker On Wed, Nov 1, 2017 at 10:02 PM, Anilkumar Gingade <[email protected]> wrote: > 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 >> > >
