Dataform (plugin)

How to present only few selected records from the database to different users?

 
Picture of Rafał Soin
How to present only few selected records from the database to different users?
Rafał Soin
Wednesday, 7 March 2018, 12:50 PM
 

Hi Itamar,


I need to utilize a Dataform module to present only selected records from the database to different users.

Logged-in user should not see records not designated to him.

I tried to assign dedicated filters to users, but without success.

What I am doing wrong?

Is it possible to permanently assign a filter to any user?


Moodle 3.3.4

Dataform 3.3.2


Can you help me?

Rafal

 
Average of ratings: -
Permalink | Reply
Picture of Alex Sandu
Re: How to present only few selected records from the database to different users?
Alex Sandu
Thursday, 29 March 2018, 6:39 PM
 
I created you a "preset" to load it into the dataform activity.
You'll find two views: MANAGER and Student.
The MANAGER can add / delete / edit any record; the Student can only read.
The recordings are added into MANAGER after the students are enrolled.
 
Moodle backup Dataform-dataform-preset-20180329_1012-without-user-data.mbz
Average of ratings: -
Permalink | Show parent | Reply
Picture of Van Romine
Re: How to present only few selected records from the database to different users?
Van Romine
Tuesday, 11 September 2018, 7:04 AM
 

In August 2018, I asked the following question.... is it similar to your situation?

===================================================

Let's say I have 100 entries in a Dataform that has a field (named MYTYPE) that I want to use as a "dynamic filter". For example:

  1. I want to display a dropdown consisting of the UNIQUE values of the field named MYTYPE.
  2. When the user chooses one of the dropdown options, I want a filter to be applied that shows only the entries where the field MYTYPE contains the value selected by the user. 
By the way, I don't know the possible values of the field MYTYPE, because the user enters the values themselves.

Can this be done?.... 

===================================================

I never got an answer, but I am hoping you and I might be able to combine our efforts for a solution.

 
Average of ratings: -
Permalink | Show parent | Reply
Picture of Van Romine
Re: How to present only few selected records from the database to different users?
Van Romine
Tuesday, 11 September 2018, 8:00 AM
 

I stumbled upon the answer:

I can create the SQL query that tells me which entry id#'s match my criteria. All I have to do is build the url.

 
Average of ratings: -
Permalink | Show parent | Reply