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

Consulta de Capa en ArcGIS Online

ChrisKemmerer

<\/HEAD>

Tengo una FeatureLayer alojada en un Webmap que contiene múltiples entidades para colecciones de datos que se utilizarán en varios proyectos. Me gustaría poder extraer datos y archivos adjuntos de esas capas usando una consulta de capa en el asistente de creación de réplica. Para este ejemplo, tengo las capas 0-3, todas las capas tienen un atributo común, "Project_Number". Me gustaría hacer algo similar al ejemplo a continuación. Hasta ahora he probado la primera línea, aunque produce una URL para descargar los datos, la creación de la réplica falla. Desafortunadamente no proporciona un número de error, solo indica que falló. Cualquier orientación sería muy apreciada.<\/P>

<\/P>

EJEMPLO:<\/P>

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

<\/P>

ERROR AL VERIFICAR EL ESTADO DE LA RÉPLICA:<\/P>

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

Encuentra más publicaciones etiquetadas con

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

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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