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

Hi,
but I use it also for ordering and I need
Primary order by Incident
Secondary order by District,
because when I have more items with the same Incident, I want to order it by District from west to east (as ascending values).

Hello

ordering via 2 ways is not implemented in current version

Hello,

yes I know and because of that I'm using 1 field for ordering.

So without that SQL query isn't possible to show only part of the label in Select list field in Category list view?

Hello

will add 2nd level ordering parameter, for v2.1.3 final (before 10th of Feb) you can test this earlier