PSFS IQ - Query Builder: How to get a list of My Own Users

How to get a list of My Own Users

PSFS_IQ_Nav.png

To get a list of My Own Church Users you will use the columns and query conditions below. You may add additional columns if you need additional information.  The items listed are needed to get a basic list of My Own Church Users. 

 If you are unfamiliar with using the IQ module please start with the following help articles/videos below.

  1.  Once you have familiarized yourself with the IQ Module, to create a query, go to IQ → Query Builder.
  2. Populate the Results Column with at least the following fields.
    • Members DUID
    • Families Last Name
    • Members Full name
    • Members User Name
    • Members Contact Info  Email address
  3. Populate the Conditions section with the following:
    • Members Username  is not null
    • and  Families Owner Organization Organization ID  is equal to     #####
      • Note: replace ##### with your organization ID
        Query_for_MY_OWN_Church.png

  4. Once you are satisfied the Query is set up as instructed, you may run the query. If you are new to this, you may want to see this section of the article linked above, "How to run a query."

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request