Latest Contributions by deleted-user-H23pxZFaj1tR

‎02-15-2020

Xander, when is the Arcade API going to allow HTML in Enterprise web maps? This would be a game changer, for sure.

‎10-02-2019

It looks like using a variable specified outside the Arcade expression is not possible.

‎08-29-2019

OK, Xander Bakker, By using a simple counter "p" and conditions, I was able to get the job done. For the first non-empty result, instead of the counter, I just return the attribute. .... for(var b in bridge){ var intelTech = Filter(intelAll, "GlobalID = '" + b.relateReport + "'"); if (!IsEmpty(First(intelTech))){ return First(intelTech).hlink; } }‍‍‍‍‍‍ ....‍‍‍‍‍‍‍‍ For the second, third, and n th non-empty result, I specify the number in the second if statement. .... var p = 0; for(var b in bridge){ var intelTech = Filter(intelAll, "GlobalID = '" + b.relateReport + "'"); if (!IsEmpty(First(intelTech))){ p++; } if (p == 2){ return First(intelTech).hlink; } }‍‍‍‍‍‍‍‍‍‍‍ ....‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ The non-empty part is important because I have a few different ways the reports need to be filtered, but the bridge table is bringing all of the intersecting feature's related results. In the loop, there will be "b in bridge" that match one of the filters and also some that don't, returning an empty result.

‎08-28-2019

I'm using WAB 2.12 and seeing the same behavior. The basemap is not in the widget settings to be selected. When Exclusive is true, the basemap is removed along with the layers that should go. Downloaded Layer Toggle Button widget on 8/16/2019. Any ideas?

‎08-21-2019

Hi Xander Bakker‌, I was trying to avoid iterating over the FeatureSets since the array[index] should work. Can you confirm the problem is that there is no geometry, ie. a flat table? The third feature is only important because I am getting the first and second results in separate expressions. I'm getting the title and url for each of the top 3 (meaning 6 separate expressions), then making the 3 titles linked in the popup. Sorry for the confusing randomness of the third record! Formatting HTML in the Arcade expression would save a huge amount of work and server calls. I found a few ArcGIS Ideas that support this idea. I'll try laying it out without nesting and implement iteration, then let you know.

‎08-20-2019

var bridge = Filter(FeatureSetByName($map,"IntelBridge",["ReportID","relateArea","relateReport"],false),("relateArea = '" + $feature.GlobalID + "'")); var intelAll = First(Reverse(Top(OrderBy(Filter(FeatureSetByName($map,'reportAll',['ReportID','Title','GlobalID'],false),("GlobalID = '" + bridge[2].relateReport + "'")), 'ReportID DSC'), 3))); var intelItem = Left(intelAll[0].Title, 70) + "...\n"; return intelItem;‍‍‍‍‍‍‍‍‍‍‍‍‍ Xander Bakker I'm still unable to use the FeatureSet[index] notation with my FeatureSets. Does it work on non-spatial tables? When I try Console(bridge); on line 2, and remove the rest, I get object, FeatureSet. When I try Console(bridge[0]); on line 2 and remove the rest, I get Execution Error:Runtime Error: Cannot call member property on object of this type.

‎08-20-2019

Setting filters on the related table within the web map does not help. Since this is the case, I'm having trouble understanding exactly what $feature and $layer are referencing. Can this be clarified beyond what the documentation says?

‎08-13-2019

Thank you for the response and explanation! Would it work to have multiple single choice cascading select questions which could display only if the previous one was filled?

‎08-12-2019

Thank you! Here is the Idea.

‎08-12-2019

I'd like to be able to use filters on my related table results, based on their own attributes. For instance, Sample Sites feature has Samples as a related 1:M table. I want a user to filter for sample results of an arbitrary value and return those records from the related Samples table. Basically, I want a global variable that is assigned outside the Arcade expression. #arcade‌

‎08-12-2019

Thanks, I have not decided on the presentation yet, but either WAB or Dashboard, probably. I tried filtering the Reports table in the Web Map, which is queried using FeatureSetByName($map,...); but that did not change the results returned, unfortunately. So there is no way to pass a variable to the Arcade expression at runtime?

‎08-12-2019

Hi James Tedrick and Ismael Chivite‌, I have a web map with four static geographies, four bridge tables, and a single report table. Reports can refer to one or more of each of the geographies. For example, a report could be attributed to 4 Counties, 1 State, and 2 Regions. The survey needs to create a report record, and multiple entries in the bridge tables. I'm thinking that using select_multiple would allow a report to be associated with multiple counties, for instance. Then I would want four select_multiple questions, one for each geography. First question is can the select_multiple questions be populated with the geography names from the related tables? Should I use an external choice list in this survey? Second, will this work with bridge tables that have two GUID foreign keys, one to Geography tables and one to Report table? Third, if the hosted feature service contains the items described in the first sentence above, can a single Survey123 record submission enter data in all four of the geography bridge tables? Would this mean multiple submission_url's? It seems this poster got it to work on the web client, but should I consider re-architecting to have a single bridge table? Any advice would be appreciated!

‎08-12-2019

HiXander Bakker‌, I have a county polygon layer (PK=FIPS) related to a bridge table with two fields (FK1=FIPS, FK2=ReportID), which is related to a Reports table (PK=ReportID). Using your fantastic guidance here, I was able to retrieve the reports from the second related table for the clicked $feature.FIPS by iterating over the FeatureSet returned from the bridge table, and sending a second query to the Reports table. Bonus points: I have three other overlapping polygon geographies with bridge tables that are returning Reports by using Intersect functions, all from within the Counties layer. Reports have dates and types, and I'd like to provide filter options to select reports based on user-specified values: a range for dates, and a single selection for type.

‎08-09-2019

Is this possible using Arcade in AGOL? I'm looking for interactive input of values that drive the query.

‎08-07-2019

Type System Version=SQL Server 2017 did not work for me either. I had used Type System Version=SQL Server 2012, which worked with the 2017 software, but Latest seems more appropriate.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by deleted-user-H23pxZFaj1tR

Re: Using FeatureSetBy functions in Arcade to drill-down to other layers and tables

Re: Using FeatureSetBy functions in Arcade to drill-down to other layers and tables

Re: Using FeatureSetBy functions in Arcade to drill-down to other layers and tables

Re: Layer Toggle Button Widget Version 2.14 - 01/13/2020

Re: Using FeatureSetBy functions in Arcade to drill-down to other layers and tables

Re: Using FeatureSetBy functions in Arcade to drill-down to other layers and tables

Re: Filter based on relationship class?

Re: Survey123 related to multiple geography layers

Re: Filter based on relationship class?

Ability to pass a user-defined variable to an Arcade expression

Re: Filter based on relationship class?

Survey123 related to multiple geography layers

Re: Filter based on relationship class?

Re: Filter based on relationship class?

Re: EgdbSQL connection failure

Re: Filter based on relationship class?

Re: Filter based on relationship class?

Re: Filter based on relationship class?

Re: Using FeatureSetBy functions in Arcade to dril...

Export SHP or KML Feature Action from Web AppBuild...