Impossible to select data with "not in id" (dropdown ajax entities list)

[Didou12]

Hi

I would like to use a record from entity (with ajax entities list) in the record itself but without the possibility to select the id of this current record (if the editing form is opened, all records but not the current).

So I tried with a condition (several times, see below), but it doesn't work.

Code: Select all

e.id not in (id)
e.id <> id

with id, or [id] or msq.id

How to do that ?

[karahan]

Hi,

sounds stupid, but:
e.id <> e.id

[support]

When you create new record, the form opens, but there is no record ID that is why you can't use it in condition.

[Didou12]

Ok thanks but when editing ? It’s more for editing I would like to filter out.