Enable Filtering and Sorting for Unbound Custom Fields in Grid (AR402000)

How are you populating the unbound fields?

Hi ​@darylbowman,

Thanks for the prompt response.

I am populating fields from Comission Settings tab of Invoices and Memos screen.

I am fetching it by comparing invoice RefNbr of grid row to invoices and Memos screen and retrieving record from SalesPersonARTran DAC by BQL query.

I meant what event handler are you using?

Hi ​@darylbowman,

I am using RowSelected event of ARDocumentResult graph as below to fetch the Location.

 protected void ARDocumentResult_RowSelected(PXCache cache, PXRowSelectedEventArgs e)
        {

            var row = (ARDocumentResult)e.Row;
            //If the row is null, return
            if (row == null) return;
            //If the customer ID is not null
            if (row.RefNbr != null && (row.DocType == "INV" || row.DocType == "CRM"))
            {
                ARDocumentResultExt resultExt = row.GetExtension<ARDocumentResultExt>();


               resultExt.UsrLocationID = GetLocationID(row.RefNbr, row.DocType);
                resultExt.UsrLocation = GetLocationName(row.RefNbr, row.DocType);


            }
        }

My mistake in previous Comment, I am fetching location as below.
 

private string GetLocationID(string refNbr, string docType)
        {
            LocationID = "";
            ARRegister aRRegister = PXSelect<ARRegister, Where<ARRegister.refNbr, Equal<Required<ARRegister.refNbr>>, And<ARRegister.docType, Equal<Required<ARRegister.docType>>>>>.Select(this.Base, refNbr, docType);
            if (aRRegister != null)
            {
                if (aRRegister.CustomerLocationID != null)
                {
                    Location location = PXSelect<Location, Where<Location.locationID, Equal<Required<Location.locationID>>>>.Select(this.Base, aRRegister.CustomerLocationID);
                    if (location != null)
                    {
                        LocationID = location.LocationCD.Trim();
                    }
                }
            }
            return LocationID;
        }

I'm not saying this is THE problem, but using RowSelected for this sort of thing is highly discouraged.

If the rows are actually being selected from the database, RowSelectING would probably be a better option.

I'm not aware of any limitations of unbound fields when it comes to sorting and filtering.

​@darylbowman ,

Yes, I aware that using the RowSelected event for such purposes is not recommended. However, the code was initially written by another developer, and we've recently received a requirement to add filtering to these custom fields.

Thank you for your insights on this; I truly appreciate your time and assistance.
Is there anyone have some thoughts to share on limitations of unbound fields when it comes to sorting and filtering.
 

Hi ​@Dipak Nilkanth ,
      On unbound field instead of Rowselected event try with PXDBScalar.

Hi ​@noorula77, As I know, PXDBScaler attribute used to define a calculated field. The Custom fields I have those are Text fields populating Location ID and Description.
Thanks!

Hi ​@Dipak Nilkanth ,
  You can display text field data also using PXDBScaler.

Hi ​@noorula77,

Thank you for the code snippet. It worked for me. 

Appreciate your help on this.