topic Re: Can I get/use the number of related records? in ArcGIS Online Questions

Can I get/use the number of related records?

DougBrowning — Thu, 07 Feb 2019 18:31:42 GMT

In a web map the Attribute table will show you how many related records there are for each Relationship Class.

Like this

Is there any way I can get\use this number? Any way to use it to symbolize? Sort by?

For example I want to be able to tell the user they only have 2 LPI forms when it should be 3. AKA how can the user get a list of features that were not fully completed.

In Arcade I can do a check using FeatureSetByName but then I again cannot symbolize or filter. Plus the user would have to click show a thousand times in the attribute table. (The word Complete is where I clicked)

All of these expressions are also hidden from Ops Dashboard. They will show in a popup but cannot use for filters or anything like that. If Ops Dashboard cannot use Arcade can it get this Related records number at all?

Any other ideas on how to do a dynamic QC to see if the job is complete based on the number of related records?

I know I can run some analysis but that becomes static in time. Meaning I have to run it on the regular. It also means a download, run, upload. I have tried to run analysis directly from the Feature service using a SearchCursor /JSON - and it works great on FCs but on tables it does not work (should but just doesn't). In this case all the main level relates I am checking are FCs so this may work actually in this case.

Also cannot use the Arcade expression in any of the Analysis tools in AGOL.

thanks a lot

Re: Can I get/use the number of related records?

DougBrowning — Thu, 07 Feb 2019 19:14:45 GMT

Also I can get the relationship count to show up in AGOL but when I try to use this in the new Collector it shows nothing.

Popup in AGOL shows the 0 just fine. Collector it is just blank. Even when online.

Re: Can I get/use the number of related records?

KellyGerrow — Thu, 07 Feb 2019 21:43:04 GMT

Hi Doug,

Something to try may be to use Arcade or the join tool.

What’s new with Arcade: Taking a stroll through FeatureSets (Part 2)

If this seems to not be working as expected, try getting in touch with tech support.

-Kelly

Re: Can I get/use the number of related records?

DougBrowning — Thu, 07 Feb 2019 22:12:42 GMT

The second image sample shown is using Arcade. But it will not let me filter, sort, of even just show the values. You must click on Show for every single record.

A join would be static so I would have to remake it everyday.

thanks

Re: Can I get/use the number of related records?

KhaledHassen — Fri, 08 Feb 2019 00:49:49 GMT

If you really need the count, then you might need to consider calling the feature service layer queryRelated directly and pass returnCountOnly=true. Any other option would be expensive if done in the client side.

This is how the UX is getting the count.

For example:

https://...services/<myService>/FeatureServer/<myLayer>/queryRelatedRecords?relationshipId=0&definitionExpression=1%3D1&…

Re: Can I get/use the number of related records?

XanderBakker — Fri, 08 Feb 2019 12:19:05 GMT

You can use a Field Calculation in ArcGIS Online that retrieves the number of related records and visualize your data on that new field. The downside is that this field will alter your schema and it will be static. So you will have to recalculate the field when the data changes.

Re: Can I get/use the number of related records?

DougBrowning — Fri, 08 Feb 2019 17:35:23 GMT

Do you know why {relationships/1/objected} (with Count option) works in AGOL popup but not in Collector? It works great in a browser but Collector it is just blank.

Thanks

Re: Can I get/use the number of related records?

AndresCastillo — Mon, 25 Mar 2019 15:09:54 GMT

Hi Doug Browning, Kelly Gerrow , Khaled Hassen , Xander Bakker

In case you might find it useful,

I have come up with a solution to symbolizing from a related table in my post:

Symbolizing Feature Class using related table values

https://community.esri.com/thread/215046-symbolizing-feature-class-using-related-table-values

There is a 17 page word document with details on how to accomplish this.

Re: Can I get/use the number of related records?

KhaledHassen — Mon, 25 Mar 2019 15:23:52 GMT

From the online side, database views are also created when joining the source and destination related table in the online view.

This is currently supported when creating online feature service view and we have some examples of how you can do this in online. This is all done using REST API when you add a new join layer to an empty feature service.

BTW, this is not supported in Portal/server based feature service. I would think this is a good solution moving forward if they desire to render data based on joining the source layer and a related table.

Khaled Hassen

Online Feature Service Lead

Re: Can I get/use the number of related records?

AndresCastillo — Mon, 25 Mar 2019 19:56:30 GMT

Hi Khaled.

I'm not sure I understand what you replied.

Can you please help me understand?

You say that symbolizing off related tables is possible in AGO.

You mention that ESRI has some examples.

Would you be referring to this?:

https://www.esri.com/arcgis-blog/products/product/mapping/visualizing-related-data-with-join-features-in-arcgis-online/

Or do you have other examples?

You also mention that something is not supported in Portal/Server based feature service?

What would be a good solutions moving forward?

Re: Can I get/use the number of related records?

DougBrowning — Wed, 15 Jul 2020 21:43:05 GMT

Checking back in on this one as it has been over a year and a half now. Is it documented that is broke? Bug number?

It still does not work. Also featureset is still not working either.

The other suggestions on here do not work offline.

Got a big project just waiting and waiting on this one. Also posted here Relationships Counts not displaying in Collector and similar here https://community.esri.com/thread/229709-are-the-arcade-featureset-functions-supported-in-collector

Thanks

Re: Can I get/use the number of related records?

DougBrowning — Tue, 13 Apr 2021 13:55:41 GMT

I forgot to update this until someone hit kudo. I talked to the field maps team and they know that these relationship values do not work. They disabled them do to some issues.

They said they would look at reenabling them. Not sure when. This post is 2 years old but I talked to them this past summer.

You can now simulate this using the FeatureSet functions now since these are now working in field maps (but still not collector). But I still think this is weird to have something there that does not work and is not documented anywhere.

Hope it helps someone.

Re: Can I get/use the number of related records?

TravisSizemore — Fri, 10 Jun 2022 16:11:15 GMT

Hi Doug,

Just wondering, have you heard any updates on this? I have a workflow where users create a parent feature when they deploy a device and a related record when they retrieve it. It would be great to have Field Maps calculate the "status" of the parent based on whether a related record exists. This would prevent the most annoying part of the process, which is manually changing the status each time.

Thanks,

Travis

Re: Can I get/use the number of related records?

DougBrowning — Fri, 10 Jun 2022 16:26:17 GMT

Yes FeatuteSet functions all work now. I use this all the time now. (no the related checkboxes still do not work which is weird so have to do it yourself)

If you are just checking does one exist or not then you can modify this code which is close.

var sql = "PlotID = '" + $feature.PlotID + "'"; var tbl = Filter(FeatureSetByName($map,"Natural and Human Disturbances", ['PlotID'], false), sql); if (count(tbl) > 1) { return "More than one form found" } else if (count(tbl) < 1) { return "No forms found" } else { return "1" }

Hope that helps

Re: Can I get/use the number of related records?

TravisSizemore — Fri, 10 Jun 2022 19:24:04 GMT

Doug,

Thanks for the suggestion. The code does work within Arcade, but Field Maps doesn't allow it in practice. When I try to create the feature, I get a "Failed to calculate" error under that field. This occurs whether I apply it to a required field or not. I suspect it might be because the Filter function won't work with a null variable (i.e. "record"). Any ideas to get around this?

var sql = "deployment_key = '" + $feature.deployment_key + "'"; var record = FeatureSetByName($map,"Active End Deployments", ["Deploy Key (GUID)"], false) var tbl_cnt = count(Filter(record, sql)); IIf(tbl_cnt == 1, 'retrieved', 'deployed');

Thanks,

Travis

Re: Can I get/use the number of related records?

TravisSizemore — Fri, 10 Jun 2022 19:32:03 GMT

var sql = "deployment_key = '" + $feature.deployment_key + "'"; var record_cnt = count(FeatureSetByName($map,"Active End Deployments", ["Deploy Key (GUID)"], false)) IIf(record_cnt == 1, 'retrieved', 'deployed');

Actually, when I switched to the above code (removed the Filter), it does allow the calculation in Field Maps when I create the feature, but it doesn't update it when I create the related record, nor does it change if I attempt to edit the parent feature.

Thanks,

Travis

Re: Can I get/use the number of related records?

DougBrowning — Fri, 10 Jun 2022 19:47:50 GMT

Are you trying to do this as like an attribute rule or just for display in the popup? I assumed popup. Have not used rules much but I would think you would need to test for null. But then I do not know if it would ever populate after the fact. Popup should be enough I think?

Re: Can I get/use the number of related records?

TravisSizemore — Fri, 10 Jun 2022 19:52:37 GMT

I was trying to do it as an attribute rule within Field Maps, but maybe if that's not possible I could do something with the popup. The only real use of this field is to change the symbology within the mobile map so they can see where they need to retrieve remaining devices. Perhaps the same expression within the symbology settings would work.

Re: Can I get/use the number of related records?

DougBrowning — Fri, 10 Jun 2022 19:58:37 GMT

I was afraid you would say that. Sorry but cant use FeatureSet functions for symbols. Too slow I guess. Pop up only. It is a huge drawback for sure. If you want symbols has to be a real field. Then its back to old school run a script on a schedule. Not sure this will ever change? It could be super duper slow.

Re: Can I get/use the number of related records?

TravisSizemore — Fri, 10 Jun 2022 20:14:47 GMT

Doug,

That's what I suspected, but I figured it was worth asking around to see if anything has changed. Thanks for the info.

Travis