Page 2 of 2

Update service using 'whereobject'?

Posted: Sat Jan 17, 2015 10:13 pm
by Peter Viglietta

I'm trying to make sense of this... I tried adding the update service parameters but I know it's incorrect. I understand that I need these parameters to say, essentially: "update IsRead to true for all rows were MessageThreadID = LSV MessageThreadID and SentToID = LSV CurrentUserID". Before I was trying to do that with custom JS code, but since the Update services don't have a 'Where' request parameter on the mapping screen, that's where I got lost. Can you take another look at this thread, and the screenshot of the new parameters I (tried) to add, and let me know if I'm on the right track? Thanks.

Image


Update service using 'whereobject'?

Posted: Sat Jan 17, 2015 10:54 pm
by Peter Viglietta

Hey Yurri, can you check out my post below? This thread was from a while ago. Any help you could give would be much appreciated.


Update service using 'whereobject'?

Posted: Tue Jan 20, 2015 8:32 am
by Alena Prykhodko

Hello,

1) Each $and clause part should be wrapped in brackets
2) Each column name should be wrapped in "
pre
where = {$and:[{"COL1":"VAL1"}, {"COL2":"VAL2"}]}/pre