(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
> Arsperl-users@arsperl.org
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
-------------------------------------------------------------------------
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
Arsperl-users@arsperl.org
https://lists.sourceforge.net/lists/listinfo/arsperl-users
