How to create a view layer of a non hosted (i.e. Federated) feature layer in Portal

[GISNCC]

Hi,

I have published a featureclass (as a feature layer and map image service) to Enterprise. It is coming from our federated SDE database.   I want to create a view layer of this published layer to filter it and then share this filtered view to our ArcGIS Online instance.   

As the published layer is a feature layer (rather than a hosted feature layer) there is no option to create a view layer in Portal or ArcGIS Online. 

What is the best way to get around this.

I want to publish all the attributes to portal as some users need to see all the data and edit it.  However the shared version to our ArcGIS Online should only include a filtered version. 

I guess I could publish it twice (one filtered, one not) but is there another way?

Thanks very much

[Scott_Tansley · Accepted solution]

Hey, if it's not hosted, then the method is to create a copy of your aprx/mapx document.  Use layer properties to set the 'view' that you want and then you publish a second Map Image Layer.  Then in portal you set the appropriate security to each MIL.

Hope this helps.

S

[GISNCC]

Thanks very much Scott for your quick response.  Cool. Good to know there isn't some trick I am missing and I will publish it a second time with a filtered view of the data. 

Thanks,
Karyn

[Scott_Tansley · Accepted solution]

My pleasure, I wish there was a better way - but this is it.  Note that Marcelo has added some valuable comments, and it can be done in those ways as well, but it's still publishing an additional service for each view.

[MarceloMarques]

@GISNCC 
You can create a database view or use query layers then publish a new feature service or map service.

Create Database View (Data Management)—ArcGIS Pro | Documentation

Query layers—ArcGIS Pro | Documentation

If you edit an existing mapping document to filter out the data based on some fields then make sure those fields have indexes to improve performance of the SQL query in the database, same applies if you use a database view or Pro Query Layers. It is also important to rebuild indexes often and gather new statistics.