The xpath query is too complex

Hi guacimapr,

"The xpath query is too complex" is a common error when using "appendItem()". There is a maximum number of items you can append to an item (collection), before this error gets thrown (I forget how high that number was, maybe somewhere around 2000?). You can work around this by looping at most, say, 1500 times, then applying, and then continuing to loop over a now freshly empty collection.

Regardless, I'd be interested in what you want to achieve with this. It feels like this is not quite how property federation is normally implemented. If you simply want to populate some federated properties on 'Part' by values from a SQL database, an onAfterGet method should be completely fine and no "apply()" would be necessary.

int thisCount = this.getItemCount();
for (int i = 0; i < thisCount; i++)
{
   var currentItem = this.getItemByIndex(i);
   string federatedPropertyValue = GetPropertyValueFromSql(currentItem.getID())
   currentItem.setProperty("federated_property", federatedPropertyValue);
}

return this;

This code assumes that you can get the federated information from the SQL DB from a Part's ID in a custom method called GetPropertyValueFromSql(). Note that you will not 'apply()' the item here, since that would commit the data to the local Aras DB. Since we want item federation, we simply add the property to the DOM of 'this'-nodes and then return this, which will then be used to populate the fields in the Grid or Form UI.

Hope this helps.

Cheers,

C