VPD - PopUp [message #5799] |
Wed, 03 August 2016 06:28 |
htManager
Messages: 431 Registered: May 2014
|
Senior Member |
|
|
Hi Tony,
is it possible to see in a popup screen more than the allowed records as defined in the IN clause of the generated SQL query ('1', 'x')?
The system with VPD works fine but I want to release records from other account 'channels'.
I have a table where I can release the channel for other VPD accounts with the following structure:
channel_id (pk), account_id (pk), release start, ... where account_id is the system rdcaccount_id.
The popup should include the records from channel_id. I tried to change the SQL query in the (popup1).php but I didn't succeed because of the automatic generated IN clause which only allows shared accounts and the logged in account.
The 'channel' contains records which I want to release for a certain time.
|
|
|
Re: VPD - PopUp [message #5800 is a reply to message #5799] |
Thu, 04 August 2016 04:55 |
AJM
Messages: 2363 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
I do not understand what you want to do. When you are using the rdcaccount_id facility the rules are quite clear:
1) Any entry with rdcaccount_id=1 is shared and can be viewed (but not updated) by a user whose rdcaccount_id>1
2) Any entry with rdcaccount_id>1 is private to that account and can only be viewed/modified by users in that account.
It is not possible to make accounts other than #1 sharable.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Re: VPD - PopUp [message #5803 is a reply to message #5801] |
Fri, 05 August 2016 04:28 |
AJM
Messages: 2363 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
Only account #1 is sharable among other account holders. Anything with an account > 1 can only be viewed and used by members of that account. To change this would open up a huge can of worms, so it will never happen. To make something sharable you add it to account #1.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Re: VPD - PopUp [message #5810 is a reply to message #5808] |
Fri, 05 August 2016 09:36 |
AJM
Messages: 2363 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
I have already told you that if you want records with rdcaccount_id > 1 to become sharable among other accounts then the only way to achieve it is to set their rdcaccount_id's to 1. If you attempt any other mechanism it will be unsupported.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Re: VPD - PopUp [message #5823 is a reply to message #5821] |
Sat, 13 August 2016 05:27 |
AJM
Messages: 2363 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
You are bending the system to work outside of its design parameters, which is never a good thing. If you want to take set on "unshared" records and make them "shared" then you should implement a mechanism to copy them to the "shared" account. This would NOT require any changes to any framework code and therefore would not cause unexpected problems down the line.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
|