Hello,
I'm using two versions of DevExpress, the v23.1.4 and v18.2.5.
I'm with a problem that when I try to Load a layout from XML in the PivotGridControl with prefilter from a different version, it doesn't work.
For example:
1 - In the v18.2.5, set a Prefilter to the PivotGridControl and save the layout to XML using "SaveLayoutToXml".
2 - Go to the v23.1.4 and restore the exact same PivotGridControl XML using "RestoreLayoutFromXml". The Prefilter will load blank.
If you do the reverse steps (save in the v23.1.4 and load on the v18.2.5) the same thing happens.
I've noticed that the versions save the Prefilter in a different way in the XML.
The v18.2.5 saves in the following way:
XML<property name="Prefilter" isnull="true" iskey="true">
<property name="Criteria">~Xtra#Base64AAEAAAD/////AQAAAAAAAAAMAgAAAFlEZXZFeHByZXNzLkRhdGEudjE4LjIsIFZlcnNpb249MTguMi41LjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49Yjg4ZDE3NTRkNzAwZTQ5YQUBAAAAJ0RldkV4cHJlc3MuRGF0YS5GaWx0ZXJpbmcuR3JvdXBPcGVyYXRvcgIAAAAIb3BlcmFuZHMMT3BlcmF0b3JUeXBlBAQ0RGV2RXhwcmVzcy5EYXRhLkZpbHRlcmluZy5Dcml0ZXJpYU9wZXJhdG9yQ29sbGVjdGlvbgIAAAArRGV2RXhwcmVzcy5EYXRhLkZpbHRlcmluZy5Hcm91cE9wZXJhdG9yVHlwZQIAAAACAAAACQMAAAAF/P///ytEZXZFeHByZXNzLkRhdGEuRmlsdGVyaW5nLkdyb3VwT3BlcmF0b3JUeXBlAQAAAAd2YWx1ZV9fAAgCAAAAAAAAAAUDAAAANERldkV4cHJlc3MuRGF0YS5GaWx0ZXJpbmcuQ3JpdGVyaWFPcGVyYXRvckNvbGxlY3Rpb24DAAAADUxpc3RgMStfaXRlbXMMTGlzdGAxK19zaXplD0xpc3RgMStfdmVyc2lvbgQAACxEZXZFeHByZXNzLkRhdGEuRmlsdGVyaW5nLkNyaXRlcmlhT3BlcmF0b3JbXQIAAAAICAIAAAAJBQAAAAQAAAABAAAABwUAAAAAAQAAAAQAAAAEKkRldkV4cHJlc3MuRGF0YS5GaWx0ZXJpbmcuQ3JpdGVyaWFPcGVyYXRvcgIAAAAJBgAAAAkHAAAACQgAAAAJCQAAAAUGAAAAJ0RldkV4cHJlc3MuRGF0YS5GaWx0ZXJpbmcuVW5hcnlPcGVyYXRvcgIAAAAHT3BlcmFuZAxPcGVyYXRvclR5cGUEBCpEZXZFeHByZXNzLkRhdGEuRmlsdGVyaW5nLkZ1bmN0aW9uT3BlcmF0b3ICAAAAK0RldkV4cHJlc3MuRGF0YS5GaWx0ZXJpbmcuVW5hcnlPcGVyYXRvclR5cGUCAAAAAgAAAAkKAAAABfX///8rRGV2RXhwcmVzcy5EYXRhLkZpbHRlcmluZy5VbmFyeU9wZXJhdG9yVHlwZQEAAAAHdmFsdWVfXwAIAgAAAAMAAAABBwAAAAYAAAAJDAAAAAHz////9f///wMAAAABCAAAAAEAAAAJDgAAAAHx/////P///wEAAAABCQAAAAYAAAAJEAAAAAHv////9f///wMAAAAFCgAAACpEZXZFeHByZXNzLkRhdGEuRmlsdGVyaW5nLkZ1bmN0aW9uT3BlcmF0b3ICAAAACG9wZXJhbmRzDE9wZXJhdG9yVHlwZQQENERldkV4cHJlc3MuRGF0YS5GaWx0ZXJpbmcuQ3JpdGVyaWFPcGVyYXRvckNvbGxlY3Rpb24CAAAALkRldkV4cHJlc3MuRGF0YS5GaWx0ZXJpbmcuRnVuY3Rpb25PcGVyYXRvclR5cGUCAAAAAgAAAAkSAAAABe3///8uRGV2RXhwcmVzcy5EYXRhLkZpbHRlcmluZy5GdW5jdGlvbk9wZXJhdG9yVHlwZQEAAAAHdmFsdWVfXwAIAgAAADAAAAABDAAAAAoAAAAJFAAAAAHr////7f///zAAAAABDgAAAAMAAAAJFgAAAAMAAAABAAAAARAAAAAKAAAACRcAAAAB6P///+3///8wAAAAARIAAAADAAAACRkAAAACAAAAAQAAAAEUAAAAAwAAAAkaAAAAAgAAAAEAAAAHFgAAAAABAAAABAAAAAQqRGV2RXhwcmVzcy5EYXRhLkZpbHRlcmluZy5Dcml0ZXJpYU9wZXJhdG9yAgAAAAkbAAAACRwAAAAJHQAAAAoBFwAAAAMAAAAJHgAAAAIAAAABAAAABxkAAAAAAQAAAAQAAAAEKkRldkV4cHJlc3MuRGF0YS5GaWx0ZXJpbmcuQ3JpdGVyaWFPcGVyYXRvcgIAAAAJHwAAAAkgAAAADQIHGgAAAAABAAAABAAAAAQqRGV2RXhwcmVzcy5EYXRhLkZpbHRlcmluZy5Dcml0ZXJpYU9wZXJhdG9yAgAAAAkhAAAACSIAAAANAgEbAAAACgAAAAkjAAAAAdz////t////MAAAAAEcAAAACgAAAAklAAAAAdr////t////MAAAAAEdAAAACgAAAAknAAAAAdj////t////MAAAAAceAAAAAAEAAAAEAAAABCpEZXZFeHByZXNzLkRhdGEuRmlsdGVyaW5nLkNyaXRlcmlhT3BlcmF0b3ICAAAACSkAAAAJKgAAAA0CBR8AAAApRGV2RXhwcmVzcy5EYXRhLkZpbHRlcmluZy5PcGVyYW5kUHJvcGVydHkBAAAADHByb3BlcnR5TmFtZQECAAAABisAAAAQcGl2b3RHcmlkRmllbGQyMgUgAAAAJkRldkV4cHJlc3MuRGF0YS5GaWx0ZXJpbmcuT3BlcmFuZFZhbHVlAQAAAAV2YWx1ZQICAAAABiwAAAAEZnJlZQEhAAAAHwAAAAkrAAAAASIAAAAgAAAABi4AAAANdHVsbyBhZ3J1cGFkbwEjAAAAAwAAAAkvAAAAAgAAAAEAAAABJQAAAAMAAAAJMAAAAAIAAAABAAAAAScAAAADAAAACTEAAAACAAAAAQAAAAEpAAAAHwAAAAkrAAAAASoAAAAgAAAABjMAAAAKSU5DT0JSQVZFTAcvAAAAAAEAAAAEAAAABCpEZXZFeHByZXNzLkRhdGEuRmlsdGVyaW5nLkNyaXRlcmlhT3BlcmF0b3ICAAAACTQAAAAJNQAAAA0CBzAAAAAAAQAAAAQAAAAEKkRldkV4cHJlc3MuRGF0YS5GaWx0ZXJpbmcuQ3JpdGVyaWFPcGVyYXRvcgIAAAAJNgAAAAk3AAAADQIHMQAAAAABAAAABAAAAAQqRGV2RXhwcmVzcy5EYXRhLkZpbHRlcmluZy5Dcml0ZXJpYU9wZXJhdG9yAgAAAAk4AAAACTkAAAANAgE0AAAAHwAAAAY6AAAADU5vdmEgQ29sdW5hNjEBNQAAACAAAAAGOwAAAAhBZ3J1cGFkbwE2AAAAHwAAAAk6AAAAATcAAAAgAAAABj0AAAAIQXByb3ZhZGEBOAAAAB8AAAAJOgAAAAE5AAAAIAAAAAY/AAAACFZhbGlkYWRhCw==</property>
<property name="ShowOperandTypeIcon">false</property>
<property name="Enabled">true</property>
</property>
The v23.1.4 saves the following way:
XML<property name="Prefilter" isnull="true" iskey="true">
<property name="ShowOperandTypeIcon">false</property>
<property name="Enabled">true</property>
<property name="CriteriaString">Not Contains([pivotGridField22], 'free') And Not Contains([pivotGridField22], 'tulo agrupado') And (Contains([Nova Coluna61], 'Agrupado') Or Contains([Nova Coluna61], 'Aprovada') Or Contains([Nova Coluna61], 'Validada')) And Not Contains([pivotGridField22], 'INCOBRAVEL')</property>
</property>
They both were saved with the exact same Prefilter.
The other things of the layout loads correctly, like columns index, sorting, etc.
Is there a way for me to load the Prefilter correctly in the v23.1.4 using the XML generated from the v18.2.5 in the PivotGridControl?
Thank you