DQL Problem

deveshsumeet
deveshsumeet
edited October 3, 2008 in Documentum #1

Hi,

I am currently using below mentioned query as value assistance query in one of the attribute of an object:

select distinct locale_assist from dm_dbo. valueAssistForLocaleGeoVertical where geo_assist in ( select geo_assist from dm_dbo. valueAssistForLocaleGeoVertical where group_name_assist in (select group_name from dm_group where dm_group.r_object_id in (select r_object_id from dm_group_r where users_names=$owner_name) ) )

I have created a register table : valueAssistForLocaleGeoVertical

with following columns : locale , geo, vertical and group

what i want that a locale value can be populated while creating a content by using this query ( using owner name ---> groups of that owner -> than geo from above table-> locale using this geo from above table)

This query is working fine when i am putting an owner name and running in DA or WP DQL Editor, but not through value assistance query of DAB.

May be query is not picking "owner_name".

Please help me to solve this problem.

Thanks in advance

Devesh

Comments

  • deveshsumeet
    deveshsumeet
    edited October 3, 2008 #2

    i have got d answer :

    the correct query is

    select distinct locale_assist from dm_dbo. valueAssistForLocaleGeoVertical where geo_assist in ( select geo_assist from dm_dbo. valueAssistForLocaleGeoVertical where group_name_assist in (select group_name from dm_group where dm_group.r_object_id in (select r_object_id from dm_group_r where users_names='$value(owner_name)') ) )

Categories