Changing Where clause in Account List View in SLXMobile 3.0.3

[Malay_Mukherjee]

Hi All,

As per my requirement, I need to alter the contextual condition of the select query in listview while searcing an account.

I had tried adding additional column in select query and change the condition in where clause. but the changes are not being picked up.

querySelect: [
'AccountName',
'AccountManager/UserInfo/UserName',
'AccountManager/UserInfo/LastName',
'AccountManager/UserInfo/FirstName',
'Owner/OwnerDescription',
'MainPhone',
'WebAddress',
'Industry',
'LeadSource/Description',
'MainPhone',
'Fax',
'Status',
'SubType',
'Type',
'ModifyDate',
'ACCOUNT_HYDRO1/Plant'
],

formatSearchQuery: function(searchQuery) {
return string.substitute('AccountNameUpper like "${0}%" or Account_Hydro1.Plant like "${0}%")', [this.escapeSearchQuery(searchQuery.toUpperCase())]);
},

Please suggest.

Thanks

Malay

[jbest]

When you say the changes are not being picked up, do you mean only in the view? I would use your browsers network tab (under development tools) to inspect the "select" query string parameter being sent to the server.

Here is an example custom module that adds columns to the querySelect: https://github.com/Saleslogix/argos-sample/blob/master/src/ApplicationModule.js#L332

[Malay_Mukherjee · Accepted solution]

Hi All,

Cleaning build folder and slxmobile folder in inetpub has done the trick. Changes are been picked and things are been working fine.

Thanks

Malay