Just type what you're interested in finding into the search box below! Discover discussion posts, blog articles, and files for Activity Guides, PUM, Fluid, Processes, Jobsets, Certificates, Frameworks, and much more across the HEUG Community.
Search Tips
The SQL statement that will run is the concatenation of the current effective dated from table EQTN SQL CHUNKS. This can be different from field EQTN SQL TEXT on table EQTN SQL TBL. 1) DELETING a row from EQTN SQL TBL does not automatically delete from EQTN SQL CHUNKS. To properly delete it...
You really just need to put anything that causes it to re-parse the SQL. I've even added a comment to make the darn thing shuffle. -- Sarah Hoegger Business Analyst University of Minnesota hoegg001@umn.edu --
Hi Scott, I work on the CS side, but we have access to the JOB table and experience the same issues you describe. If I'm building a query for myself or for someone with access to the Process query type, I do what Tom suggested and create a Process type query. For queries where the end user...
A27 Proposal Submission Guidelines.pdf
Ending IN-expressions with AND 1 and then creating a criteria where the expression = 1 has become "the standard way" of writing IN-expressions at CU. I can't say exactly where the practice originated. But it's a method I inherited from the generation before me.
I had this a few years back and Vic Goldberg gave me this query. And now, whenever I create a new callable SQL, I run it against the query. If anything is missing, I add "AND 1 = 1" to the bottom and that fixes it. Works every time. You have to pay attention to your parenthesis of course. ...
Aaron, Thanks for sharing this! We ran into this issue a few years back with a callable SQL and somehow stumbled on the solution that we needed to take our single IN() statement and break it into 4 different IN() statements in order to get it to work. Its good to know the concrete reason why...
Finance
HCM
Student Systems
CRM
Technical
Careers
Alliance
International / Regional
E-Academy
User Membership
Corporate Membership
Finance / HCM / Student Systems / CRM / Technical
Alliance / International / Regional / E-Academy
User Membership / Corporate Membership