Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Nickel Elite Contributor
Posts: 86
Registered: ‎10-21-2009
Accepted Solution

Changing Where clause in Account List View in SLXMobile 3.0.3

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

 

 

Employee
Posts: 51
Registered: ‎12-16-2011

Re: Changing Where clause in Account List View in SLXMobile 3.0.3

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

 

Highlighted
Nickel Elite Contributor
Posts: 86
Registered: ‎10-21-2009

Re: Changing Where clause in Account List View in SLXMobile 3.0.3

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