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 レイヤークエリ

ChrisKemmerer

<\/HEAD>

私は、複数のプロジェクトで使用されるデータ収集のための複数のフィーチャを含む Webmap 内のホストされた FeatureLayer を持っています。これらのレイヤーからデータと添付ファイルを create replica wizard のレイヤークエリを使って取得できるようにしたいと考えています。この例では、レイヤー 0-3 があり、すべてのレイヤーに共通の属性 "Project_Number" があります。以下の例のようなことをしたいと思っています。これまでに最初の行をテストしましたが、データをダウンロードする URL は生成されるものの、レプリカ作成は失敗します。残念ながらエラー番号は提供されず、失敗したというだけです。何かご助言いただければ幸いです。<\/P>

<\/P>

例:<\/P>

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

<\/P>

レプリカステータス確認エラー:<\/P>

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

タグ付きの投稿をもっと見る

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

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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