i_all_users_names

Deepak27

I am facing below problem

when i query this

select i_all_ users_names from dm_group

I get the all the users belonging to that group

But when i query this

select i_all_users_names from dm_group_r

I get the blank rows

Does any one having an idea of this, i need the 2nd query as i need to run it in SQL server

Regards,

Deepak

Find more posts tagged with

Comments

lastnitescurry

run the first query in DA and click checkbox to show SQL

Deepak27

ok,

But why its behaving this way,

if i query for i_supergroups_names as the same way, I get the required results

Miller-zzMST

Hi,

Try this:

SELECT DISTINCT users_names FROM dm_group_r WHERE users_names<>' '

With space or not between single quotes - it depend of database, in case if you have Oracle use with space, in case of MS SQL use without. About other DB I have no information.

~ Konstantin

Deepak27

Hi Konstantin,

Thanks for the reply,First i want to execute it through DQL

and i am not getting any result when i query like this

select i_all_users_name from dm_group_r,

while when i use select i_all_users from dm_group, i get all the results,

what is the problem with above query?

lastnitescurry

But why its behaving this way,

no idea, raise a support ticket and ask EMC Engineering

Miller-zzMST

Attribute i_all_users_names is computed column table.

Attribute users_names contains the users names directly contained in groups.

Deepak,

Did you tested the query proposed in my previous post? I've run it in my environment - it is returned the same result as the first query from your first post.

~ Konstantin

Deepak27

Hi Konstantine,

Yes your query runs fine as i am querying on dm_group but as soon as i put where clause, it may give different results depends on the nested group users

Regards,

Deepak