> You can query for things that start with a sub string but specifying a start > value and an empty end value or an end value that is the start value > concatenated with the max ascii character. Then just make multiple calls, > say getting 1000 cols/rows at a time.
What do you mean by concatenated with the max ascii character when looking for things that end with something? Can you please bring an example? Thanks, Miriam > Hope that helps > Aaron > > On 26 Jul, 2010,at 01:05 AM, Miriam Allalouf <miriam.allal...@gmail.com> > wrote: > > Hi, > I need to build a mode where I can retrieve an ordered list of objects > sharing the same prefix and contains a certain delimiter. > > For example: Get all the object names that start with 'root' and > contain '/' in it, > given the names: > r...@abc/ddd > r...@bbb/c > r...@pppp > > should return the first two names (r...@abc/ddd r...@bbb/c) > > I can build the model such that the a lot object name is a key or a column > name. > Can we retrieve a key or a column name using such filter or other > regular expression-like filters? > Thanks and I will appreciate you help, > Miriam >