DOC
|
Xander, when is the Arcade API going to allow HTML in Enterprise web maps? This would be a game changer, for sure.
... View more
02-15-2020
09:03 AM
|
0
|
0
|
8525
|
DOC
|
It looks like using a variable specified outside the Arcade expression is not possible.
... View more
10-02-2019
10:10 AM
|
0
|
0
|
8525
|
DOC
|
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.
... View more
08-29-2019
11:06 AM
|
1
|
0
|
8525
|
DOC
|
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?
... View more
08-28-2019
12:31 PM
|
0
|
0
|
3573
|
DOC
|
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.
... View more
08-21-2019
07:03 AM
|
1
|
0
|
8525
|
DOC
|
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.
... View more
08-20-2019
03:12 PM
|
0
|
0
|
8525
|
POST
|
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?
... View more
08-20-2019
06:22 AM
|
0
|
1
|
1097
|
POST
|
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?
... View more
08-13-2019
02:39 PM
|
0
|
0
|
282
|
IDEA
|
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
... View more
08-12-2019
12:43 PM
|
13
|
0
|
523
|
POST
|
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?
... View more
08-12-2019
09:48 AM
|
1
|
3
|
1095
|
POST
|
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!
... View more
08-12-2019
09:33 AM
|
0
|
2
|
357
|
POST
|
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.
... View more
08-12-2019
07:19 AM
|
2
|
5
|
3018
|
POST
|
Is this possible using Arcade in AGOL? I'm looking for interactive input of values that drive the query.
... View more
08-09-2019
11:23 AM
|
1
|
7
|
3018
|
POST
|
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.
... View more
08-07-2019
08:14 AM
|
0
|
0
|
1326
|
Title | Kudos | Posted |
---|---|---|
1 | 08-09-2019 11:23 AM | |
1 | 08-12-2019 09:48 AM | |
1 | 08-12-2019 12:45 PM | |
1 | 08-29-2019 11:06 AM | |
1 | 06-17-2019 11:05 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|