Resolve Meta-SQL


Meta-SQL is really handy, it lets you write database independent SQL and there are some really nifty Meta-SQL functions for handling joins, effective dates and the other PeopleSoft nuances.

But what do you do when you want to grab some Meta-SQL and put it into your favourite query tool? Do you have to go through and adjust the SQL accordingly? Nope, its as easy as using the Resolve Meta SQL function in application designer.

Simply right click in the SQL editor and click on Resolve Meta SQL and watch as the SQL is generated for you in the Meta SQL window.

Here's an screenshot with the HR view, DEPT_SEC_SRCH:

resolve-meta-sql.png


Revision #1
Created Tue, Jul 23, 2019 12:27 PM by PeopleSoft Wiki
Updated Sun, Aug 11, 2019 12:51 PM by PeopleSoft Wiki