Re: [Arsperl-users] ars_GetTable or ars_GetEntry or what?

[Thilo S. <thi...@ap...>]

(1) Look up the table field properties (form, columns, qualification) in 
the admin tool.

(2) Implement a combination of ars_GetListEntry/ars_GetEntry to retrieve 
the data, using the information from (1). Basically it will work like this:


my $qualStr = qq/'$fieldId' = "$value"/;
my $qual = ars_LoadQualifier( $ctrl, $form, $qualStr );
die qq{ars_LoadQualifier( $form, "$qualStr" ): $ars_errstr\n} if 
$ars_errstr;


my %entryList = ars_GetListEntry( $ctrl, $form, $qual, $maxRetrieve, 
$firstRetrieve );
die "ars_GetListEntry( $form ): $ars_errstr\n" if $ars_errstr;


my @fieldIds = (); 	# get all fields
foreach my $entryId ( keys %entryList ){
     my %entry = ars_GetEntry( $ctrl, $form, $entryId, @fieldIds );
     die "ars_GetEntry( $form, $entryId ): $ars_errstr\n" if $ars_errstr;
}


Regards,
Thilo Stapff


Christopher Rogall schrieb:
> Hi
> 
> please first open the attachment (is only a .gif-file). Here you see my BMC Remedy User Desk. How can I get this Information out of this tables?
> 
> I know that the upper Table called tbl.PMUR:NAVGroup and has the id 536870948 and the lower Table called tbl.PMUR:NavPersonal and has the id 536870950.
> 
> Can anyone help me?
> 
> Thanks, Chris
> 
> and don´t forget the Valentine's Day! ;)
> 
> 
> ------------------------------------------------------------------------
> 
> 
> ------------------------------------------------------------------------
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users