franky4 Posted March 14, 2019 Share Posted March 14, 2019 I'd like to use the graphical SQL-design editor in the Dataset Query Dialog tab DIAGRAM.I added two tables and joined them via drag'n'drop of one key field that is available in both tables. So far so good.The SQL-Statement (tab Texts and Outline) is correct and works (... from tabA inner join tabB on tabA.key1 = tabB.key1)Now I would like to add a second join requirement (... and tabA.key2 = tabB.key2) via graphical diagram-editor, but when I do this all tables in the diagram disappear and the outline-tab and text-tab have no FROM-part anymore.Perhaps it's a bug (in Jaspersoft Studio 6.6.0 community ed. Win 64 bit), or did I do something wrong? Link to comment Share on other sites More sharing options...
Friendly User Posted March 14, 2019 Share Posted March 14, 2019 This does sound like a bug, I'd suggest reporting it here:https://community.jaspersoft.com/node/add/bug Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now