Back to ITRS Internal Only FAQ

Internal documentation only

This page has been marked as draft.

'SQL : Element is invalid

Problem

Provided the setup, gives you an error : Element is invalid

Solution

The issue was rectified, by removing the “where” clause in the below statement.

Plugin > Gateway-sql > Views > sql

Select file_name, sub_ext_ctl_finish as latest_modification_time, null, status from T1

Union all

Select file, latestfile as latest_modification_time, filecount, null from T2

It gives you this output

For further learning, this can help.

Geneos - Gateway SQL - Using XPath Sources – Support - ITRS Group