How to get value assistance DQL statement?
Mostly this is a reminder for myself whenever I need to look at this again. I have wondered about this for a while, seeing as I hate duplicating configurations. There is a question at end if someone would like to do a bit of work for me please
Assuming I have configured the following DQL as the value assistance for an attribute.
SELECT group_name, description FROM dm_group WHERE group_name IN (SELECT groups_names FROM dm_group WHERE group_name = 'ucl_rs_fis_share_all_depts') ORDER BY 2
How can I get this DQL in code? Is there a simple query for me to use, which would be ideal?
By the power of a internet search engine and I found the following but this does not work on my 6.6. Developer Edition
select query_attribute, query_string from dm_value_query where r_object_id = (select default_id from dm_cond_id_expr where r_object_id in (select cond_value_assist from dmi_dd_attr_info where type_name='<objtype>' and attr_name='<attribute>'))
But the following does work, which I figured out from Object Reference
SELECT DISTINCT query_attribute, query_string FROM dm_value_query WHERE parent_id = ( SELECT r_object_id FROM dm_aggr_domain WHERE type_name ='xyz_folder' AND ANY attr_name ='abc_brian')
and got some validation for, from this conversation
but can not get access to this link
I guess if I had access to that resolution then I would not be wondering why the 2nd DQL works.
Still guessing, I assume the first DQL is valid pre version 6x. Anyone feel like checking for me?