Newbie Question
daN baueR
dan at onlinemgt.com
Thu Jan 8 10:13:02 PST 2015
On Thu, Jan 8, 2015 at 12:15 PM, <CKelly at affiliatedtrans.com> wrote:
> 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
>
If the value is random you'll need to using processing. Either
directly attached the the report or using a -v table selection table.
While you're in report edit mode there's a option F8 for extended
options. Then P for processing. Try a simple prompt as follows
if:
then: input oa(8,*) "What are you looking for? "
if: oa eq 60
then: select
This is the slowest way of getting there but should get the job done.
daN baueR
dan at onlinemgt.com
Cell 516-670-8940
-----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