topic Re: Changing where clause for createQuery() in ArcGIS JavaScript Maps SDK Questions

Changing where clause for createQuery()

Charan — Wed, 09 Aug 2023 12:02:49 GMT

Hi everyone, I'm trying to download statistics for a drawn buffer. I'm able to do that but if I change my year (the where clause) instead of downloading the data for the new year, it keeps using the same year. For instance, if I select 2020, it will download the data statistics using 2020 year but then if I switch to the 2021 year it still downloads 2020.

@UndralBatsukh @JoelBennett @KenBuja

Re: Changing where clause for createQuery()

KenBuja — Wed, 09 Aug 2023 13:55:02 GMT

Are you checking your console to see if the if statements in line 12, 19, 26, 40, 47, or 54 are being evaluated properly? Is the field you're querying a text field or a numeric field? Should the query be "year in (2021, 2022)" or "year in ('2021', '2022')"?

Re: Changing where clause for createQuery()

Charan — Wed, 09 Aug 2023 14:12:04 GMT

Hi, @KenBuja my console.log() for the above lines is working correctly, when I select the year 2020 and then select Toronto, it prints Toronto and works (lines 11 and 13). and when I switch to 2021 it prints 2021(line 48). The year field is numeric. For queries, it should only take one value at a time, so if I do 2020 it should be year = 2020, but if I switch my select option to 2021 it should be year=2021

Re: Changing where clause for createQuery()

Charan — Wed, 09 Aug 2023 14:23:38 GMT

Is there a way to rest queries, because the if statement seems to be working but the .where= doesn't seem to reset

Re: Changing where clause for createQuery()

KenBuja — Wed, 09 Aug 2023 14:33:05 GMT

You're adding quotes to the where clause, which is causing the problem. The method val is probably also returning a string, so I'm converting it to an integer, also.

var option = ParseInt([$("#YearSource").val()]); //var result = "'" + option.join("','") + "'"; querycentroids.where="year = " + option;

Re: Changing where clause for createQuery()

Charan — Wed, 09 Aug 2023 14:48:23 GMT

I changed my code using this but my query is not resetting. Please see the code

Re: Changing where clause for createQuery()

KenBuja — Wed, 09 Aug 2023 14:52:01 GMT

I had a small mistake in the code. It should be "parseInt".

When you run the query after changing the year, have you checked the where clause to make sure it's correct?

Re: Changing where clause for createQuery()

Charan — Wed, 09 Aug 2023 15:38:38 GMT

yup I fixed the parseInt, and when I switch to the year, I checked the console and I see where the clause becomes where: "year = 2021".

Re: Changing where clause for createQuery()

KenBuja — Wed, 09 Aug 2023 15:14:29 GMT

From what I can tell in the code (I can't run it due to a permissions problem), it looks like you're running the querycentroids query before you reset the year. Where is the query run again after you change the where clause?

Re: Changing where clause for createQuery()

Charan — Wed, 09 Aug 2023 15:42:18 GMT

Im able to download the correct data now, the only problem is if i draw multiple buffers on the map it will only give the data for the first drawn buffer, please see the updated code: https://codepen.io/Charanb98/pen/wvYdQYV

Re: Changing where clause for createQuery()

KenBuja — Wed, 09 Aug 2023 17:50:59 GMT

You should put this in a separate question. And it's quite an ask to review this much coding. It's better to create a small example that illustrates the problem

Re: Changing where clause for createQuery()

Charan — Thu, 10 Aug 2023 15:41:17 GMT

Hi @KenBuja I had created a new question, could you please check it out