Adding multiple Filter conditions on a dataMaster Modify action

Vivek Anand shared this question 6 years ago
Answered

Hello JustInMind!


How to update a datat master with two filter conditions? the brackets in filter Box do not allow me to place "&" for adding another condition. Any help?


For example:


SQL : Update table set status=5 where id=1 & code =1 .


I would like to do the same in the prototyper dataset. Please help

Comments (7)

photo
1

Hi Vivek,


The expression looks pretty much as your SQL statement:


0017e3075f2da826a3b5cbe91a7500fe

photo
1

Yeah it works! :)


Thanks a lot for the quick reply.


The brackets were little bit confusing as we add up more conditions. My suggestion would be to stack the filters with & rather than adding them on the single line.


Like:


2181c769a209d5d0cd1c69a4d27b2f70


just a thought.


btw, JIMP is a great tool :) everybody here likes it!

photo
1

Even though this distribution is more readable it takes up a lot of valuable space. An expert mode where you simply write these expressions is a better option:


6a973cc5b71c472a7a659e89fdfa2742


PS: with what program do you think i took this screenshot :-)

photo
1

Yeah I actually tried to find something called "Justinmind prototyper scripts" in google. :)


This expert mode looks almost like a script, but how I can hand edit the text?


When I try to edit the text, it takes me again to the drag-blocks screen.


PSR: MS Snipping tool?

photo
1

so far it's for visualization only. an expert editing mode would be a nice feature.


PSR(R?): Gimp!

photo
1

PSR -> (R)eply to your PS! :)

photo
1

Thanks for the help Burk! Completing my proto works now :)