DQL to display folder path, document name, audit user name, group name

blessbk

Hi,

I am forming a dql query to display a document's folder path, its name, audited user's name and its user group name.

If you look at the following dql, you can understand it. Basically, i have joined auditrail, document, folder, users and group objects to get changes done on documents

Select d.r_object_id, f.r_folder_path,  a.object_name, u.user_name, g.group_name from dm_audittrail a, dm_user u, dm_group g, dm_document d, dm_folder f where a.user_id=u.r_object_id and any g.users_names=u.user_name and a.object_type='dm_document' and d.r_object_id = a.audited_obj_id and d.i_folder_id = f.r_object_id  and f.r_folder_path is not nullstring

When i execute this query, i am getting an error message as shown below

query execution :[DM_QUERY_E_REPEATING_USED]error: "You have specified a repeating attribute (r_folder_path) where it is not allowed." 

Could you please tell me how can i specify r_folder_path in this dql.

Thanks in advance

With regards

blessing

Wiesnoepersad

Please look to your where clause: i_folder_id and r_folder_path are also repeating attributes. So you need to do where any i_folder_id...etc

See also select:

Select d.r_object_id, f.r_folder_path as loc, a.object_name, u.user_name, g.group_name
from dm_audittrail a, dm_user u, dm_group g, dm_document d, dm_folder f
where a.user_id=u.r_object_id
and any g.users_names=u.user_name
and a.object_type='dm_document'
and d.r_object_id = a.audited_obj_id
and any d.i_folder_id = f.r_object_id 
and any f.r_folder_path is not nullstring
ENABLE (RETURN_TOP 10)