How to add filter by Custom User Profile Field (Moodle)

Custom user profile fields data listed in Builder in respective table categories

mceclip0.png

In order to create and add a filter by custom profile field respective calculation needs to be created first.

HOW TO CREATE A CALCULATION

  • Navigate to the Calculations tab in builder mode and hit "Add New".
    mceclip1.png

  • Specify the name of your field, description, and choose the category(table) from drop-down in which you would like to place your field. Typically we put this in Users table as this is user-related data.
    mceclip2.png
  • In the next step pick "User Profile Data Data" data point.
    mceclip5.png 
  • Hit Next then.
    mceclip4.png
  • Keep only the top five toggles on in the next step.
    mceclip6.png
  • Hit "+" to create a filter in the next step.
    mceclip7.png
  • Pick "User Profile Field Shortname" data point.
    mceclip9.png

  • Choose "Hidden" in the next step.
    mceclip10.png
  • Select "Equals" as the operator.
    mceclip11.png

  • Use User Profile Field Short name for  "Filter Value".

    mceclip12.png
    NOTE: CUPF field name can be found in your Moodle LMS under:
    Dashboard > Site administration > UsersAccounts >User profile fields > Editing profile field: Company
    mceclip13.png
  • Hit "Apply Filter" then and hit Next after that.
    mceclip15.png

    mceclip16.png
  • Hit "Create" on the final step.
    mceclip17.png
  • Go back to Layout tab and hit "Add Field".
    mceclip20.png

  • From Users category pick a field you just created.
    mceclip21.png
  • Pick either Calculation as a copy or Calculation as a link.
    mceclip22.png
    NOTE: Calculation as a copy means that you add this as a copy to your report. If any changes are made to the Calculation you created in your report it remains unchanged. Calculation as a link means that if any changes are made to the calculation it will be changed in your report as well.

  • Once you have your calculation added as a column you can switch to Filters tab and add new filter.
    mceclip23.png
  • Pick the same field from Users category.
    mceclip24.png

  • Choose either Calculation as a copy or Calculation as a link and then hit "Skip".
    mceclip25.png
  • Pick "Select" type in the next step (which refers to visual filter).
    mceclip26.png
  • Hit "Apply" in the final step.
    mceclip27.png

    CONGRATULATIONS! You have added the filter.
    It is now available in the table filter area.
    mceclip28.png
    NOTE: You can create a calculation for each Custom User Profile Field available in your LMS by following the steps described above. You can filter by different fields to the same report as well.

    For additional assistance please email us at HelpDesk@intelliBoard.net

Was this article helpful?
0 out of 0 found this helpful