How can I Display layers with definition queries in Collector?

[RichardHughes]

i have 5 feature classes.  6 layers for each feature class in arc map, each with a definition query on the same field named 'Floor'.  The definition queries work in Arc Map and in AGOL inside a web map.  However, when I open the map in Collector the definition queries are not querying the data.  (Floor = 2 for example). What I am left with are 6 layers for each feature class that each display all of the features.

I have tried subtypes, creating feature templates, slightly different syntax on the queries. 

Is this something that Collector just cannot do?

thanks for your assistance,

RPH

[RussRoberts]

Can you share your map and service with Collector4ArcGIS or a map package with a sample of the data and we can look into the issue.

Thanks

Russ

[RichardHughes2]

GeoNet.mpk - Google Drive

Hi Russell, I've started thinking that the only way to do this is to add the query to the service after it has been created.

Is the definition query incorrect for the Collector on iPad Air database, SQLite?

The link at the top is a link to a map package and service definition file.

Thanks!

Richard

[RussRoberts]

Just taking a quick look at the map and your layers are all referencing the same data source in the gdb. This is currently not supported in offline and could cause some sync issues.

[RichardHughes2]

Hi Russell,

Thank you very much for your timely responses to my posts.  This information is a key part of a workflow I am designing for the Charlotte Douglas Airport as they are starting an asset verification project.

Thanks,

Richard Hughes | GIS Applications Specialist

.

[CarlosSilva6]

Hi Richard

Did you have any luck with this line of inquiry? We here at the Vancouver International Airport are interested in using Collector for POIs on each floor of the terminal but I haven't seen any good examples of using Collector for this sort of thing.

Cheers

Carlos Silva

GIS Specialist, YVR

[RichardHughes2]

Carlos,

We worked around the issue that Collector cannot support multiple layers with definition queries.  That was a year ago so I don't know what the best current workflow would be given the updates to the Collector App.  The way I worked around the issue was by writing a python script that split each feature class into floors in a new geodatabase and added them to the map then imported the symbology from the original layer.  I created a feature dataset for each floor. 

[CarlosSilva6]

Good to know thanks! I'll follow up with ESRI Canada as well and see what they say.

I have Geocortex Essentials available to me as well so i could create a specific app there instead. Shame we can use a def query for datasets in Collector.

Cheers

Carlos