Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Transaction Patterns » VPD - PopUp (changing IN clause)
VPD - PopUp [message #5799] Wed, 03 August 2016 06:28 Go to previous message
htManager is currently offline  htManager
Messages: 433
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.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Filepicker
Next Topic: PopUp changes Key fields
Goto Forum:
  


Current Time: Thu Nov 21 17:40:52 EST 2024

Total time taken to generate the page: 0.01050 seconds