BuyLog In
Ticket T499113
Visible to All Users

Exception when sorting on PersistentAlias column

created 8 years ago

Hi there

We have a Invoice class with the following Order property.
[PersistentAlias("[InvoiceRules].Min([OrderRuleConnection.OrderRule.Order])")]
public PurchaseOrder Order
{
        get { return EvaluateAlias<PurchaseOrder>(nameof(Order)); }
 }

The Order class uses the following attribute
[DefaultProperty("Number")]

I get the following exception when I open a ListView with Invoices and when I sort on the Order column (sorry it's in Dutch)
System.ArgumentException: Onjuiste eigenschap 'Order' in een pad. Een referentie eigenschap of verzameling's relatie wordt verwacht.
   bij DevExpress.Xpo.Helpers.PersistentCriterionExpander.MergeAlias(XPClassInfo[] upLevelsWithReference, MemberInfoCollection path, Int32 start, XPMemberInfo mi, CriteriaOperator expression)
   bij DevExpress.Xpo.Helpers.PersistentCriterionExpander.Visit(OperandProperty theOriginalOperand)
   bij DevExpress.Xpo.Helpers.PersistentCriterionExpander.Expand(XPClassInfo[] upLevels, IPersistentValueExtractor persistentValuesSource, CriteriaOperator op, Boolean doDetectPostProcessing)
   bij DevExpress.Xpo.Helpers.XpoServerModeCore.ExtractExpression(CriteriaOperator input)
   bij DevExpress.Data.Helpers.ServerModeCore.Convert(ICollection`1 original, Int32 groupCount)
   bij DevExpress.Data.Helpers.ServerModeCore.Apply(CriteriaOperator filterCriteria, ICollection`1 sortInfo, Int32 groupCount, ICollection`1 summaryInfo, ICollection`1 totalSummaryInfo)
   bij DevExpress.Xpo.Helpers.XpoServerCollectionAdderRemover.Apply(CriteriaOperator filterCriteria, ICollection`1 sortInfo, Int32 groupCount, ICollection`1 summaryInfo, ICollection`1 totalSummaryInfo)
   bij DevExpress.Data.ServerModeDataController.DoSortRows()
   bij DevExpress.Data.DataController.OnRefresh(Boolean useRowsKeeper)
   bij DevExpress.Data.DataController.DoRefreshCore(Boolean useRowsKeeper)
   bij DevExpress.Data.DataController.DoRefresh(Boolean useRowsKeeper)
   bij DevExpress.Data.DataController.DoSortGroupRefresh()
   bij DevExpress.Data.DataController.EndUpdateCore(Boolean sortUpdate)
   bij DevExpress.XtraGrid.Views.Base.ColumnView.EndDataUpdateCore(Boolean sortOnly)
   bij DevExpress.XtraGrid.Views.Base.ColumnView.DoMouseSortColumn(GridColumn column, Keys key)
   bij DevExpress.XtraGrid.Views.Grid.Handler.GridHandler.DoMouseSortColumn(GridColumn column, Keys key)
   bij DevExpress.XtraGrid.Views.Grid.Handler.GridHandler.DoClickAction(BaseHitInfo hitInfo)
   bij DevExpress.XtraGrid.Views.Grid.Handler.GridHandler.OnMouseUp(MouseEventArgs ev)
   bij DevExpress.Utils.Controls.BaseHandler.ProcessEvent(EventType etype, Object args)
   bij DevExpress.XtraGrid.GridControl.OnMouseUp(MouseEventArgs ev)
   bij System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   bij System.Windows.Forms.Control.WndProc(Message& m)
   bij DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message& m)
   bij DevExpress.XtraGrid.GridControl.WndProc(Message& m)
   bij System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   bij System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   bij System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
   bij System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   bij System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   bij DevExpress.ExpressApp.Win.WinApplication.Start()

When I remove the [DefaultProperty("Number")] attribute from the Order class, the column is no longer sortable.
When I edit the alias of the Order Property like this: [PersistentAlias("[InvoiceRules].Min([OrderRuleConnection.OrderRule.Order.Number])")]  everything works fine, except I can't Ctrl+click the column to go to the order, but the column is sortable and searchable.

Can I get the column to point to the Order so that I can Ctrl+Click the column and so that I can sort and search it?

Thanks,
Jacob

Comments (3)
DevExpress Support Team 8 years ago

    Hello Jacob,

    From your description it is not enough clear what business classes structure you are using, and thus it is difficult for us to reproduce the problematic behavior on our side. Please provide us with a small example project with which we can reproduce this behavior and give you a precise answer.

    J J
    Jacob de Boer © 8 years ago

      Hi Anton

      I've attached a sample project. The zip also contains a database. If you run this application with this database the application will crash on startup with the exception I posted in my question. If you change the Order.cs file and remove the [DefaultProperty("Number")] attribute from the Order class, the application will start. Please let me know if I am doing something wrong here.

      Thanks,
      Jacob

      Dennis Garavsky (DevExpress) 8 years ago

        Hello Jacob,

        Thanks for your update. We need some additional time to work on your inquiry. Please bear with us.

        Sign in to comment on this post

        Answers approved by DevExpress Support

        created 8 years ago (modified 8 years ago)

        Hello Jacob,

        Unfortunately, the use of nested properties inside the Min and Max functions is not supported by the PersistentAlias attribute. It can work only with the Single function. [PersistentAlias("[InvoiceRules].Min([OrderRuleConnection.OrderRule.Order.Number])")] works fine because the Number property is placed inside the PersistentAlias attribute.

          Show previous comments (2)
          DevExpress Support Team 8 years ago

            Hello Jacob,

            You can use the Single operator only when the collection has either 1 or 0 elements. Otherwise the duplication of entries leads to the exception. Currently I can only suggest you use [PersistentAlias("[InvoiceRules].Min([OrderRuleConnection.OrderRule.Order.Number])")] as a workaround.

            J J
            Jacob de Boer © 8 years ago

              Hi Anton

              Your answer is clear. The workaround is not suitable because I lose the CTRL+SHIFT+Click capability. But thanks anyway.

              Jacob

              DevExpress Support Team 8 years ago

                You are welcome.

                Sign in to comment on this post

                Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

                Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.