Peter Viglietta
Posts: 0
Joined: Sat Jul 05, 2014 6:22 pm

Update service using 'whereobject'?

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

Peter Viglietta
Posts: 0
Joined: Sat Jul 05, 2014 6:22 pm

Update service using 'whereobject'?

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.

Alena Prykhodko
Posts: 0
Joined: Tue Apr 09, 2013 7:36 am

Update service using 'whereobject'?

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

Return to “Issues”