Query Builder

[Edie0802]

Is it possible to use the Query Builder to get a list of all Universes that have a connection in which the connection is owned by a certain user? I do not care who owns the universe, just the connection.

I can already get a list of universes. I can already get a list of connections that are owned by a particular user. For example,

Select si_id, si_name,si_kind,si_owner from ci_appobjects
where si_kind = 'MetaData.DataConnection' AND si_owner =
'InsertNameOfOwnerHere'

Version: XIR3
Platform: Linux

Thanks.

 

[hilfy]

Unfortunately, Query Builder is meant for running simple queries, so there is no way to do this using a complex query to return both types of data. However, you CAN write a query that returns the universes that use a specific connection by using the SI_ID of of the connection. Here's what it looks like:

Select *
from CI_APPOBJECTS
where SI_DATACONNECTION like '%6129%'

So, you could get your list of connections that belong to a specific user and then run this query using the SI_ID of each of them to get the universes that use each connection.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.