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

ArcGIS Online Layer-Abfrage

ChrisKemmerer

<\/HEAD>

Ich habe einen gehosteten FeatureLayer in einer Webkarte, der mehrere Features für Datensammlungen enthält, die in mehreren Projekten verwendet werden sollen. Ich möchte in der Lage sein, Daten und Anhänge aus diesen Layern mithilfe einer Layer-Abfrage im create replica wizard herunterzuladen. Für dieses Beispiel habe ich die Layer 0-3, alle Layer haben ein gemeinsames Attribut, "Project_Number". Ich möchte etwas Ähnliches wie im folgenden Beispiel machen. Bisher habe ich die erste Zeile getestet, während sie eine URL zum Herunterladen der Daten erzeugt, schlägt die Replikat-Erstellung fehl. Leider wird keine Fehlernummer angegeben, nur dass es fehlgeschlagen ist. Jede Einsicht wäre sehr willkommen.<\/P>

<\/P>

BEISPIEL:<\/P>

{"0":{"where":"Project_Number=842"}}
{"1":{"where":"Project_Number=842"}}
{"2":{"where":"Project_Number=842"}}
{"3":{"where":"Project_Number=842"}}<\/P>

<\/P>

FEHLER BEIM ÜBERPRÜFEN DES REPLICA-STATUS:<\/P>

<\/P><\/BODY><\/HTML>

Finde mehr Beiträge mit dem Tag

Accepted answers

HemantAngarkar

Hi Chris,

Try using these for LayerQueries;

{"4":{"where":"TEAM='1'"}}

I think you need to use single quotes (' ') to enter values for where clause. Doesn't matter if it is Numeric or string field. I tried the same on my service and I could download the attachments.

1. Data tab of service

2. Query: {"0":{"where":"NUMBER='100'"}}

Please let me know if it works.

Best,

Hemant A

GaryWorley1

Figured this out.

•{"0":{"where":"Project_Number=842'", "where":"Project_Number=845'", "where":"Project_Number=895'"}}

All comments

Anonymous User

Does the create replica work if you leave the layer query out of the equation?
Are you creating the replica from the REST url? Could you put a screenshot for how you fill out the other parameters involved in creating a replica from REST?
Perhaps this article can offer some guidance: How To: Retrieve attachments from a hosted feature service

ChrisKemmerer

Supriya, thank you so much for responding to my post. Yes, the create replica works when the query is left out. I am Creating the replica from the Rest url, see below. You'll notice the url appears as it should. When I click the url I get a failed status and error.

Anonymous User

Do any of the records in layer 4 (above) actually have attachments? I found that if I tried something similar to what you showed in the screenshot above on a layer that didn't have any attachments I got the "Error: Exporting data for layer X failed". But, if I tried the same thing above on a layer with attachments it succeeded.

ChrisKemmerer

All records in Layer 4 have attachments. Could there be something in the feature layer settings that I'm overlooking that doesn't allow features & attachments to be downloaded with a query?

HemantAngarkar

Hi Chris,

Try using these for LayerQueries;

{"4":{"where":"TEAM='1'"}}

I think you need to use single quotes (' ') to enter values for where clause. Doesn't matter if it is Numeric or string field. I tried the same on my service and I could download the attachments.

1. Data tab of service

2. Query: {"0":{"where":"NUMBER='100'"}}

Please let me know if it works.

Best,

Hemant A

ChrisKemmerer

Hemant, thank you so much. The query string work flawlessly. Thanks again!

ChrisKemmerer

Sorry for the multiple replies. How would you string together the query if you wanted to pull Team 1's data from multiple layers? Lets say layers 4 & 7?

Anonymous User

You would add it to the original line, but keep it inside that first bracket. Look at this example here:

Syntax: layerQueries={ Layer_or_tableID1 : {"where":"attribute query" , "useGeometry" : true | false, "includeRelated" : true | false}, Layer_or_tableID2: {.}}

Create Replica—ArcGIS REST API: Services Directory | ArcGIS for Developers

So if I took the first example you posted in this thread and corrected it, it would look something like this:

{"0":{"where":"Project_Number='842'"}, "1":{"where":"Project_Number='842'"}, "2":{"where":"Project_Number='842'"}, "3":{"where":"Project_Number='842'"}}

Anonymous User

I had too many brackets in the response above. Just fixed it.

GaryWorley1

What if you have a couple values you want to query for, do we use some sort of OR statement. Using your example, what if i wanted to query "842, 845, 895"?

GaryWorley1

Figured this out.

•{"0":{"where":"Project_Number=842'", "where":"Project_Number=845'", "where":"Project_Number=895'"}}

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.