Filters for the watupro-takings Shortcode

Note: by default this page contains administration functions and is not visible to public. You can allow public read-only acces to this page by passing public=1 as shortcode attribute.

The attribute wrap=1 ensures that the shortcode is placed in a scrollable div and the table will always fit the page horizontally. Remove it in case you don’t want this.

Example: [watupro-takings quiz_id=5 public=1]

Since version 5.7 WatuPRO supports filters for the watupro-takings shortcode that let you mimic the filtered results from the administration:

orderby – the field which to order by. You can see the possible values from the links in the admin page.

dir – the direction, ASC or DESC

taker_name – the whole name or part of it (depending on the filter parameter below)

taker_name_filter – how to filter on the name. Possible values: contains, starts, ends, equals.

email – the whole email address or part of it (depending on the filter parameter below)

email_filter – how to filter on the email address. Possible values: contains, starts, ends, equals.

company – the value of the optional “Company” field, when presented. Can contain the whole company name or part of it depending on the filter type below. Note that the field does not necessarily contain a company name – you can change the label to ask for any kind of information, but the shortcode parameter remains company.

company_filter – how to filter on this field. Possible values: contains, starts, ends, equals.

phone – the value of the optional “Phone” field, when presented. Can contain the whole company name or part of it depending on the filter type below. Note that the field does not necessarily contain a phone – you can change the label to ask for any kind of information, but the shortcode parameter remains phone.

phone_filter – how to filter on this field. Possible values: contains, starts, ends, equals.

field_1 – the value of the optional custom field 1 when presented. Can contain the whole value or part of it depending on the filter type below.

field_1_filter – how to filter on this field. Possible values: contains, starts, ends, equals.

field_2 – the value of the optional custom field 1 when presented. Can contain the whole value or part of it depending on the filter type below.

field_2_filter – how to filter on this field. Possible values: contains, starts, ends, equals.

role – use it to limit by user role. Can contain only exact value.

ugroup – use it to limit by WatuPRO user group. Can contain a single group ID. Not the name of the group.

ip – the ip of the quiz taker, a whole one or just a part of it depending on the filter type below.

ip_filter – how to filter on this field. Possible values: contains, starts, ends, equals.

points – the number of points collected – exact, less than or more than depending on the filter type below.

points_filter – how to filter on points. Possible values: less, more, equals. For example when points=5 and points_filter=less this will return only results with less than 5 points collected.

percent_correct – the percentage correct answers, from 0 to 100. Can be exact comparison or checking for less or more depending on the filter type below.

percent_correct_filter – how to filter on % correct answers. Possible values: less, more, equals.

percent_points – the percentage from maximum points, from 0 to 100. Can be exact comparison or checking for less or more depending on the filter type below. Available from version 6.6.4.5.

percent_points_filter – how to filter on % from maximum points. Possible values: less, more, equals.

date – the date when the quiz was submitted. Can be exact match or before / after filter depending on the filter type below.

date_filter – how to filter on the date. Possible values: after, before, equals.

grade – the ID of the achieved grade. You can find the IDs on the Manage Grades page for the test.

per_page is attribute specifying how many records to be shown per page (default is 10). Set to -1 to have all records on a single page. Don’t do this if you have more than few hundreds, it will make the page too large and slow.

Here are a few example usages:

watupro-takings quiz_id=1 date="2017-10-01" date_filter="after" grade="124" per_page="50"

[watupro-takings quiz_id=1 email=”@my-company.com” email_filter=”ends”]

[watupro-takings quiz_id=1 points=”5″ points_filter=”more” percent_correct=”50″ perent_correct_filter=”more”]

etc.

Showing or Hiding some Columns:

You can pass shortcode parameters to show or hide most of the columns on this page. By default all columns except user ID (show_user_id) are shown. Set a parameter to 0 to hide the column, skip the parameter or set to 1 to show it. The following parameters are available:

  • show_id
  • show_user_id
  • show_name
  • show_email
  • show_points
  • show_percent
  • show_percent_points
  • show_time
  • show_grade
  • show_contact_data (to show the extra data from “Ask user for contact details” fields)
  • show_delete (for “delete” link when available)
  • show_details (for “view details” link. The parameter will not work in public mode unless you have selected the new option “Allow everyone to see everyone’s details on this quiz” in Edit quiz -> Advanced Settings tab.) Note that if the viewer is not a quiz administrator and not looking at their own results, they will be able to see only the snaphot (not the table view).

Example usage:

[watupro-takings quiz_id=1 points="5" points_filter="more" public=1 show_email=0 show_grade=0 show_percent_points=1]

If you don’t want the details to open in a popup, pass argument details_no_popup=1 to the shortcode.