data-where in a element

[nicolapiva]

Hi
I have this question:
in a element, in data-where option, where I can write SQL code, I want to create a particular filter for which I need the general reference to a single record. I want to filter the records I can see, also keeping in mind the record I am modifing.
Thanks a lot for your preciuos and steady help. I hope I was clear.

 

[cheesegrits]

You can use element placeholders, like ...

WHERE {thistable}.something = '{yourtable___yourelement}'

Leave {thistable} as-is, that gets replaced with the alias in use for the table you are joining to.

-- hugh