Comments
There is a third limitation to the unopened filter. It doesn't refer to work items but to accounts. So once I complete the first step of a sequence the status remains opened even though I haven't touched the next step yet. So you can only filter on unopened first steps, but not on any "unopened" steps after that.
Totally agree too. I still do not understand how it is possible for line items to appear in ascending order within the CRM but change to descending order when exporting to a Word or PDF document. In conversations with Microsoft Support, they told me that they use the following expression:entityExpression.Order.AddOrder("sequencenumber", Xrm.Sdk.Query.OrderType.Descending);I fail to understand why this cannot be configured to Ascending to resolve the issue, when in the .Net documentation it's says that they can do it. I am attaching the link so you can check what I am referring to: https://learn.microsoft.com/en-us/dotnet/api/microsoft.xrm.sdk.query.ordertype?view=dataverse-sdk-latestI do not understand why, if the option for Ascending order exists in the documentation, we are consistently told that it is not possible.