 |
 |
 |
Modeling: User's Guide |  |
 |
|
|
|
|
Modeling: User's Guide | |
|
|
Suppose you want to get all the writers whose names begins with 'Hu', you'll write:
objects=ec.fetch('Writer', qualifier='lastName like "Hu*"')
Available wildcards are '*' and '?'. The former matches any
number of characters (including 0 -zero- character), the latter exactly one
occurrence of a character.
You can also use the operator 'caseInsensitiveLike':
objects=ec.fetch('Writer', qualifier='lastName caseInsensitiveLike "hu?o"')
'Hugo', 'Hulo', 'HUGO', 'hUXO', ...
Alternatively, you'd probably prefer to use a shorted alias for
caseInsensitiveLike: ilike
objects=ec.fetch('Writer', qualifier='lastName ilike "hu?o"')
Last, if you want to add raw '*' and '?' characters in a like
pattern, escape them. For example, this fetchs all books whose title ends with
'here?':
objects=ec.fetch('Book', qualifier='title like "*here\?"')
|
|
|
Modeling: User's Guide | |
|
|