Focal Point
dynamic query for report painter

This topic can be found at:

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

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

If $textField = 'XX'
Where country != 'UA'
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


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
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
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?

Dynamic WHERE with OR's do not get translated by FOCUS

Hope this helps. Big Grin



Kerry Zhan
Focal Point Moderator
Information Builders, Inc.