AnsweredAssumed Answered

Multiple Select commands in a Collector query - This statement type is not supported

Question asked by Shlomo Katz on Sep 9, 2019
Latest reply on Mar 18, 2020 by Ian Staines


G&L version 7.1.1.p1 an p2

I was supplied a complex sql query to gather information from a SQL database.

In order to get the information it requires two select (in-line?) statements.


   Select, a.user, from user_account UA

   (SELECT a.user_account_key, MIN(b.entry_time) FIRST_LOGON, MAX(b.entry_time) LAST_LOGON, COUNT(*)    NUM_LOGONS ......
   FROM user_account A)


When I run the test it responds with This statement type is not supported


There are a lot of inner joins as well, but the issue seems to only occur when the second query is added.

The full query works from in SQL Developer.