Parameters for select list field

Hello,

Im trying to create a select list field with an a sql statement. In my statement i want to exclude value that the field currently having. For example, if i have a select with a list of cities, and current field has value of Spain, then the select statement should exclude Spain from select. How can it be achieved ?
p.s. - i know there are some parameters that we can use in sql statement like: {item->catid}
so i tried to use {field->value} but the problem is that it returned array and so my final sql looked like
"...where city != Array".
Unfortunalty i was unable to find any documentation about all the possible options, except few that displayed in the tooltip description.

Appreciate any help,

Hello

this function exists, but it is only called in the prefix / suffix

you could try editing file
component/com_flexicontent/classes/flexicontent.fields.php

and Just above of:

Add this line:

-- Read the popup HELP of HEADER "Prefix - Suffix - Separator"
(Go mouse over the HEADER line)

it describes field replacements in prefix/suffix/opentag/closetag

-- and use them inside your SQL query too

-- test


Regards