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

Query Widget - Filter Results

GavinMayeda

Ok, I have become completely lost trying to configure the Query widget. The basic set-up I grasp, but in the help section it shows the Louisville Police Query widget with a 'Filter results' and 'Show all' feature.

Bluntly, how do I do this???? I have tried the sample code, and that does not give me the results that I am looking for.

I would like to query the data that I have already assembled, and the output is very straightforward. I would like to query by an existing field, have it return all results for that field, and then have the user be able to narrow the results to a single specific value.

As always, any and all help is sincerely appreciated!!

タグ付けされた投稿をもっと見る

Accepted answers

GavinMayeda

The filter results seems to have been a bug in version 3.0. After upgrading to version 3.4 the problem with returning results from all fields instead of the original query field no longer happens.

I hope that this helps anyone that was having the same problem!

All comments

GavinMayeda

Thanks everyone for the input and suggestions.

I was able to adjust the max return settings to 50,000 and while it does slow the app down a bit, it is not intolerable. I did figure out that above 90,000 results the app returns a stack error.

I did speak with an ESRI Programmer at the UC recently, and I have supplied him with the query and my data. He will be looking in to the filter results returning data from fields other than what the query is based on.

I will post results as they come in!!

AntGiles

Yes, as the setting is on the service, any widget using that service will use the max number of features that has been set

Regards

Anthony

MaisarahAbdulHalim

I mean, using other widget using the same map service set at 1000,
For example..Will a search widget return 1000 results as well? what about enhanced search widget?

AntGiles

Maisarah,

The value applies to service not to a particular widget,

Regards

Anthony

MaisarahAbdulHalim

Gavin,

The number of results returned from a service is set in the properties of the service when you publish it, on a 10.1 server this has a default value of 1000.

http://resources.arcgis.com/en/help/main/10.1/index.html#/Setting_map_service_properties/0154000003p1000000/

You can push this number up but you may find it slows your service down. I would guess that 167,000 points will be far to many.

Anthony

Sorry to interrupt,

I have set it to 30,000 and it really is slowing down or crashing my Flex application! 😞

This returning results default value of 1000 applies to all widgets or just this one?

Thanks

GavinMayeda

Anthony,

Thank you for all of your help! The script is working fairly well, but for some reason when I use the filter it seems to be pulling data from all fields rather than the specified field.

For example, filtering a Group Code of 4105 from the initial query will return all matches from the Group Code field, it will also return the value of 4105 from all other fields as well. Is it possible to narrow the filter to using strictly the Group Code field?

Thank you,

Gavin Mayeda

AntGiles

Gavin,

The number of results returned from a service is set in the properties of the service when you publish it, on a 10.1 server this has a default value of 1000.

http://resources.arcgis.com/en/help/main/10.1/index.html#/Setting_map_service_properties/0154000003p1000000/

You can push this number up but you may find it slows your service down. I would guess that 167,000 points will be far to many.

If you want to be able to search against a large data set you may be better off creating a geocode service:

http://resources.arcgis.com/en/help/main/10.1/index.html#/Geocode_services/01540000035t000000/

Regards

Anthony

GISDev1

Anthony,

Thank you so much for the explanation, it helped tremendously.

I have a question though. Is the query limited to a certain number of results? The query is running against 167,000 plus records and is only displaying a result of 1000. I can't really tell where the selection is, but it definitely isn't county wide.

If it will only return a limited amount of results, this probably will not work in the situation that I am trying to use it in.

Thank you again for the reply!!

That 1,000 limit is on the ArcGIS Server side. You will see that option for max. results while publishing your REST Service.

GavinMayeda

Anthony,

Thank you so much for the explanation, it helped tremendously.

I have a question though. Is the query limited to a certain number of results? The query is running against 167,000 plus records and is only displaying a result of 1000. I can't really tell where the selection is, but it definitely isn't county wide.

If it will only return a limited amount of results, this probably will not work in the situation that I am trying to use it in.

Thank you again for the reply!!

AntGiles

Gavin,

All you have to do is put the field name you want to perform the filter against in the <filterfield><name> area, this will take the user input value and find matches anywhere in the field (essentially doing a LIKE '%value%'):

<configuration>
 <layer>Your service URL</layer>
 <titlefield>PD_NAME</titlefield>
 <fields all="false">
  <field name="PD_NAME"/>
  <field name="ADDRESS" alias="Address"/>
 </fields>
 <filterfield>
    <name>yourfieldname</name>
    <alias>text you want to appear above user input</alias>
    </filterfield>
  <linkfield></linkfield>
  <refreshrate></refreshrate>
  <zoomscale>20000</zoomscale>
  <query>1=1</query>
</configuration>

regards

Anthony

会話に参加する

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

クイックリンク

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