arsperl-users

[Arsperl-users] Qualification string with dates

[Paizo <pai...@gm...>]

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

-- 
CFAH3 CUT-LASS

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

Re: [Arsperl-users] Qualification string with dates

[Ian T. <I.D...@op...>]

Paizo 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

Paizo,

Dates are funny things when used in qualifications within ARSperl.  The 
string format of the date has to be just right for the server to 
recognise as a proper date.  I find it easier to use some of the Perl 
date functions to turn a date string into an integer value (Date::Calc 
is our favourite tool, but you can use Time::Local, which is (usually) 
built-in).  If using integer date values then you obviously don't need 
to wrap them in quotes.

Hope this helps,

Ian

------------------------------------------------------------------------
Ian Trimnell, AR System Lead Developer (amongst other jobs),
Specialist Support & Information Team, Academic & Administrative 
Computing Service
Open University, MILTON KEYNES, UK
Phone: 01908 653741   web: http://www.open.ac.uk/