Skip to Content
avatar image
Former Member

Using @prompt in a free hand sql report

I have a freehand sql report, that I have with oracle code. For simplicity and privacy, lets say the sql is the following:

select t.id, t.name, t.qty from test_table t  where t.id = '1234'

However, I want to pass a parameter to this free hand sql report using a prompt so that a value is passed from one report to this free hand sql report via the url. I have done that in the past by creating a prompt in the report. However, seeing that this report is a free hand sql report the interface that is used to add a prompt when the data provider is a universe does not exist for free hand sql report. After some research I attempted to build in the @prompt in the sql itself so I end up with:

select t.id, t.name, t.qty from test_table t  where t.id = @prompt('Enter ID', t.id)

This threw the following error "An error has occurred from the server. Incorrect prompt definition". I tried several variations of the prompt syntax, but they all gave the same error.

My question is can I build a prompt in a free hand sql report so that I can pass parameters to the report as I can with a report using a Universe? If so, what is the syntax that goes within the sql code itself. Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 22, 2017 at 02:06 PM

    try this.

    = @Prompt('Enter ID','A',,Mono,Free,Persistent,,User:0)

    Add comment
    10|10000 characters needed characters exceeded