topic Re: Obtaining Featureclass names From SDE file path for adding to map in .net SDK in ArcGIS Pro SDK Questions

Obtaining Featureclass names From SDE file path for adding to map in .net SDK

SumitMishra_016 — Wed, 06 Mar 2024 06:28:17 GMT

how can I filter the following featureNameslist in the geodatabase created using Oracle SDE which don't have access to user:

Geodatabase geodatabase = new Geodatabase(new DatabaseConnectionFile(new Uri("path to sde")));

var featureNameslist = geodatabase.GetDefinitions<FeatureClassDefinition>().Select(def => def.GetName()).ToArray();

Just like in the catalog

Re: Obtaining Featureclass names From SDE file path for adding to map in .net SDK

Aashis — Wed, 06 Mar 2024 22:57:43 GMT

The following should work. Could you pls try?

The SQLSyntax parses the fully qualified dataset name to the db, owner, and dataset names.

IReadOnlyList<FeatureClassDefinition> featureClassDefinitions = geodatabase.GetDefinitions<FeatureClassDefinition>(); List<FeatureClassDefinition> filteredDefinitions = featureClassDefinitions.Where(def => { SQLSyntax sqlSyntax = geodatabase.GetSQLSyntax(); (string dbName, string ownerName, string tableName) = sqlSyntax.ParseTableName(def.GetName()); return ownerName == "your_owner_name"; }).ToList();

Re: Obtaining Featureclass names From SDE file path for adding to map in .net SDK

SumitMishra_016 — Thu, 07 Mar 2024 06:54:02 GMT

Thanks @Aashis for the reply,

The purpose to list feature classes from SDE is to add selected feature class to map. There are multiple owners in the sde, how will I know that which owner has access to the connected user of the SDE? Just like Catalog shows the accessible list of enterprise feature classes.

IReadOnlyList<FeatureClassDefinition> featureClassDefinitions = geodatabase.GetDefinitions<FeatureClassDefinition>(); List<string> allOwnerNames = featureClassDefinitions.Select(def => { SQLSyntax sqlSyntax = geodatabase.GetSQLSyntax(); (string dbName, string ownerName, string tableName) = sqlSyntax.ParseTableName(def.GetName()); return ownerName; }).ToList(); List<string> distinctOwnerNames = allOwnerNames.Distinct().ToList();

Re: Obtaining Featureclass names From SDE file path for adding to map in .net SDK

SumitMishra_016 — Thu, 07 Mar 2024 10:54:15 GMT

Hi @Aashis,

how will I know that which owner has access to the connected user of the SDE?

Re: Obtaining Featureclass names From SDE file path for adding to map in .net SDK

Aashis — Thu, 07 Mar 2024 14:50:47 GMT

I am presuming that you are trying to find the connected user.

DatabaseConnectionProperties connectionProperties= geodatabase.GetConnector() as DatabaseConnectionProperties; string user = connectionProperties.User;

DatabaseConnectionProperties

Re: Obtaining Featureclass names From SDE file path for adding to map in .net SDK

SumitMishra_016 — Thu, 07 Mar 2024 17:22:34 GMT

Hi @Aashis,

Thanks for the reply. But the user and owner are not same. Any user can have access to multiple owners.

In Catalog, it is filtered correctly, do you know any way to filter that?

Re: Obtaining Featureclass names From SDE file path for adding to map in .net SDK

Aashis — Mon, 11 Mar 2024 14:34:26 GMT

In ArcGIS, user accounts determine who owns what data. User accounts also provide a way to control what type of access a person or client application has to a database or geodatabase and its datasets. ArcGIS generally recommends that the owner and schema have matching names.

The Catalog UI does the following -

// Get the currently logged user DatabaseConnectionProperties connectionProperties= geodatabase.GetConnector() as DatabaseConnectionProperties; string user = connectionProperties.User; // Filter feature classes based on the user IReadOnlyList<FeatureClassDefinition> featureClassDefinitions = geodatabase.GetDefinitions<FeatureClassDefinition>(); List<FeatureClassDefinition> filteredDefinitions = featureClassDefinitions.Where(def => { SQLSyntax sqlSyntax = geodatabase.GetSQLSyntax(); (string dbName, string ownerName, string tableName) = sqlSyntax.ParseTableName(def.GetName()); return ownerName == user; }).ToList();

If you find something else, please log a bug from tech support for further investigation.

Re: Obtaining Featureclass names From SDE file path for adding to map in .net SDK

SumitMishra_016 — Mon, 11 Mar 2024 11:14:26 GMT

Hi @Aashis,

Thanks for the reply,

User accounts may have access to different owner's table which may not be owned by the user. In that case how to filter out only those tables from the below featureClassDefinitions:

IReadOnlyList<FeatureClassDefinition> featureClassDefinitions = geodatabase.GetDefinitions<FeatureClassDefinition>();

The Catalog UI displays only accessible feature classes with or without List only object owned by connecting user checkbox.