OpenDocument Datatype error

[Former Member]

Hi,

I'm trying to use OpenDocument syntax to generate a report and save as pdf file but facing an error.

The error is about prompt syntax, in Web Intelligence when prompts shows up, users can select Product via selecting product names like, Coffee, Soda but generated SQLs like below. SQL Calls product names with their IDs.

Where (

Product IN (8,3)

)

The problem starts here when I generate following URL for opening document and save it;

http://<server>:<port>/OpenDocument/opendoc/openDocument.jsp?iDocID=<CUID>&sIDType=CUID&lsSEnter+Pro...

It throws "failed to convert varchar "Coffee" datatype to int.."

Is there any way to avoid that error ?

Is there a workaround without removing numeric indexes ?

Thanks and Regards

David

[arijit_das · Accepted solution]

I guess the prompt for Product is using index awareness. Actually when you select a product from the lov, actually the id (which is an integer) is passed in the prompt. You have to pass the product id in the url, not the text.