I want to pass parameters to a web service as an array. The code snippet will thereafter be modified such that the parameters are supplied by SharePoint
Please use link below to follow my sample work in github
dmuthami/multipleParameterQuery · GitHub
My Question.?
Is my implementation the best way to go about it or their are other ways that are efficient in terms of speed.?
Kindly advise.
Solved! Go to Solution.
Hi David,
I would recommend having one in clause over multiple or clauses. Replace your build where clause section with below line.
if (erven.length > 0) {
var myWhere = local_Authority_Prefix + "_erf_no in ('" + erven.join("','") + "')";
}
Hi David,
I would recommend having one in clause over multiple or clauses. Replace your build where clause section with below line.
if (erven.length > 0) {
var myWhere = local_Authority_Prefix + "_erf_no in ('" + erven.join("','") + "')";
}
Hi Deen,
Your response is valuable and amazingly correct. I have gone ahead and included proposed changes and the revised code can be accessed from below link in github