Expressions Not Being Honored By The Append Tool When Appending From A Parcel Type To A Simple Feature Class

[MikeZummo]

Hi There, 

   I am trying to append features from a Pro parcel fabric parcel type (polygons) to a simple feature class. I am attempting to use the Append GP tool with an expression to select only a subset of features but the append tool is not honoring the expression even though it is valid. It is essentially ignoring whatever expression I build in and just appending everything from the parcel type into the simple feature class. The expressions are working between simple feature classes but not going from parcel fabric to a simple feature class. I am wondering if anyone else has encountered this issue as well?

Thanks,

Mike Z

[AmirBar-Maor · Accepted solution]

Hi Mike,

This is a bug.

Why does it happen? no idea - after all, parcel fabric feature classes are simple feature classes with simple feature layers.

Thanks for reporting.

If this bug impacts your business processes please also log this as a case with technical support.

Amir

[MikeZummo]

Thanks Amir! I wanted to check here first to make sure that it was not by design. It's not impacting us yet,  I  was just looking for a convenient way to move certain features from the fabric to published feature classes for distribution. My work-around for now is to simply select feature using a query outside of the tool, then run the append. 

[AmirBar-Maor]

@MikeZummo 

It turns out this issue is not specific to parcel fabrics and is caused by layers that have definition queries.

Until this is fixed the workarounds are simple:

Option 1: remove the definition query from the source layer (you can copy-paste the layer first)

Option 2: modify the definition query by using AND <SQL Expression> on your source layer.

This should be fixed in Pro 2.8.

Amir