ahmednrana/condapp.sql

Created December 19, 2019 06:39

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ahmednrana/5e5e187f7e1a9ae32c9496f18bbfcad7.js"></script>
Save ahmednrana/5e5e187f7e1a9ae32c9496f18bbfcad7 to your computer and use it in GitHub Desktop.

Download ZIP

Conditional expression used in a app maximo

Raw

condapp.sql

SELECT * FROM CONDITION WHERE CONDITIONNUM IN  (SELECT CONDITIONNUM FROM CTRLCONDITION WHERE CTRLGROUPID IN (SELECT CTRLGROUPID FROM CTRLGROUP WHERE app = 'ECRF')); -- depends upon control Group

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment