I would like to populate a list of connected students. I've set up a Query Drop Down Single select, the query works for all students. But I cannot find any documentation or forum posts as to how to limit this list to only students that I'm connected to. In an ideal world, I would expect to see a table of connections on the db, mapping two users together if they were connected and then I could add that to the where clause. I assume I can use delimiters but cannot find anything specific enough.
We do not provide documentation for database structures. In regards to connections they are stored in _comprofiler_members. The user making the connection is stored in referenceid column and the user being connected to is stored in memberid column. The accepted column notes if the connection was accepted and the pending column notes if the connection is still pending.
Another issue I have, which is totally related...the selected item on the student drop down should filter out the rows in the field group. So, the field group is called Sessions, and a teacher can look at dates and times of a particular student they are connected to. I've enabled search on the student field and on the field group, sessions. But I get no search display.
Not sure I understand what you mean. The dropdown is empty? What is the query you're using exactly.
What I do get on the admin back end is a warning that MySQL might need to be upgraded. I've contacted my hosters and they say they're using the latest build of MariaDB. Are these compatible? If so, why am I getting the warning and no search fields?
MariaDB is not supported officially by Joomla or by CB; it only works by luck since it's a fork of MySQL. I've no idea what warning you're referring to so you'll have to provide the warning.
krileon
