PS Query & SQL

 View Only

  • 1.  Using In List for Emplids

    Posted 2 hours 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 2 hours 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 2 hours 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


Related Content