Hello i am using views 7.x-3.2 and the References module. -user reference-
I am trying to create a page for users on the site that will list their appointments. Added by themselves or another role -receptionist-
I initially tried to do this by content author but i realized their was no good way to fake the author.
So the better way would be to make a user reference field and let the receptionist select the user from a list. also the user would be forced to select from the same list.
As I cannot let them see other users names etc. I tried making a new content type that uses the same field but a different references view. this didn't work because it is a global setting for all content types with that field.
So I backed up a little and thought what if i could have a unique field.
Then i would encounter the exact same issue that i am presently faced with.
The contextual filter excludes all types without that particular field. And And vs And OR
the regular filter is static.
I have created a view with a page that is called my appointments and it is using a contextual filter that is filtering by the logged in user, for the user reference field.
contextual filter: Content: Patient Name (field_patientselect)
I have tried using one content type -appointment- but there is no way to limit the user reference list despite the users permission to view there profile or even field. when i limited there field permission it returned rows of users without the fields they were not supposed to see. but they got the whole list of users as blank lines they could still select.
So i though two content types, with the same field. the same field because couldn't have the -my appointments- view contextual filter, the And And vs And OR thing again.
one more idea i had was to have two views one that limits by logged in user and the other a list of all. as i couldn't use multiple views references for one field -global- i tried the no results behavior to pull up the all users view when the logged in user view failed.
this had a multitude of issues ie. they are both logged so there is always a result. so i did the same no results backwards where there would be no result. but i still got an empty list -maybe due to it being a references view?-
I have looked around for days,
http://drupal.org/project/nodeaccess_userreference this looks similar but is not
http://drupal.org/project/entityreference This is supposed to be better but it would just be trowing a new mod in when i am trying to limit the views reference by permission
Question: Can i use contextual filters in the same AND/OR way as the regular filter. -ideal-
Question: do i just not know how to use multiple contextual filters together and maybe the no results behavior
Question: Am i just missing a better way of doing this whole appointment scheduling thing? -not a views issue-
At the end of the day i am hoping someone can point me in the right direction, and every way i can think of requires contextual filters to have And/Or
Thanks in advance!