Trying to add a column to a selector that will use a BQL query to get a sum from another table

Question

On the Subcontracts screen I want to add a custom column to the Project ID selector.

The value will come from the Details tab of the Projects screen (sum of Revised Budget Total)

I’ve tried numerous ways to do this. This is what I am trying at the moment. I am simply trying to put a dummy string into the custom column as a proof of concept before doing any BQL selects at this point.

namespace PX.Objects.PO
{
   [PXNonInstantiatedExtension]
   public sealed class PO_POLine_ExistingColumn : PXCacheExtension<PX.Objects.PO.POLine>
   {
       public static bool IsActive() => true;

       #region ProjectID
       [PXMergeAttributes(Method = MergeMethod.Append)]
       [PXCustomizeSelectorColumns(
           typeof(POLine.alternateID),
           typeof(USRBudgetTotalExt.usrBudgetTotal))]
       public int? ProjectID { get; set; }
       #endregion
   }

   public sealed class USRBudgetTotalExt : PXCacheExtension<PX.Objects.PO.POLine>
   {
       public static bool IsActive() => true;

       #region UsrBudgetTotal
       public abstract class usrBudgetTotal : PX.Data.BQL.BqlString.Field<usrBudgetTotal> { }
       protected string _UsrBudgetTotal;
       [PXString(20)]
       [PXUnboundDefault(PersistingCheck = PXPersistingCheck.Nothing)]
       [PXUIField(DisplayName = "Budget Total2", Visibility = PXUIVisibility.SelectorVisible, Visible = true)]
       public string UsrBudgetTotal
       {
           get
           {
               try
               {
                   return "Budget Total";
               }
               catch
               {
                   return "JoeError";
               }
           }
           set
           {
               this._UsrBudgetTotal = value;
           }
       }
       #endregion

#region Event Handlers

#endregion
}

}

This code has some effect on the selector. It does not show either of the two columns I am adding, and it actually removes some of the default columns like Customer and Status. It also changes the order of the fields.

My next thought was to completely override the selector for the Project ID field. But I cannot find the actual select statement for that field.

is this even possible to add a custom column that is an aggregate of another table based on the current line of the selector?
If it is possible, any suggestions on the approach I should take
Can anyone tell me how to get the select statement if I need to override it? In the code repository, the selector is based on an attribute which I cannot seem to find the source.

Joe Schmucker · Accepted Answer

Update. I’m able to add my column to the selector. I’ve got one other issue but I am going to submit that issue in another topic.

Here is the code I ended up with to get my custom field to show up in the selector.

Note that my USRBudgetTotalExt2 is hardcoded to return 100, but that is another issue.

namespace PX.Objects.PO
{
   //[PXNonInstantiatedExtension]
   public class PO_POLine_ExistingColumn : PXCacheExtension<PX.Objects.PO.POLine>
   {
       public static bool IsActive() => true;

       #region ProjectID
       [PXMergeAttributes(Method = MergeMethod.Append)]
       [PXCustomizeSelectorColumns(
           typeof(PX.Objects.PM.PMProject.contractCD),
           typeof(PX.Objects.PM.PMProject.description),
           typeof(USRBudgetTotalExt2.usrBudgetTotal),
           typeof(PX.Objects.PM.PMProject.status),
           typeof(PX.Objects.PM.PMProject.customerID),
           typeof(PX.Objects.AR.Customer.acctName),
           typeof(PX.Objects.PM.PMProject.curyID))]
       public int? ProjectID { get; set; }
       #endregion

}

   public sealed class USRBudgetTotalExt2 : PXCacheExtension<PX.Objects.CT.Contract>
   {
       public static bool IsActive() => true;

       #region UsrBudgetTotal
       public abstract class usrBudgetTotal : PX.Data.BQL.BqlDecimal.Field<usrBudgetTotal> { }
       protected decimal? _UsrBudgetTotal;
       [PXDecimal]
       [PXUnboundDefault(PersistingCheck = PXPersistingCheck.Nothing)]
       [PXUIField(DisplayName = "Budget Total", Visibility = PXUIVisibility.SelectorVisible, Visible = true)]
       public decimal? UsrBudgetTotal
       {
           get
           {
               try
               {
                   //PMBudget budget = SelectFrom<PMBudget>
                   //       .Where<PMBudget.projectID.IsEqual<PMProject.contractID.FromCurrent>>
                   //       .AggregateTo<GroupBy<PMBudget.projectID>, Sum<PMBudget.curyRevisedAmount>>.View.Select(this);

                   return 100;
               }
               catch
               {
                   return 0;
               }
           }
           set
           {
               this._UsrBudgetTotal = value;
           }
       }
       #endregion

#region Event Handlers

#endregion
}

Chris Hackett · Answer

Thank you for sharing your solution with the community @Joe Schmucker!

Trying to add a column to a selector that will use a BQL query to get a sum from another table

2 replies

Reply

Most helpful members this week

Cookie policy

Cookie settings

Reply

Related topics

Participants to be shown voucher codes, each code can be displayed only onceicon

Testing Javascript randomization using Automatic Test Responses doesn't work —is there a better way?

Remove duplicate text entries to display only one in the side by side questionicon

Issue with javascript randomization logic when trying to assign people to groupsicon

Most helpful members this week

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded

Cookie policy

Cookie settings