Referencing label column of table from EnumList Ref column in a different table

[Wallace_Service]

If I have an EnumList Ref column and I call out the Ref column in a report using the format of <<[RefColumn]>>, it will print the list of the appropriate values from the key column of the referenced table. I understand that part. But what if I instead want to print the values of the label column of the referenced table? If I use a list deference such as [RefColumn][OtherTableLabelColumn], that field in my report just shows up blank. Why is that?

[Aleksi]

Try with dot… [RefColumn].[OtherTableLabelColumn]

[Wallace_Service]

HI @Aleksi, that works fine for me if I make the column a Ref but as soon as I change to an EnumList Ref, I get this message:

Attachment template. Expression ‘[Assigned to].[_ComputedName]’ is invalid due to: Column Assigned to in expression ‘[Assigned to].[_ComputedName]’ does not contain a reference."

Thanks!

[Steve]

Wallace_Service:

If I use a list deference such as [RefColumn][OtherTableLabelColumn], that field in my report just shows up blank.

This should work, assuming that dereference is wrapped in <<, >>. Was it? Perhaps post a screenshot of the template?

[Aleksi]

Sorry… didn’t realize you were using Enumlist. As Steve said, it should create a list of values if you have values in that column.

[Wallace_Service]

Hi @Steve and @Aleksi, I got busy and left this for a day and it seems to be working fine now using the list deference. It did have the <<>> brackets initially so I’m not entirely certain what changed but I’ll take it as a win! Thanks for the help!

[Rene_Casana_Ama]

Having the same problem

This is the error from the monitor

this is the list of values from the column **[caso_atenciones]** on the monitor result, if I leave it like this: <<[caso_atenciones]>> in the report will appear just the key values PAP, ASL. but I want the result to be the labels of that enum list concatenated, like this: Primeros Auxilios Psicológicos, Atención en Salud

I tried <<CONCATENATE(LIST([caso_atenciones]).[attention])>> but it gave me the same result as <<[caso_atenciones]>>

And I also tried:

[caso_atenciones] is EnumList type Ref to another table

[Marc_Dillon]

As mentioned above, you should be using a “list dereference”.

<<[caso_atenciones][attention]>>

Without the dot in the middle.

[Rene_Casana_Ama]

Now I get it, thank you very much.

It worked as intended.