Why can't I query in Visual Composer?

[Former Member]

Hi,friends:

I did a query application, but when query it fialed.

I changed the SQl Edit, but it can not save.How can I resolve the problem?

Best Regards!

[Former Member · Accepted solution]

Need more details. Is this a query in BI or is this a JDBC source to a database? If you are trying to work with the SQL Editor, see this how to guide I put together on working with the SQL Editor.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/6339e7d4-0a01-0010-1c98-db0...

Cheers,

Prakash

[Former Member · Accepted solution]

Thanks!

We use JDBC to connect DB. We use SAP NetViewer to design programme.Now I found the report was a big problem , I konw some details to design reports but do not know the first step to set the tools and begin to use. Can you help me?

[Former Member · Accepted solution]

Prakash:

Thank you very much!

I can query data with your help, but I can not filter data. How can I query with the input data?

[Former Member · Accepted solution]

In the SQL Editor insert a WHERE-clause in your statement and pass parameters like WHERE myparam1 =' & @myparam1 & ', with @myparam1 coming from the input form.

[Former Member · Accepted solution]

Thank you Mario Herger !

I have resolved the problem.

[Former Member · Accepted solution]

How can I use several tables to query?

This demo only querys a table.

[Former Member · Accepted solution]

Use the Bi Integration Wizard, select a BI JDBC system and you are free to go and select multiple tables and join them.

As mentioned in another thread, it might make more sense to create the joins already on the backend database, as they perform better there.

[Former Member · Accepted solution]

Thanks Mario Herger

When I select a table to continue, there is a query error.

Can you give me some docs about BI Integration Wizard?

[Former Member · Accepted solution]

Do a system connection test. Does the system connection test succeed on the portal?

[Former Member · Accepted solution]

I have test the connection successfully. The BI intelgration wizard can not provide the tables joins function,It only can compare tables with "=",">" or "<" etc.

[Former Member · Accepted solution]

Did you choose the freestyle template in the BI Integration Wizard?