Dropdown dynamic menu

User profile fields ::: profilefield_dynamicmenu
Maintained by Antonello Moro
Dynamic menu user profile field for moodle Now users can create user menu fields whose values are retrieved from the moodle DB.
Latest release:
85 sites
57 downloads
15 fans
Current versions available: 2
Dynamic menu user profile field for moodle. Now users can create user menu fields whose values are retrieved from the moodle DB. Basically, the user can set a sql query as value definition of the field. Please note that the query *must* return two fields: id and data. Please note that this is an advanced plugin, mainly intended for developers and very advanced moodle users. You must know moodle DB and sql language to use this plugin properly.

Screenshots

Screenshot #0
Screenshot #1

Contributors

Antonello Moro (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Vis kommentarer
  • Dan Marsden
    tir., 3 mai 2016, 05:56
    Thanks for tidying up those issues Antonello, I still think it would be nice if you could expand your description here a little bit more to explain the different use-cases (to help encourage more people to try out your plugin) but I think the plugin code is ready for approval - we'll just wait for the Moodle HQ team to make the final decision on approval.
  • Antonello Moro
    ons., 4 mai 2016, 18:11
    ok thanks Dan. In the meantime I'll think about some use-cases to expand the description
  • David Mudrák
    man., 9 mai 2016, 17:01

    Thanks Antonello for sharing the plugin with the Moodle community, and thanks Dan for the detailed peer-review. I am happy to approve the plugin now. You are cleared to land, welcome to the Plugins directory!

  • Antonello Moro
    man., 9 mai 2016, 17:24
    Thanks guys!
  • eli chan
    fre., 7 okt. 2016, 10:28
    Very useful plugin after installation and work prefectly, but new course cannot add activity due to "Error reading from database".
  • Ibrahim Fadl
    ons., 7 des. 2016, 19:14
    I am new to moodle, how to select all moodle users email addresses to this dynamic menu
  • Saaid Agherdien
    lør., 31 des. 2016, 18:15
    Hi eli chan, I had the same issue with the dynamic multi select profile field. That is, it worked fine until I deleted a user that used the multi select to update his profile. After this I could not add activities to courses as I would get "error reading from database". I think that when I deleted the user, it did not clean up the database. To solve the problem I deleted the multi select field I created. I can now add activities to any course.
  • Antonello Moro
    søn., 12 feb. 2017, 23:25
    Hi folks, those issue should be fixed in the new version 1.1.0
  • Valentino Santucci
    fre., 28 jul. 2017, 05:45
    Hi, it does not work in the signup page (no option), while it is ok in the user profile page. Am I doing something wrong?
  • John Anderson
    tor., 14 sep. 2017, 00:18
    Hi, I have a question /idea about use case. I am facing a requirement to report on what sorts of learners, by license, credential, or age that completed course X. I don't have these fields in my moodle and was struggling to devise a plan to do this. I was thinking about using a feedback activity to collect this at the start of the course. Then use configurable reports to query out the data. But wondering if this might be used to store my feedback activity data into some profile fields?

    Any ideas welcome - interesting module !
  • Muneera AlNufaisi
    lør., 21 jul. 2018, 04:08
    is better if I can write full query that get form database rather than currnt way
  • David Collins
    tor., 23 aug. 2018, 22:36
    I am having the same issue as Valentino. Looking over your code, in the constructor for the field, you have a parameter for userID, which is null/empty from the sign-up page, so it never hits the code path to populate the dropdown.
  • foto_frank
    ons., 2 jan. 2019, 03:37
    Hi, thanks for sharing. How do I uninstall it?
  • Federico Bini
    man., 9 mar. 2020, 18:59
    Hi Antonello! Your plugin is very useful and would do exactly what I need .. unfortunately it only does for "user" custom fields, it would be possible to have a version also for the custom fields that are used under the course or better yet to be used in multiple contexts (in so that they can also be used for the individual activities of a course)?
  • Hay B
    tir., 30 aug. 2022, 22:59
    Hi,
    Thanks for the plugin! It seems to be working on Moodle 4.0 but I am unable to pull info from the database for current user using %%USERID%%. I get
    Error executing the query: Error reading from database. I have tested the query directly in moodle database and in Ad Hoc queries plugin and it works as expected there. Any help appreciated.
1 2
Please login to post comments