[INCORPORATED] NITRO ADMIN - DataSource - Free SQL

[ThierryC]

currently it seems that a UNION or a WITH is supported within an sql statement.

Is there any change this might become available in the future?

currently to solve this, i need to create a new sql view..

[Johnny Major]

Thierry,

UNION or WITH should work in NAB SQL based data sources.

Can you share a full example statement that isn’t working for you?

Thanks

[ThierryC]

Hi Johnny,

Just restarted the apache instance, and now seems to be working again..

However i ran into another problem.

when i use the following datasource as an example

SELECT  cxcuno,  cxcunm
FROM  codat/cxx
UNION
SELECT  arnartk,  arxarkl
FROM codathu/cobarpf
ORDER BY 1 

the data source is valid, however when adding a grid-widget, i come into an error, saying that it has problems with the order by of column 1....

Server Error

An unexpected error occurred on the server. See Valence error log for further details.

Description: SQL statement prep failure (SQLSTT=42707) - SQL0208 - Kolom ASC of expressie in ORDER BY niet in resultaattabel.

Error Log ID: 61 

[Johnny Major]

Thierry,

We were able to replicate the issue and hope to have a fix in our next 5.2 update.

Thanks for reporting it!

[ThierryC]

great..; thats good news...
although i discovered that giving the same name to the column that needs to be ordered also solves it..
example below works

SELECT  cxcuno as col1,   cxcunm
FROM  codat/cxx
UNION
SELECT  arnartk as col1 ,  arxarkl
FROM codathu/cobarpf
ORDER BY col1