Monday, March 3, 2014

Making Sub Query as Field in PS Query

Below are the steps to make sub query as Field in PS Query


 1) Create an SQL object with your Sub Query
2) Add an expression using %sql() Meta Construct variable
    EX:  %sql(Your SQL Object Name)
3) Add expression as a field
4) Save PS Query..
Posted by at

5 comments:

  1. AnonymousSeptember 28, 2016 at 7:02 PM

    :) Thank you !!

    ReplyDelete
  2. AnonymousJuly 4, 2017 at 8:32 AM

    Hi,

    I tried the above method however application is still giving error as 'FROM clauses are not allowed in expressions (50,536)'

    Did i miss anything :(

    Thanks

    ReplyDelete
  3. AnonymousSeptember 27, 2017 at 4:01 PM

    I believe this is not possible in latest version 8.54

    ReplyDelete
    Replies
    1. AdminJanuary 29, 2018 at 2:31 PM

      Hi, This is not possible post 8.53, thanks :)

      Delete
  4. Hamlet MéndezSeptember 26, 2019 at 2:23 AM

    Any other solution?

    ReplyDelete

Subscribe to: Post Comments (Atom)