Gathering data in a list box in the UI

[#1]

Hi everyone !

I've a little question about a function that could allow me to "gather" multiple data types into one

Explainations :

I've a database with  a lot of "subtypes", like this :

Type1-Subtype1 | x35

Type1-Subtype2 | x60

Type1-Subtype3 | x11

...

I'm displaying all this list in a Filter Pane but I would like to gather those datas just like this :

Type1 | x106 (for example)

Is there any function to do that ?

Thanks in advance !

Regards !

Fred'

[sunny_talwar]

Gather this information where? Not sure I understand the purpose?

[maxgro]

like this?

load

  field,

  SubField(field, '-', 1) & ' | ' & SubField(field, '|', -1) as newfield

Inline [

field

Type1-Subtype1 | x35

Type1-Subtype2 | x60

Type1-Subtype3 | x11

];

[#4]

Hi guys !

It looks like the example of maxgro but I would like to add all datas together ( Type1 = 106 for example).

BTW I want to "gather" those information in the display in the Filter Pane from the GUI.
But of course I can do something during the load of the datas.

And ... sorry for my English x)

Fred'