Help with Custom Column

[sifuhall]

I'm trying to create a custom column that contains the first (and only the first) entry in the tags field.

I've tried using this as the template:

{tags:subitems(0,1)}

But I get the full tag.

I also tried:

{list_item(tags, 0, ',') }

But that doesn't work either.

What am I doing wrong?

[chaley]

Subitems creates a list of hierarchical subitems. It does not isolate one entry in a list of entries. To isolate list entries, use list_item or sublist.

I think the following does what you are looking for.

{tags:'list_item($, 0, ',')'}

Note that the tags stored in the database are almost certainly not in alphabetical order, so the first tag may not be what you think it is. If you want the first item in the sorted list, use

{tags:'list_item(list_sort($, '0', ','), 0, ',')'}

BTW: your second attempt would work if you used

program: list_item(field('tags'), 0, ',')