Newbie Question

CKelly at affiliatedtrans.com CKelly at affiliatedtrans.com
Thu Jan 8 09:15:06 PST 2015


But how would I go about having the value be dynamic? 

/u/appl/filepro/vregstr> /u/appl/fp/dreport vregstr -f CAK_Data1 -u -p /tmp/Anzio_Shipment_Mapping -pc "nocodes" -s cakSelection1

This works with a saved selection but I want the value I am looking for to be dynamic

-----Original Message-----
From: onlinemgt at gmail.com [mailto:onlinemgt at gmail.com] On Behalf Of daN baueR
Sent: Thursday, January 08, 2015 11:07 AM
To: Christopher Kelly
Cc: filePro Mail Group
Subject: Re: Newbie Question

On Thu, Jan 8, 2015 at 11:01 AM,  <CKelly at affiliatedtrans.com> wrote:
> I recently started at a company utilizing FilePro.
>
> I am able to export ALL records without issue using a command as follows.
>
> /u/appl/fp/rreport vregstr -f CAK_Data1 -a -u -p /tmp/cak_output -pc "nocodes"
>
> But I would like to limit the results based on a dynamic selection Field 60 eq "ReadyToProcess"
>
> I can do this via the request output application via a selector sentence but how can I do it via script?
>
>
>
> Christopher A. Kelly   |   IT Development / Administration   |   Affiliated Transportation Systems, Inc.   |   ckelly at affiliatedtrans.com<mailto:ckelly at affiliatedtrans.com>   |   888.668.2874 x102
>
>

The easiest way (in my opinion) would be to create and name a
selection set. Depending on what you're looking for in field 60.
Something like:

60 eq Y

Save that with a name of 'vregstr' for instance and then your script
line would just have to change to:

/u/appl/fp/rreport vregstr -f CAK_Data1 -s vregstr -u -p /tmp/cak_output -pc "nocodes"

I suggest using the same name for the selection set to remind you at a
later date that it's associated with a specific report.

Dan Bauer
dan at onlinemgt.com


More information about the Filepro-list mailing list