PS Query & SQL

 View Only

  • 1.  Using In List for Emplids

    Posted 25 days ago

    Good morning -

    I apologize if this has already been discussed.  I was wondering if there is a way to include a list of emplids without using the 'In List' option?  I have over 100 emplids I would like to process, but adding one-by-one using 'In list' is extremely time consuming.

    thank.

    Patty



    ------------------------------
    Patricia (Patty) Bergin
    Functional Application Specialist
    Syracuse University
    pbergin@syr.edu
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.pbergin@syr.edu
    ------------------------------
    HEUG ANZ - Brisbane, 9-10 September 2026


  • 2.  RE: Using In List for Emplids

    Posted 25 days ago

    There have been a couple of different ways to do this offered up when I was asking for tips and tricks.  If you go to the front page of the PS Query & SQL list, scroll down and you'll see a link for the tips & tricks list.   Look at the different ideas and pick the one that you like the best.  They all work.  I love this group!

     

     

     

     

    Thanks!

    Dana Pawlowicz

    Business Systems Analyst Sr - ERP

    Digital Platforms & Innovation
    Digital Technology Solutions

    University of Cincinnati

    51 Goodman Dr.

    Cincinnati, Oh 45221

     

     




    HEUG ANZ - Brisbane, 9-10 September 2026


  • 3.  RE: Using In List for Emplids

    Posted 25 days ago
    Thank you!

    Patricia (Patty) Bergin

    Functional Application Specialist

    Enrollment Management

    T 315.243.0111

    pbergin@syr.edu

    Syracuse.edu

    Syracuse University

     




    Original Message
    HEUG ANZ - Brisbane, 9-10 September 2026


  • 4.  RE: Using In List for Emplids

    Posted 25 days ago
    Hi Patty!

    Here is the thread from a little ways back that talks about a few different ways to handle this:


    I am personally a fan of ANY().

    Jeffrie

    --
    Jeffrie Brooks | BUSINESS SYSTEM ANALYST
    UNIVERSITY OF MICHIGAN | INFORMATION AND TECHNOLOGY SERVICES
    734-647-8763 | jedobr@umich.edu



    HEUG ANZ - Brisbane, 9-10 September 2026


  • 5.  RE: Using In List for Emplids

    Posted 25 days ago
    Thank you!  

    Patricia (Patty) Bergin

    Functional Application Specialist

    Enrollment Management

    T 315.243.0111

    pbergin@syr.edu

    Syracuse.edu

    Syracuse University

     




    Original Message
    HEUG ANZ - Brisbane, 9-10 September 2026


  • 6.  RE: Using In List for Emplids

    Posted 18 days ago

    Patty,

    Last year at the HEUG, I had this tip in my presentation but also threw in an excel document that automatically put in that formatting needed for the any function.  Happy to email it to you if you would like.

    Melissa



    ------------------------------
    Melissa Borchardt
    Senior Business Analyst
    The University of Texas System - Grants SIS Team
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------

    Original Message
    HEUG ANZ - Brisbane, 9-10 September 2026


Related Content