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 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
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License