Bug in the Saleslogix Web LiveGrid Lookup dialog

I recently ran into an issue with the Opportunity Products grid in the Saleslogix web client.  I client had requested additional columns in the “Add” Lookup dialog.  I had added the Price column as a field in the Lookup Columns collection.  I could see that the constructed OpportunityProducts.js file contained my Price column markup when it was deployed.  However, the column was not displaying in the Lookup result set.  The Lookup by Field drop down did have my field, and I was able to filter by my field, I just could not see the column in the results grid.

It turns out the constructor that generates the OpportunityProduct.js file adds a style attribute to numeric column data types.  You can see the markup it generates here:

    name: OpportunityProductslueProduct_Strings[‘lueProduct_LookupProperties_Price_PropertyHeader’]  || ‘Price’,
    field: ‘Price’,
    propertyType: ‘System.Decimal’,
        styles: ‘text-align: right’,
        excludeFromFilters: false,         
        width: 9,
    formatter: function (value, rowIdx, grid) {
                return Sage.Utility.SDataLookup.childObjectFormatter({
                    value: value, rowIdx: rowIdx, grid: grid,
                    fieldName: ‘Price’,
                            includeButton: false,
                        childentity: ‘PackageKitChildViews’
                });
           },
    sortable: true

It turns out that that style attribute is what was preventing the column from displaying.  Changing the deployed js file to this code, allowed the field to show:

    name: OpportunityProductslueProduct_Strings[‘lueProduct_LookupProperties_Price_PropertyHeader’]  || ‘Price’,
    field: ‘Price’,
    propertyType: ‘System.Decimal’,
        //styles: ‘text-align: right’,
        excludeFromFilters: false,         
        width: 9,
    formatter: function (value, rowIdx, grid) {
                return Sage.Utility.SDataLookup.childObjectFormatter({
                    value: value, rowIdx: rowIdx, grid: grid,
                    fieldName: ‘Price’,
                            includeButton: false,
                        childentity: ‘PackageKitChildViews’
                });
           },
    sortable: true

Unfortunately this is not a very feasible solution as it requires modifying the deployed js file after each deployment.  I will be contacting Saleslogix support to report this as a bug to hopefully allow these types of fields to show.

ABOUT THE AUTHOR

Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!