How to include sql function in an sql query in Dataset using Opentext Birt tool


I would like to add an sql function in the SQL query using Case condition in the Dataset using BIRT tool. Could anyone please help me how to write a query for this. Or if there any other option like mapping in the tool. Thanks in advance.

Thanks & Regards,


  • The query syntax depends on the database. Birt doesn't have its own query language. It simply passes the query to the database through the database driver and the result is returned. Look at what the database expects for syntax. You can find the syntax by searching the web, looking at the database user guide, or asking on a forum for the database you are using.

    Jeff F.
    Customer Support Engineer I
Sign In or Register to comment.