Focal Point
dynamic query for report painter

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1821032451

February 14, 2006, 11:59 AM
Maria Tan
dynamic query for report painter
Hi;

I have an text field in report painter and i need to retrieve it in my SQL report.

If $textField = 'XX'
Where country != 'UA'
else
where country like $textField.

Since i did everything through DevStudio, i don't know the focus language. Can you tell how can i write it in focus language.

Thanks in advance

-M


====================
Production: WebFOCUS 7.1.1 on Window 2003
WebFOCUS 7.1.1 Client on HP-UX on WebLOGIC 8.1 sp4
Dev: WebFOCUS 7.6.4 on Window 2003
WebFOCUS 7.1.1 Client on HP-UX on WebLogic 8.1 sp4
February 14, 2006, 02:26 PM
TerryW
Using the values you provided, the syntax would be something along the lines of:

WHERE ( $textField EQ 'XX' AND country NE 'UA' )
OR ( $textField NE 'XX' AND country LIKE $textField )
February 20, 2006, 01:56 PM
Kerry
Hi Maria,

Has this issue been resolved? Did Terry's suggestion help you?

I ran a quick search on Information Builders' online documents and came across the following topics which may be of interest:

How to pass a dynamic value to an Oracle stored procedure?
http://techsupport.informationbuilders.com/ibi/sps_i/83521040.html

Dynamic WHERE with OR's do not get translated by FOCUS
http://techsupport.informationbuilders.com/sps/73121062.html

Hope this helps. Big Grin

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.