Page 1 of 1

Local Storage Variable not working on where database query.

Posted: Tue Mar 15, 2016 9:16 pm
by CarmeloMilian

Truing to fill the "where" in a database query.

The database collection columns is LeadID
I replace the localStorage.LeadID('text') for the actual LeadID number to test and it works. I need to use the local storage variable instead. The local variable is working, I can see it on the Browser tools with its value.

This is what I am entering in the where field

{'LeadID':'localStorage.LeadID('text')'}

HELP!!!!!! Image


Local Storage Variable not working on where database query.

Posted: Tue Mar 15, 2016 10:13 pm
by Illya Stepanov

Hello -

Just use mapping binding from your Storage value "LeadID" to where field on the right side.


Local Storage Variable not working on where database query.

Posted: Wed Mar 16, 2016 2:19 am
by CarmeloMilian

That does not work :(

How do I change the status of my question to unanswered?


Local Storage Variable not working on where database query.

Posted: Wed Mar 16, 2016 5:57 pm
by CarmeloMilian

This did not solve the issue, can you mark it as unanswered to see if I can get more help? thanks.


Local Storage Variable not working on where database query.

Posted: Thu Mar 17, 2016 11:21 am
by Serhii Kulibaba

Hello,

Text, which you use on the screenshot above is sent to the server as a plain text.
1) Remove all that text from the mapping
2) Add mapping arrow from the storage variable LeadID to the parameter "where"
3) Add JS code below to that mapping
prereturn {LeadID: value};/pre

Image


Local Storage Variable not working on where database query.

Posted: Thu Mar 17, 2016 2:12 pm
by CarmeloMilian

You Rock!