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 Laagquery

ChrisKemmerer

<\/HEAD>

Ik heb een gehoste FeatureLayer in een Webmap die meerdere features bevat voor dataverzamelingen die in meerdere projecten zullen worden gebruikt. Ik zou graag data en bijlagen van die lagen willen ophalen met behulp van een laagquery in de create replica wizard. Voor dit voorbeeld heb ik lagen 0-3, alle lagen hebben een gemeenschappelijk attribuut, "Project_Number". Ik zou iets soortgelijks willen doen als het onderstaande voorbeeld. Tot nu toe heb ik de eerste regel getest, hoewel deze een url genereert om de data te downloaden, faalt het aanmaken van de replica. Helaas geeft het geen foutnummer, alleen dat het mislukt is. Alle inzichten worden zeer gewaardeerd.<\/P>

<\/P>

VOORBEELD:<\/P>

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

<\/P>

CONTROLEER REPLICA STATUS FOUT:<\/P>

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

Vind meer berichten getagd met

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'"}}

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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