Users

Users are visitors who have login access to your site.

User Role

User Role filters by the capabilities or permissions that users can perform on your website. These include: Editor, Author, Contributor, Subscriber. Your Query can be set up to include User In or User Not In.

Role

The Role parameter filters by the capabilities or permissions of users such as Editor, Author, Contributor, Subscriber.

Filter

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open User Role in panel

9. Find Role

10. Select required filter (Editor, Author, Contributor, Subscriber)

User In

The User In parameter filters by Users that must have at least one of these roles.

Filter

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open User Role in panel

9. Find User In

10. Select required filter (Editor, Author, Contributor, Subscriber)

User Not In

The User Not In parameter allows that Users matching one or more of these roles will not be included in the results.

Filter

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open User Role in panel

9. Find User Not In

10. Select required filter (Editor, Author, Contributor, Subscriber)

Include/Exclude

The Include/Exclude parameter allows you to Include or Exclude specified Users.

Include Users

The Include Users parameter allows you to specify which Users to include.

Filter

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Include/Exclude in panel

9. Find Include Users

10. Input Users to include

Exclude Users

The Include Users parameter allows you to specify which Users to exclude.

Filter

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query editor

7. Select Users in dropdown

8. Open Include/Exclude in panle

9. Find Include Users

10. Input Users to Exclude

Who

The Who property allows you to identify which Users to include.

Filter

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Who in panel

9. Find Which Users

10. Input Names to include

Count

The Count property allows you to choose whether to count the number of Users or not.

Toggle

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Count (in panel

9. Find Total Count

10. Toggle on/off

Network

The Network parameter allows you filter users associated with a particular blog on a multisite network using blog ID

Filter

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Network in panel

9. Input Blog ID

Order

The Order and Order By parameter allows you to choose the order in which you want your users to be displayed.

Order and Order by

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Panel

7. Select Users in dropdown

8. Open Order in panel

9. Select 'order by' terms in dropdown menu

10. Select 'order' direction for users (descending, ascending)

See Order and Order By (Posts)

Pagination

Pagination allows you to choose the number of items you wish to display per page, whether you want any offset and which page you want to be on.

Number of Items

The Number of Items parameter allows you to choose how many items you wish to display on each page.

Filter

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Pagination in panel

9. Find Number of Items

10. Choose number

Offset

The Offset parameter offsets the number of Items you set. For example an Offset of 1 will make the second item become the first.

Filter

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Pagination in panel

9. Find Offset

10. Set required Offset

Page

The Page parameter allows you to choose which page you want to be on.

Select

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Pagination in panel

9. Find Page

10. Input page value

Search

The Search property allows you to Search by Keyword or Column.

Column

ID Search by User ID

User Login Search by User Login

User Nicename Search by User Nicename

User Email Search by User Email

User URL Search by User URL

Search

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Search in panel

9. Input Keyword or Select desired identification (ID, Login, Nicename, Email, URL)

Meta Query

The Meta Query property is a helper that allows you to filter your results by object metadata.

Filter

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Meta Query in panel

9. Find Relation

10. Select And/Or

11. Add new Meta Query

12. Click Name to edit Meta Query

13. Choose Meta parameter (Meta Key, Meta Value, Meta Compare, Meta Type, Relation, Inner Meta Query)

Meta Key

The Meta Key parameter is used to retrieve a saved value from the database and display it.

Add

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Meta Query in panel

9. Find Relation

10. Select And/Or

11. Add new Meta Query

12. Click Name to edit Meta Query

13. Find Meta Key

14. Add Key

Meta Value

The Meta Value parameter allows you to get all the posts with a specific custom field value.

Add

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Meta Query in panel

9. Find Relation

10. Select And/Or

11. Add new Meta Query

12. Click Name to edit Meta Query

13. Find Meta Value

14. Add Value

Meta Compare

The Meta Compare parameter allows you to set up a query using a comparator two sets of values, such as: =, != , >, > , >= ,< ,<=, LIKE, NOT LIKE, IN, BETWEEN, EXISTS, NOT EXISTS, REGEXP, NOT REGEXP, RLIKE, NOT RLIKE.

Comparator

> Less than

>= Less or equal to

< Greater than

<= Greater than or equal to

LIKE Allows you to search for a part of a comment, such as first name contains John but can also be Johnny, Johnathan, etc.

NOT LIKE Inverse of LIKE, must not contain any part of a comment.

IN Must be in

BETWEEN Must be between

NOT BETWEEN Must not be between

EXISTS Must exist

NOT EXISTS Must not exist

REGEXP (Regular Expression) Must match pattern with a sequence of characters

NOT REGEXP (Not Regular Expression) Must not match pattern with a sequence of characters

RLIKE (Regular Expression Liike)

NOT RLIKE (Not Regular Expression Like)

Compare

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Builder icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Meta Query in panel

9. Find Relation

10. Select And/Or

11. Add new Meta Query

12. Click Name to edit Meta Query

13. Find Meta Compare

14. Add Comparator (=, != , >, > , >= ,< ,<=, LIKE, NOT LIKE, IN, BETWEEN, EXISTS, NOT EXISTS, REGEXP, NOT REGEXP, RLIKE, NOT RLIKE)

Meta Type

The Meta Type parameter allows you to set up a query using a Meta Type such as: Numeric, Binary, Char (Character), Date, Datetime, Decimal, Signed, Time.

Add

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Meta Query in panel

9. Find Relation

10. Select And/Or

11. Add new Meta Query

12. Click Name to edit Meta Query

13. Find Meta Type

14. Add parameter (Numeric, Binary, Char (Character), Date, Datetime, Decimal, Signed, Time)

Meta Relation

The Meta Relation parameter allows to associate extra information stored in independent entities (meta entities) to content entities using an And/Or relation and a single or multiple Inner Query(ies).

Add

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Builder icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Meta Query in panel

9. Find Relation

10. Select And/Or

11. Add new Meta Query

12. Click Name to edit Meta Query

13. Find Meta Relation

14. Choose Relation (And/or)

15. Add Inner Meta Query name

Date Query

The Date Query allows you to filter your Users by Date, such as Year, Month, Week, Day, Hour, Minute, Second, Before a selected date, After a selected date, Compare two or more dates.

The Date Query may be inclusive or not inclusive depending on whether you want to include the current date or not.

Filter

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Date Query in panel

9. Find Relation

10. Select And/Or

11. Add new Date Query

12. Click Name to edit Date Query

13. Add Date Query (Year, Month, Week, Day, Hour, Minute, Second, Before, After, Compare)

Toggle Inclusive

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Date in panel

9. Find Relation

10. Select And/Or

11. Add new Date Query

12. Click Name to edit

13. Find Inclusive

14. Toggle on/off

Code

The Code property allows you to copy and export the code generated by the Query you have set up.

Copy

1. Click on the ➕ ​​icon to open the Inserter Panel

2. Select query block
3. Open the Block Inspector

4. Navigate to the Primary tab

5. Find Query Editor icon

6. Click to open Query Editor

7. Select Users in dropdown

8. Open Code in panel

9. Find Code

10. Copy required Code