D2 4.1 setting $DQL based property for ACL not working

Hi,

I am new to D2 and trying an option by setting in the ACL a property as reading group name from a register table

$DQL('SELECT group_name FROM dbo.custo_table where ..') and applying WRITE to the property

The ACL is applied to a context but the DQL is not getting resolved. What could be the reason, am I doing something wrong?

How to troubleshoot such problems?

How to manage dynamic groups for ACLs?

If an acl is applied to a context, if no dynamic feature is used then same ACL is applied to all in the context, i;e; it does not create new Acls based on template. Correct?

And with dynamic, does it 1st search whether such a dynamic ACL exists already and if not then only creates a new?

Regards,

Anurag

Find more posts tagged with

Comments

arnaud_bouyer

Hi,

I experienced the same problem with the previous version of D2. And did not have any answer.

I will be very glad if someone has a correct answer but I'm afraid it is a bug

Regards,

Arnaud BOUYER

paulsun

Have you tried $value(<property>) and $dqlvalue('SELECT group_name FROM dbo.custo_table where ..') .

The other thing to try might be setting up a bunch of conditions, one for each value in the table, if your table isn't too big.

anuragjain

Yes trying that. Do you keep all dictionary keys in lower case? As appending $value from dictionary to the group_name . Whats the best practice?

micfoste_wl

I've had success with $value(<property>) but zero with this $DQL element.

Here's everything I tried.

//Using the repeating value to get the values

$DQL('select user_name from dm_user where UPPER(user_login_name) IN (select UPPER(network_id) from dm_dbo.rgt_roles_peopleactive where position_id IN ($repeatingvalue(approvers_posid)))')
NOTHING

//Dumbing it down and just using value
$DQL('select user_name from dm_user where UPPER(user_login_name) IN (select UPPER(network_id) from dm_dbo.rgt_roles_peopleactive where position_id IN ($value(approvers_posid)))')
NOTHING

//Hard coding my values
$DQL('select user_name from dm_user where UPPER(user_login_name) IN (select UPPER(network_id) from dm_dbo.rgt_roles_peopleactive where position_id IN (''419'', ''4936'', ''450''))')
NOTHING

//Does it work at all? Simplifying the query
$DQL('select user_name from dm_user where user_login_name = 'admin'')
NOTHING

//Trying two single

quotes around the variable
$DQL('select user_name from dm_user where user_login_name = ''admin''')
NOTHING

//Trying double quotes around the variable
$DQL('select user_name from dm_user where user_login_name = "admin"')
NOTHING

//Trying $DQLVALUE instead of $DQL
$DQLVALUE('select user_name from dm_user where user_login_name = 'admin'')
NOTHING

//Removing the single quotes from the outside of the select statement
$DQL(select user_name from dm_user where user_login_name = 'admin')
NOTHING

//Trying a lower case $dql instead of uppercase.
$dql('select user_name from dm_user where user_login_name = 'admin'')
NOTHING

No errors, no results. I can see in the JMS log that it is running the D2UpdateChildACLMethod and by the looks of it quite successfully at is sets new ACLs and cleans up the old. The only issue I might have had was that the job ran before or after I checked and I missed the only one that worked. Seems unlikely though.

PanfilovAB

D2AclConfig expects DQL templates in following format:

$dqlvalue("select bla-bla-bla")

note lowercase "dqlvalue" and double quotes around select statement.

micfoste_wl

Winner!

$dqlvalue("select user_name from dm_user where UPPER(user_login_name) IN (select UPPER(network_id) from dm_dbo.rgt_roles_peopleactive where position_id IN ($value(approvers_posid)))")

Only extra bit of information to add is that you should use $value for getting attribute values and $repeatingvalue doesn't work in this scenario.

I'm guessing you didn't find some updated doco. Did you just decompile a class or two?

vkpandey

Any heads up here!!!

A field with list as a control needs to be updated with values against all of the selected entries in another list, all maintained i n a dictionary. Say a list allows adding countries like india, us, china in it and the dictionary maintains few cities against each of these countries like, India--> delhi,mumbai,chennai ,,,us-> la,nj,ny etc. when the user select india and us in countries list field, the cities added to cities field should be delhi,mumbai,chennai,la,nj,ny

any help here..any other way to achieve this...

thanks in advance