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 Sep 10, 2019 by Kristian Nordman

Hello

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.

Example:

   Select a.email, a.user, a.group 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.

Outcomes