topic Re: Profile Variable $Map is Not Found in ArcGIS Pro Questions

Profile Variable $Map is Not Found

Mohamed_Gamal — Mon, 06 Feb 2023 07:39:41 GMT

I am trying to filter the database by using profile variable $Map in ArcGIS Pro Attribute Rules and I had an Object Not Found Error

var deviceClass = FeatureSetByName($map, "Communications Device");

Another Question :

I always do this kind of filter using profile variable $datastore. I want only to get the field room from this table, but when printing the results all fields are there

var test="{4EC98101-67C4-44FC-8BF5-C7DF9393AB73}"
var deviceClass = FeatureSetByName($datastore, "CommunicationsJunctionObject");
var devicesRows = Filter(deviceClass, "GLOBALID = @test");
return{"errorMessage":"FeatureSetByAssociation: "+first(devicesRows)};

this screen of the output

var test="{4EC98101-67C4-44FC-8BF5-C7DF9393AB73}"
var deviceClass = FeatureSetByName($datastore, "CommunicationsJunctionObject",['room'],false);
var devicesRows = Filter(deviceClass, "GLOBALID = @test");
return{"errorMessage":"FeatureSetByAssociation: "+first(devicesRows)};

the second output

Re: Profile Variable $Map is Not Found

JohannesLindner — Mon, 06 Feb 2023 08:05:37 GMT

To post code:

I am trying to filter the database by using profile variable $Map in ArcGIS Pro Attribute Rules

You can't use $map in attribute rules. Attribute rules work on the database level and can be triggered from different maps (or even without a map at all), so it doesn't make sense to rely on a featureset in a specific map.

Instead, use $datastore if the featureset is in the same database. If not, you have to publish it and load it in using FeaturesetByPortalItem().

I want only to get the field room from this table, but when printing the results all fields are there

You return the whole feature, so every field is printed. Instead, return only a specific field:

var test="{4EC98101-67C4-44FC-8BF5-C7DF9393AB73}" var deviceClass = FeatureSetByName($datastore, "CommunicationsJunctionObject"); var devicesRows = Filter(deviceClass, "GLOBALID = @test"); var device = First(devicesRows) var room = IIf(device == null, "nodevice found", device.room) return{"errorMessage":"FeatureSetByAssociation: " + room};

Re: Profile Variable $Map is Not Found

Mohamed_Gamal — Mon, 06 Feb 2023 08:20:52 GMT

Hi Johannes,

Thanks for your attention and your fast reply.

Regarding my second question, I know how to print a specific field from the feature my question was about, I had read in the documentation that specifying specific fields to feature class or table is making performance faster, so I thought the object returned from this line should only contain room field.

var deviceClass = FeatureSetByName($datastore, "CommunicationsJunctionObject",['room'],false);

Re: Profile Variable $Map is Not Found

JohannesLindner — Mon, 06 Feb 2023 12:35:33 GMT

Ah, I see now that I misunderstood your second question.

I see this behavior in a file gdb. While the Console() command ouputs the right message (empty geometry and only one field [plut OBJECTID]), the error message prints the complete feature, although I didn't load the geometry and the other fields.

var fs = FeatureSetByName($datastore, "TestLines", ["IntegerField"], false); Console(First(fs)) return {errorMessage: Text(First(fs))}

In an Enterprise GDB, it works as expected:

var fs = FeatureSetByName($datastore, "Bauwerke", ["BauwerkID"], false); Console(First(fs)) return {errorMessage: Text(First(fs))}

@HusseinNasser2 , any insights?

Re: Profile Variable $Map is Not Found

Mohamed_Gamal — Mon, 06 Feb 2023 12:51:46 GMT

Thanks, Johannes it was a fruitful discussion.

Re: Profile Variable $Map is Not Found

HusseinNasser2 — Mon, 06 Feb 2023 15:11:58 GMT

@JohannesLindner Can you try the filegdb case with Pro 3.1 Beta if you have access?

We have a known issue where Arcade might sometime fetch all the fields even a subset is provided.

Re: Profile Variable $Map is Not Found

Mohamed_Gamal — Mon, 06 Feb 2023 15:08:55 GMT

Unfortunately, I don't have access to Pro 3.1 Beta version.

Re: Profile Variable $Map is Not Found

JohannesLindner — Mon, 06 Feb 2023 15:35:03 GMT

@HusseinNasser2 I don't have access to the beta. The example above was done in 3.0.3

Re: Profile Variable $Map is Not Found

HusseinNasser2 — Mon, 06 Feb 2023 15:50:27 GMT

No worries, I confirmed this is fixed in Pro 3.1.

Re: Profile Variable $Map is Not Found

GelcysWilliams — Fri, 29 Mar 2024 12:51:28 GMT

We have been able to use the $map to do the following in AGOL, but our need is for auto-filling certain attributes in Pro as well as in AGOL. Can you use that FeaturesetByPortalItem() variable to connect to other FCs in other databases on your Portal for use in Intersect and Nearest Neighbor Attribute rules for use in Pro?