AppointmentInqFilterExt Example

gistfile1.txt

public class AppointmentInqFilterExt : PXCacheExtension<PX.Objects.FS.AppointmentInq.AppointmentInqFilter>
  {  
    #region UsrStatus
    [PXString(1,IsFixed=true,IsUnicode = true)]
    [PXDefault(usrStatus.Values.NotStarted)]
    [usrStatus.Values.List]
    [PXUIField(DisplayName="Status")]
    public virtual string UsrStatus { get; set; }
      public abstract class usrStatus : PX.Data.BQL.BqlString.Field<usrStatus> {
    public abstract class Values : ListField.AppointmentStatus { }  }
    #endregion
  }
public class AppointmentInq_Extension : PXGraphExtension<AppointmentInq>
  {
    //The method for adding the custom filter
    private void FilterMore(ref BqlCommand query, AppointmentInqFilterExt filterExt)
    {
      if(filterExt.UsrStatus != null)
      {
         query = query.WhereAnd<Where<Current<AppointmentInqFilterExt.usrStatus>,
 Equal<FSAppointmentFSServiceOrder.status>>>();
      }
    }
    // The delegate for the DetailsView data view
    protected virtual IEnumerable appointments()
    {     
      int startRow = PXView.StartRow;
      int totalRows = 0;

      var filter = Base.Filter.Current;
      var filterExt = filter.GetExtension<AppointmentInqFilterExt>();
      BqlCommand query = Base.Appointments.View.BqlSelect;
      FilterMore(ref query, filterExt);
      PXView view = new PXView(Base,true,query);
      var list = view.Select(PXView.Currents, PXView.Parameters, PXView.Searches,
          PXView.SortColumns, PXView.Descendings, PXView.Filters,ref startRow,PXView.MaximumRows,ref totalRows);
    PXView.StartRow = 0;
      return list;
    }
  }