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

Issue with Product Name in SLX Mobile3.0 portal

Hi All,

 

I am in process of migrating saleslogix from 7.1 LAN to 8.1 web and mobile. While cheking mobile, it has been been observed that, system is not allowing us to select Opportunity ->Product->Price level if the product name contains " in the product name.

 

For selecting price level, system fires following query for the product having name "10"KSE-100-6T",

 

http://172.16.11.24:3333/sdata/slx/dynamic/-/productPrograms?_includeContent=false&count=20&startInd...

 

and it throws an server error. If you execute the url it throws the following error,

 

[ { "severity": "Error", "sdataCode": "ApplicationDiagnosis", "applicationCode": "source=SDataExceptionDiagnoses; exceptionKind=BaseException; exceptionSource=Sage.Common.Syndication; exceptionType=System.ArgumentException; slxErrorId=SLXA8508F37EBB004D6", "message": "Badly formed expression Product.Name eq \"10\"KSE-100-6T\" - expecting \"EOF\", found 'KSE'.", "stackTrace": " at Sage.Common.Syndication.UriPathSegment.ParseExpression(String expression)\r\n at Sage.Common.Syndication.SDataUri.get_WhereExpression()\r\n at Sage.Platform.SData.RequestHandlerBase`3.GetEntities(SDataUri uri, Int64& totalResults, Int32& startIndex, Int32& itemsPerPage)\r\n at Sage.Platform.SData.RequestHandlerBase`3.InternalGet()\r\n at Invoked0ef15ff6dcd4793a625e28345619060.Invoke(Object , IRequest )\r\n at Sage.Integration.Messaging.RequestTargetRegistration.RequestTargetInvoker.Invoke(IRequest request)\r\n at Sage.Integration.Messaging.Request.Process(RequestTargetInvoker invoker)\r\n at Sage.Integration.Adapter.AdapterController.RealAdapterController.Process(IRequest request)\r\n at Sage.Integration.Adapter.AdapterController.RealAdapterController.ProcessWorker(IProtocolRequest protocolRequest)\r\n at Sage.Integration.Adapter.AdapterController.Process(IProtocolRequest request)\r\n at Sage.Integration.Messaging.MessagingService.Process(IProtocolRequest protocolRequest)", "payloadPath": "" } ]

 

 

Can any one suggest ho to handle the situation.

 

Thanks in Advance

Malay

 

 

Highlighted
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Issue with Product Name in SLX Mobile3.0 portal

First thing is you need to drop the 3.0 and load up the 3.0.3 - it's the latest released mobility and you can get it from the partner site.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Highlighted
Nickel Elite Contributor
Posts: 86
Registered: ‎10-21-2009

Re: Issue with Product Name in SLX Mobile3.0 portal

Hello RJ,

 

Tried with SLX Mobile 3.0.3 as well. No luck, same result.

 

Thanks

Malay

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

Re: Issue with Product Name in SLX Mobile3.0 portal

Hi All,

 

Please find the solution here under. The issue is related to the formating of the escape charecter in where clause of the program lookup in Edit.js of Opportunity_Product view.

 

Replace where clause to,

return string.substitute('Product.Name like "${0}%"', [(val.Name || '').replace(/"/g, '""')]);

 

Thanks

Malay

 

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

Re: Issue with Product Name in SLX Mobile3.0 portal

Thanks for the fix Malay! We provide this functionality in our base List.js as a function called escapeSearchQuery (https://github.com/Saleslogix/argos-sdk/blob/3.0.x/src/List.js#L1167). Unfortunately it appears as if this logic was not applied to all view types. QA is creating a defect for this issue, and we will have it resolved in our next release (the "develop" branch in github).