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

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

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.