Error using UNION

Applications SQL Builder
#1

Guys, wanna ask

When i’m using “Select” Data Type and in the Lookup Setting, the query i used using UNION it works fine

but, when i’m using “Text Auto-Complete” Data Type and in the Lookup Setting, the query i used using UNION it doesn’t work

Is this a bug or what ?

I already checked my query using Query Builder, it works fine

Thanks

#2

Perhaps it’s a bug, I don’t know. But a work-around might be to create a view.

#3

I hope it’s reported to bugs team if it is. Thanks albert

#4

Hello,

Issue reported to our bugs team.

regards,
Bernhard Bernsmann

#5

Guys, Is there any news about this update ?

#6

For addition information about Error using UNION,

I have :

  • Data Type “Select”
  • Lookup Settings -> SQL Select Statement using UNION
  • it work well after compiling

But, If we use “Ajax Processing - Events onChange” to pass parameters to next Data Type “Select”, the data show nothing, only “loading process”…

need Solution…