nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DQL Queries Help

dctmpriya

Hai All ,

I want the below DQL Queries

1) Query to get the user belong to which group.

2) Query to get the current version document using i_chronicle_id.

Regards

Priya

Find more posts tagged with

Comments

Viswa

1) Query to get the user belong to which group.

select group_name from dm_group where any i_all_users_names = 'dmadmin'

Your second question is clear to me. Are you trying to get a latest version of a document?

A regular DQL statement will always return a lastest document only.

aflowers001

1. select i_all_users_names from dm_group where group_name='<insert value here>' or select users_names from dm_group where group_name='<insert value here>'

Take a look at the object reference manual for dm_group for the difference in the requested data

2. select r_object_id from dm_document where i_chronicle_id='<value here>'

Queries will return the latest version by default

dctmpriya

Thanks Andy