Radicore Forum: Transaction Patterns » VPD

Home » RADICORE development » Transaction Patterns » VPD - PopUp (changing IN clause)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: VPD - PopUp [message #5801 is a reply to message #5800]

Thu, 04 August 2016 09:12

htManager
Messages: 456
Registered: May 2014

Senior Member

I know that only accounts with #1 are sharable. But I want the account owner to temporarily (start date, end date) grant access (view rights only) to an account > 1. This account functions as a 'lookup' account. So data has to be stored only once.

I read your article about Virtual private database and how you described in #5 how you altered the code for reading from the database:

else {
// read the user's account and the shared account
$account_id_string = "$this->tablename.rdcaccount_id IN ('1', '$account_id')";
}

My problem would be solved if there would be a possibility to select records from more than one account > 1.

i.e.: if ($pattern_id = 'popup'){
$account_id_string = "$this->tablename.rdcaccount_id IN ('1', '$account_id', '$account_id_additional'')";
}

where $account_id_additional would be some other selected accounts like ('8', '15', 'nnn')

The account owner can grant these (reading) access rights via a table. It would then be possible with a popup to choose data from that account.

Report message to a moderator

[Message index]

		VPD - PopUp By: htManager on Wed, 03 August 2016 06:28
		Re: VPD - PopUp By: AJM on Thu, 04 August 2016 04:55
		Re: VPD - PopUp By: htManager on Thu, 04 August 2016 09:12
		Re: VPD - PopUp By: AJM on Fri, 05 August 2016 04:28
		Re: VPD - PopUp By: htManager on Fri, 05 August 2016 06:19
		Re: VPD - PopUp By: AJM on Fri, 05 August 2016 09:36
		Re: VPD - PopUp By: htManager on Fri, 12 August 2016 10:48
		Re: VPD - PopUp By: AJM on Sat, 13 August 2016 05:27
		Re: VPD - PopUp By: htManager on Sat, 13 August 2016 06:31
		Re: VPD - PopUp By: AJM on Sun, 14 August 2016 12:31

Previous Topic:	Filepicker
Next Topic:	PopUp changes Key fields

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun May 03 04:03:55 EDT 2026

Total time taken to generate the page: 0.01139 seconds