topic Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work in ArcGIS Pro Questions

ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

DeanAnderson2 — Mon, 21 Dec 2020 16:55:47 GMT

I just upgraded from 2.7 from 2.6 ArcPro using a file geodatabase. In 2.6 I had a page query filter set so my table matched my map series. I have a table frame linked to this table. It worked Great in 2.6 and ONLY displayed the records associated with the page. After installing 2.7 this no longer works. All records in the table referenced by the table frame display (it appears that the map series page filter is not working). I have tried several alternatives (reloading the table frame, resetting the map series page filter, etc). Gone over the release notes and nothing appears to have changed. Nothing seems to work. Have I missed something?

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

KoryKramer — Mon, 21 Dec 2020 17:35:46 GMT

Hi Dean, I just tried a quick table frame filtered by the map series page and it works fine for me in 2.7. Granted, I just created this fresh, so it wasn't existing and then opened after upgrading to 2.7, so I can't speak for that part. I checked and can't find anybody else noting this as an issue so it might be good to get in touch with technical support.

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

DeanAnderson2 — Mon, 21 Dec 2020 18:01:39 GMT

Did you try a stand alone table? The process works fine for looking at feature classes.

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

JeffBarrette — Mon, 21 Dec 2020 22:49:17 GMT

Hello Dean,

I was able to reproduce. I created a 2.5 project, added a feature class AND a stand alone table. I set up a map series on the feature class and then set up the page query on the table/tableframe. Only the filtered records displayed in the table frame. I opened the same project in 2.7 and all records were showing. This is a regression and can hopefully address it as a service pack with very high priority (once we identify how it was broken).

As possible work around: Can you join the index layer with your stand alone table, then set the properties of the table frame to ONLY show 'Map series rows'? This produces the same effect.

In my simple example, I had State_Polygons joined to Counties_Table (one to many).

Jeff - Layout / arcpy.mp Teams (and former ORMAP participant)

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

DeanAnderson2 — Mon, 21 Dec 2020 23:01:17 GMT

Thanks Jeff - I will give it a try.

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

JeffJensen3 — Mon, 28 Dec 2020 23:00:05 GMT

I am having the same issue as Dean, hopefully this will get resolved quickly.

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

ElwynPratt1 — Thu, 07 Jan 2021 21:37:24 GMT

We are having this issue as well. We have a table that is pulled from an enterprise geodatabase that we use for a map series. We had used page queries to show only the records for the given map series page but page queries no longer seem to be working with tables. Even bringing in a csv and turning page queries on does nothing. Really hoping this gets resolved.

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

JeffBarrette — Mon, 11 Jan 2021 16:32:38 GMT

Does the workaround mentioned above help you? We are currently testing a local fix and hope to include it in a 2.7 service pack.

Jeff Layout and arcpy.mp teams

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

DeanAnderson2 — Mon, 11 Jan 2021 23:41:04 GMT

Did not work as intended. However, my cartographers and my production machine are still at 2.6 so it is not a critical issue at this time. My cartographers will be playing with adjusting the 2.6 layout for map production for sometime to come. Looking forward to the 2.7 patch. Thanks for checking.

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

AndrewHargreaves1 — Wed, 20 Jan 2021 21:02:53 GMT

too have this issue. Sadly the work around suggested is not an option for me...

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

pctuserpittsfield — Tue, 16 Feb 2021 21:09:26 GMT

I too am having the same problem trying to add a table to a map series layout. Selecting to query "Map series rows" in the element properties does not work either. Also just tried dynamic text - attributes, no deal.

running Pro 2.7.0

Please fix!

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

KoryKramer — Tue, 16 Feb 2021 22:47:53 GMT

Sorry that you're running into this @pctuserpittsfield The issue is listed as https://support.esri.com/en/bugs/nimbus/QlVHLTAwMDEzNjc3MA== on the support site. You can use the Subscribe button to get set up for notifications and this will also increment the count on the bug.

In the meantime, are you able to use the workaround that Jeff posted?

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

JeffBarrette — Wed, 17 Feb 2021 15:40:38 GMT

This is has been addressed and will be included with the 2.7.2 patch.

Jeff - Layout and arcpy.mp Teams

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

pctuserpittsfield — Wed, 17 Feb 2021 15:51:48 GMT

Hey Kory Kramer,

I was able to get the table frame to match the Map series using the above mentioned method of joining the source table to the indexing layer. It took an extra step for me, I hade a 'many to one' style join so I had to first copy the layer and use the copied over layer for the table as not to alter other dynamic index related text on the layout, ie: page titles etc.

Thanks!

Matt

Re: ArcPro 2.7 Upgrade causing my layout map series page filter with table reference not to work

LiviaBetancourtMazur — Mon, 22 Feb 2021 19:28:06 GMT

I just discovered that I was having this same problem and I am happy to see that this will be resolved in the 2.7.2 patch!