Hi all,
I want to customize following view to filter SOOrders with Open Status. How can I do that?
public PXSelectJoin<SOOrder,LeftJoin<Users, On<Users.pKID, Equal<SOOrder.createdByID>>, LeftJoin<SOOrderType, On<SOOrderType.orderType, Equal<SOOrder.orderType>>, LeftJoin<PX.Objects.GL.Branch, On<PX.Objects.GL.Branch.branchID, Equal<SOOrder.branchID>>, LeftJoin<Organization, On<Organization.organizationID, Equal<PX.Objects.GL.Branch.organizationID>, Or<Organization.organizationID, IsNull>>, LeftJoin<PortalSetup, On2<Where<PortalSetup.restrictByOrganizationID, IsNull, Or<Organization.organizationID, Equal<PortalSetup.restrictByOrganizationID>>>, And<Where<PortalSetup.restrictByBranchID, IsNull, Or<PX.Objects.GL.Branch.branchID, Equal<PortalSetup.restrictByBranchID>>>>>>>>>>, Where2<MatchWithBAccount<SOOrder.customerID, Current<AccessInfo.userID>>, And<PortalSetup.IsCurrentPortal>>, OrderBy<Desc<SOOrder.orderNbr>>> Items;
Best answer by Fernando Amadoz
View original