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; } } }

Filter Catalog EGDB FCs by owner

Bud

In Catalog:

It would be helpful if we could filter/show/hide enterprise geodatabase connection items (FCs, tables, views, relationship classes) by owner.

For example, if there are items from several owners (ROADS, WATER_RES, WATER), let me only see items from WATER.

My connection is OS Authentication (items from lots of owners), not a DB/owner-based connection (only one owner).

Oracle 10.7.1 EGDB

Vind meer berichten getagd met

Content Management

Status: Openen

Reacties

ShawnThorne

Hi Bud,

If you are using ArcGIS Desktop, you can accomplish this by going to Customize > ArcCatalog options... > check the "List only objects owned by the connecting user with enterprise geodatabases" checkbox.

For ArcGIS Pro, this option will be available with the upcoming release of version 3.1.

Hope this helps,

-Shawn

SSWoodward

Thank you for the idea!

In ArcGIS Pro 3.1, users will have the ability to see only objects owner by the connected database user. This option will be available in the Catalog Browsing page of the application options dialog. For more on this, and for other new additions from the geodatabase team in 3.1, check out our latest blog.

Link - What's new with Geodatabases in 3.1

AmeliaBradshaw

This Idea has been implemented in ArcGIS Pro 3.1. Please see the What's New documentation for more new features in Pro 3.1.

The Ideas in ArcGIS Pro 3.1 blog will be wrapped up soon, highlighting all Ideas implemented in this release, including this one. Once complete, I will add the link to this comment.

EmmaVWKnowles

Hi, I think this is asking to be able to filter other people's data by owner? Not just view our own.
For example, all data published by Natural England.

SSWoodward

Thanks for pointing this out. It looks like that's correct. Seems like this idea might need an amended status. While it IS true that users have new filtering functionality that matches ArcMap, this idea goes a step further.

@Bud , @EmmaVWKnowles

Where would you expect to find this functionality in the catalog? There is an existing filter option at the top of the catalog pane that allows you to filter by multiple criteria, but not ownership. Would you expect to find it here? Or somewhere else like a right-click option on a specific workspace?

EmmaVWKnowles

Hi @SSWoodward, thanks for following up on this. I was looking for a "filter by owner" option in the dropdown list for the filter criteria box at the top of the catalog pane, as you say, so that is indeed where I would expect to find it.

I did subsequently discover that it is possible to filter by owner by typing "owner:" and then the owner's name. However, this is not obvious, I had to look it up; and also you have to get the username for the data owner exactly right, (for example, NE_opendata instead of Natural England), so a search box that can filter organisation names and tags would be more intuitive.

Bud

@SSWoodward

Agree with @EmmaVWKnowles. I think this idea needs to be re-opened. Thanks.

Bud

@SSWoodward Can this idea be reopened?

MelissaJarman

@Bud - After re-reading this I believe there was a misundertanding of the larger scope of this request.

It was read as - I only want to see the datasets owned by the 'current' connected user in my database connection. You actually want a way to filter based on a user provided owner (this could be different than the current connected user even).

Do you want the filtering done based on the actual owner or the schema (because this can differ).

Bud

@MelissaJarman I wasn't aware that the owner and schema could be different. Can you explain?

For Oracle EGDBs, I want to filter based on the item prefix. I’m not sure if you would consider the prefix to be the owner or the schema.

SSWoodward

Thank you very much to everyone involved in this Idea.

In ArcGIS Pro 3.1, the ability to filter the catalog for items owned by the connected user was implemented, making finding your own data in the catalog pane easier.

Since this idea is asking for a more specific feature, the ability to filter the connection by *any* owner, we will reopen it for support from the community. @EmmaVWKnowles, feel free to give this Idea a kudo now that its reopened.

Doe mee aan het gesprek

Meld je aan om te posten, content te volgen en meer. Nieuw hier? Registreer gratis.