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
At the December Community Council call we discussed taking a moment to reflect on the past year. It inspired me to decide to take a moment to reflect on my own past year professionally and within HEUG. As I reflect on the past year, I’m struck most by how deeply community has shaped my...
Just to address the "from" clause in expressions, I researched this once, and was told that PSQuery has an absolute prohibition of this, as it would allow you to bypass the row level security that certain tables have in PSQ. Of course, there are much easier ways to bypass that security, but that...
Aaron, In my experience, I've never been able to create a query in PSQuery without at least one record in the FROM statement. However, there may still be a solution to your issue. Here at CU, we have a record named PTIA DUAL. It has a single field named PTIA DUMMY which always returns a...
When I want to pull a certain row out of subquery, I first have to know what is the maximum number of possible rows. Let's say it is higher, like 40, in which case I would include a buffer and account for as many as 50 or 60. I join to ACAD PLAN TBL, hopefully by INSTITUTION if possible. Then I...
I'll decline to post the actual query for a few reasons. Our DBA's already reviewed it, and their solution was to put the wrapper around it I described. It calls a custom view which actually is causing the Cartesian join and we worked around that specific issue by using a delivered table. We...
Alliance2025-Bharathi Slides.pptx
Would you mind sharing your query and letting us know what issues you are having with it? What's your end goal. What are you trying to accomplish? There might be another way. We've had issues with queries that run great and then all of a sudden run bad. I think the one that was...
An expression within PS Query will not allow a FROM clause. While it would seem simple to just build the inline Query in an expression and list it as your first field, the PS Query tool itself is blocking the use of a FROM clause. If you try creating an expression with a FROM clause in it, you...
Good Morning Aaron - As your reading of past emails indicates, I don't think you can embed a FROM clause into a query using an Expression. I will not say that categorically, because there are a lot of really smart people on this list, and one of them might have figured out a way to do this. ...
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