PSQuery : FROM clauses are not allowed in expressions :Workaround

August 2, 2011

In People Tools 8.49,8.50 from clause can be used in Expressions in PS QUery as follows.
(Select 1004 fr%table()om psclock)

But it throws the below error in 8.51.

You can use the Following Work Around to Overcome this issue.

Step 1.> Create a SQL Object  Appdesigner (Nane : HF_FROM)   (Use   ” FROM ”  as a SQL Text
Step 2 .> Modify or Create Expression Using this SQL Object 
    For Eg   OLD Expression  : SELECT   distinct NAME FR%TABLE()OM PS_NAMES  WHERE EMPLID =X.EMPLID
                     New Expression  : SELECT   distinct NAME  %SQL(HF_FROM)  PS_NAMES  WHERE EMPLID =X.EMPLID


Follow

Get every new post delivered to your Inbox.