[Arsperl-users] question regarding the query() method
Brought to you by:
jeffmurphy
|
From: <ix...@on...> - 2005-04-27 10:16:59
|
I'm trying to figure out how to properly use qualifiers via the OO query()
method on the SHR:People form. my code is below :
my @entries = $remedy_form->query(
-query => '("Login Name" = "some_user")'
);
this returns an array of field headers but no entries.
i've verified that the 'Login Name' field exists under that name in the form
'Login Name' => 240000005
I suspect that I'm not understanding how to properly phrase a remedy query
and apologize if that is the case here. invoking query() with no arguments
properly returns all entry IDs for the form and i can properly perform a
get() on the form handle to retrieve the entry - i just can't seem to properly
format a filter on the query itself.
does anyone see anything boneheaded i'm doing here? i've tried various quoting
styles for the query, such as "(\"Login Name\" = \"some_user\")", 'Login name'
and 'Login' instead of 'Login Name' and omitting the spaces between the field
name and the '=' in the query as well as removing the parentheses around the
query but none of those seem to work for me. directly using ars_GetListEntry
acts identically.
one thing i've noted ( not sure if this is something the C API deals with or
not ) is that you can specify any field name in the qualifier, whether it
exists or not, and no error is thrown.
the deconstructed qualifier as returned by ars_perl_qualifier() looks like
$VAR1 = {
'oper' => 'rel_op',
'rel_op' => {
'left' => {
'value' => 'Login Name'
},
'right' => {
'value' => 'some_user'
},
'oper' => '=='
}
};
using the standard $all qualifier of "1=1" returns
$VAR1 = {
'oper' => 'rel_op',
'rel_op' => {
'left' => {
'value' => 1
},
'right' => {
'value' => 1
},
'oper' => '=='
}
};
( using "1=1" returns all entries properly, as does "1<2" and other queries
of that nature, so i think i've at least got the basic syntax down. what i'm
probably not understanding are what types of arguments i'm supposed to feed
to the qualifier constructor, tho the examples i've seen in the mailing list
seem to match up with what i'm trying to do )
a little stumped :) - thanks much for any help!
- tom
|