I have a simple user profile username, password and email
I have a table with details of books - I have used an element "entered by" of type user to successfully prefilter on enteredby(raw) to just view books that a specific user entered in to the database using {$my->id}
I have another element "owner" where I have done a databasejoin using "value = id(recommended)" from the profiles table. This gives allows the book owner to be a member of the system. I can see valid users under owner column (& see their id when I set label=id)
I want to create a view to show only books that the user owns. So I tried owner(raw) equals {$my->id} text registered users BUT I get an empty list. If I change the restriction to be all users then I get a populated list but it shows all books
I am a complete newbie to Fabrik - all help appreciated.
Thanks
I have a table with details of books - I have used an element "entered by" of type user to successfully prefilter on enteredby(raw) to just view books that a specific user entered in to the database using {$my->id}
I have another element "owner" where I have done a databasejoin using "value = id(recommended)" from the profiles table. This gives allows the book owner to be a member of the system. I can see valid users under owner column (& see their id when I set label=id)
I want to create a view to show only books that the user owns. So I tried owner(raw) equals {$my->id} text registered users BUT I get an empty list. If I change the restriction to be all users then I get a populated list but it shows all books
I am a complete newbie to Fabrik - all help appreciated.
Thanks