0
  1. Suppose I have 4 columns. I want write query as Select Name,Age,DOB,'' as Salary; I am not able to write ('' as Salary) in easy query?
  2. Also I am not able to use union in easy query?
  3. How to write sub query in Select statement?

1 Answers1

1

First of all - did you mean EasyQuery by Korzh.com (https://korzh.com/easyquery)? If so - why don't you contact their support team first?

  1. As far as I know:

    • you can set a title for each column right in Columns Panel widget
    • there is no way to create UNION queries using EasyQuery UI directly. But you can create two separate queries and concatenate them
    • You can define a virtual attribute (field) with sub-query statement in its expression and then use that new attribute the same way as any other in your model