Re: [Arsperl-users] Qualification string with dates

[Carey M. B. <bla...@gm...>]

Paizo,

Two thoughts...

first:
 "and" is not the same as "AND"

Second:
  \"01-05-2007\" , \"30-05-2007\" look like "DD-MM-CCYY" format to me.
You might have to set ARDATE env to get that to parse correctly at the
API layer. ( maybe ) [ Ref: ConfigGuide-630.pdf pg 313 ]

HTH.

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.




On 5/30/07, Paizo <pai...@gm...> wrote:
> Hi listeners,
>
> I found some troubles trying to use this qualification:
>
> $str_qual = "'Stato Reclamo' = \"Trasferita\" AND 'Gruppo Competente' =
> \"the-group\" and 'Data Trasferimento' > \"01-05-2007\" and 'Data
> Trasferimento'  <  \"30-05-2007\"";
>
> Data trasferimento is a date field.
> Using this qualification with the remedy client works ( advaced search );
>
> with ARSperl i got that error:
>
> ars_LoadQualifier: [ERROR] Cannot open catalog; Message number = 1590
> (position 111   (... > "01-05-2007"^ and 'Data Tras...)) (ARERR #1590)
>
> I don't understand why it works on the remedy client ad won't using ARSperl.
> Any hints?
>
> ty, Paizo