I have a maintain that is calling a Web Link to a report. This report has variables that are being passed. The user can filter to make the selection smaller or leave the input box empty to select all. However, right now, I'm being asked to enter a value for all the input boxes rathen than assigning the box with blank or simply ignoring it. How to i make this work so that it only filters on the values I put into to the box

jbond, can you please post some more info.

I do have a feeling that the issue is with WebFOCUS Autoprompt, that is purely a guess.

If the requests for the amper variables are coming from the TABLE then just use:
-DEFAULT &VAR = '';
Where &VAR is the name of your variables. This way, if a value is not supplied the default blank value will be used.

If the problem is coming from the Maintain side, preset the variables with a blank (" ") and just ignore it in the Table. If neither suggestion help, please post your code.

Thanks
Mark

Mark,

I have a button on a form that calls the following

Web Link OnBtnPrint_Click
printrec
End

In this form, the user call filter selection to narrow the search. I have set the parameters using the tool and pointing it the value on the form.

I then set the variables to the following fex:


-SET &WHR_SCD1 = 'WHERE (PSORT EQ ' | &SORT || ' ) ' ;
-SET &WHR_SCD2 = ' OR (ISORT EQ ' | &SORT || ' ) ;' ;
-SET &WHR_SCD = &WHR_SCD1 || &WHR_SCD2 ;
-GET_NEXT2
-DEFAULT &1=' '
-* &2 DOC NUMBER
-DEFAULT &2=' '
-* &3 FORM NAME
-DEFAULT &3=''
-* &4 VENDOR NAME
-DEFAULT &4=' '
-* &5 PURCHASER
-DEFAULT &5=' '
-* &6 INVOICE NUMBER
-DEFAULT &6=' '
-* &7 FISCAL YEAR
-DEFAULT &7=' '
-* &8 INDEX
-DEFAULT &8=' '
-* &9 OBJECT
-DEFAULT &9=' '
-* &10 PCA
-DEFAULT &10=' '
-* &11 PROJ/WP
-DEFAULT &11=' '
-* &12 SUMMARY AMT FROM
-DEFAULT &12=' '
-* &13 SUMMARY AMT TO
-DEFAULT &13=' '
-* &14 PARK UNIT
-DEFAULT &14=' '
-* &15 FUNCTION
-DEFAULT &15=' '
-* &16 DETAIL AMT FROM
-DEFAULT &16=' '
-* &17 DETAIL AMT TO
-DEFAULT &17=' '
-DEFAULT &18=' '
-* &17 DETAIL AMT TO
-DEFAULT &19=' '
-DEFAULT &20=' '
-DEFAULT &21=' '
-* &18 RECORDLIMIT
-DEFAULT &22=500
-* &19 SCREEN FLAG
-DEFAULT &23='EXP'
-* &20 SORT CODE
-DEFAULT &24='BH'
SET ALL=ON
-SET &FILE001=&23 || '001';
-SET &FILE002=&23 || '002';
-SET &FILE003=&23 || '003';
-SET &FILE001P=&23 || '001.';
-SET &FILE002P=&23 || '002.';
-SET &FILE003P=&23 || '003.';
-SET &WHR_RECNBR = IF &1 NE ' ' THEN 'WHERE RECNOZ LIKE ' | '''' | &1 | ''''| ' ;' ELSE ' ' ;
-SET &WHR_DOCNBR = IF &2 NE ' ' THEN 'WHERE DOCNO LIKE ' | '''' | &2 | ''''| ' ;' ELSE ' ' ;


But, when I click on the button, I'm being prompted to provide a value to the input box. I need it to ignore it when
I don't select anything.



jd

Ok. I am assuming that the field that you are being prompted has IBIValidation set on. If you don't need it on, set it to 0 - No.

What I tell users to do in the JavaScript triggers is:
Form.Field_Edit.value=' ';

The issue is, you can't do that before a URL trigger. You could change the URL call to a:
window.open(url) call, and substitute the url here. That would allow you to set a temp value to the input field AND call the report.

Do either of these techniques work for you?

Mark

Mark, good pickup, IBIValidation is one of those things that is hidden away until.

I agree with you with the URL call, but would be wary of just calling a URL, security wise, as the call will go into the history.

Is this sensitive info ?

You may want to submit a form and post the info.