Re: [Arsperl-users] Querying the same date-time field is not working

[Bruno M. P. G. <bru...@ya...>]

:) problem solved.

It seems that the API receives a date format different than the one in our ARS Remedy.

I just reverse the order of the date and it worked.

Instead of dd/mm/yyyy I used yyyy/mm/dd

Cheers.

 
Bruno Gomes
PT: +351 966 175 401
BE: +32  485 937 881
bru...@ya...

AVISO
Não imprima esta mensagem. O ambiente agradece. Esta mensagem (incluindo quaisquer anexos) pode conter informação confidencial para uso exclusivo do destinatário. Se não for o destinatário pretendido, não deverá usar, distribuir ou copiar este e-mail. Se recebeu esta mensagem por engano, por favor informe o emissor e elimine-a imediatamente. Obrigado.

DISCLAIMER
Do not print this message. The environment thanks you. This e-mail (including any attachments) may contain confidential information for exclusive use of its recipient. If you are not the intended recipient you must not use, distribute or copy this e-mail. If you have received this e-mail in error please notify the sender and delete it immediately. Thank You.



>________________________________
> From: Bruno Manuel Pinto Gomes <bru...@ya...>
>To: "ars...@li..." <ars...@li...> 
>Sent: Thursday, March 15, 2012 11:53 AM
>Subject: [Arsperl-users] Querying the same date-time field is not working
> 
>
>Hi there,
>
>
>I'm trying to use the following query to retrieve data from ARS Remedy
>
>query="'System'="TACT" AND ('Date & Time'>="01/01/2011" AND 'Date & Time'<="01/02/2011")"
>
>
>It returns 0 elements :(
>
>
>If I use 
>
>query="'System'="TACT" AND 'Date & Time'>="01/01/2011""
>or
>query="'System'="TACT" AND 'Date & Time'<="01/02/2011"
>, it works.
>
>
>Is there any known limitation that we can't use the same field twice?
>
>
>CODE:
>sub query {
>
>    my ($self,
 %params) = @_;
>    my (%record_hash);
>    
>    # Arguments check (query/schema must be defined)
>    die "query: Invalid arguments \n"
>        unless ( exists $params{query}  && 
>                 exists $params{schema} && 
>                 exists $params{fields} );
>
>    # Remedy object wraps ARSperl OO connection (ARS object)
>    my $ars_conn = $self->{ars_conn};
>
>    # Store mandatory arguments
>    my ($query, $schema, $fields) = @params{'query','schema','fields'};
>
>    # Open a new form (cache fields) returns ARS::form object
>    my $form =
 $ars_conn->openForm ( -form => $schema );
>    
>    # Query Remedy for Record Id's matching criteria 
>    my @record_ids = $form->query ( -query => $query );
>    
>    # Iterate thro' record Id's
>    for my $record_id (@record_ids) {
>    
>        # Query fields for each record ID  
>        my @field_values = $form->get ( -entry => $record_id,
>                                        -fields => $fields );
>    
>        # Add field value(s) to record hash (structure) 
>        $record_hash{$record_id} = [ @field_values ];
>    }
>
>    # Return REF to record hash (structure) 
>    return \%record_hash ;
>}
>
>
>
>$record_hash_ref = $r_conn->query(
>        query => $query,
>        schema => $schema,
>        fields => $fields);
>
>
>
>Thanks
>
>
>Kind regards
> 
>Bruno Gomes
>PT: +351 966 175 401
>BE: +32  485 937 881
>bru...@ya...
>
>AVISO
>Não imprima esta mensagem. O ambiente agradece. Esta mensagem (incluindo quaisquer anexos) pode conter informação
 confidencial para uso exclusivo do destinatário. Se não for o destinatário pretendido, não deverá usar, distribuir ou copiar este e-mail. Se recebeu esta mensagem por engano, por favor informe o emissor e elimine-a imediatamente. Obrigado.
>
>DISCLAIMER
>Do not print this message. The environment thanks you. This e-mail (including any attachments) may contain confidential information for exclusive use of its recipient. If you are not the intended recipient you must not use, distribute or copy this e-mail. If you have received this e-mail in error please notify the sender and delete it immediately. Thank You.
>------------------------------------------------------------------------------
>This SF email is sponsosred by:
>Try Windows Azure free for 90 days Click Here 
>http://p.sf.net/sfu/sfd2d-msazure
>
>
>--
>Arsperl-users mailing list
>Ars...@li...
>https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
>