different value in edit form and in content list

Hi!

I'm using "select list" field for filtering and ordering my content in category list view with structure:
1::X 1%%
2::X 2%%
3::X 3%%
4::Y 1%%
5::Y 2%%
...

Is it possible to show only "X" instead of X 1/X 2/X 3 in category list view and still to show X 1/X 2/X 3 as an option to select in frontend edit form?

Thankyou.

Hello

so you want to have a (field) filter option "X" that would mach all items having any of the following values
"X 1"
"X 2"
"X 3"

-- this is possible only (by a developer)
by creating a (-NEW-) custom field type (e.g. try to duplicate the "select" field type),
How to Duplicate a Flexicontent Field to create a new Field Type

that will use custom SQL during filter matching, altering the field functions
getFiltered()
getFilteredSearch()

Regards

hello
I managed to create new field type, but I have not idea where and how to write that SQL query. Could you please help me more?

Hello

in your case i think it is easier to create 2 select fields

1. to select X or Y
2. to select X1, X2, X3, Y1, Y2, Y3

just not that now these 2 field cannot be chained automatically,

thus when you select X, you must take care not to select Y1, Y2, Y3 in the second field

it could be done so, but I'm doing the website for the traffic report, and I use Select field to choose and show Incident+District and the same field for ordering the list in the category list view. I would like to do it as simple as possible for frontend users and it would really help me if you could advise me with SQL query. All I want is to show only Incident from this field in category list view.

Thankyou very much

tarja wrote: it could be done so, but I'm doing the website for the traffic report, and I use Select field to choose and show Incident+District

Hello in this case you should use 2 fields !
1. one for incident
2. one for District