Reporting on custom statuses used by group

[skyehansen]

I'm trying to report on custom statuses that are being used by different groups, and getting poor results. Can anyone help? This is the only textmode that works in a View:

displayname=Custom Statuses

listdelimiter=,

listmethod=nested(customEnums).lists

textmode=true

type=iterate

valuefield=value

valueformat=HTML

i.e.: only valuefields work, and I can't make even the simplest valueexpression work (e.g. valueexpression=value doesn't work)

For filters, nothing seems to work (two samples of failed code below)

EXISTS:1:$$OBJCODE=CSTEM

EXISTS:1:groupID=FIELD:ID

EXISTS:1:value=PLN

(I shouldn't have had to use an exists statement -- the collections filter should have been fine)

customEnums:value=PLN

customEnums:value_Mod=in

(I also tried cicontains)

We already have a workaround, so I didn't feel like spending a long time banging my head against this but whhhhhy does it not work?

[AnthonyIm · Accepted solution]

Hi Skye -

I couldn't get value to work, but I did get Equates With. Do you have a lot of statuses that equate with PLN?

displayname=Custom Statuses

listdelimiter=<br>

listmethod=nested(customEnums).lists

textmode=true

type=iterate

valueexpression=IF({equatesWith}="PLN",{label},"")

valueformat=HTML

[skyehansen]

thanks Anthony! I wanted to drill down to a specific status. It equates to CUR and yeah... we have a lot that do that! Thank you though, equates with does get me closer, but I'll keep trying! At least I know valueexpressions do work and I just have to keep plugging away at it!

[skyehansen]

Oops, spoke too soon! This is close enough (for me) -- value would def. be better of course, but I think we're pretty stringent with naming 🙂

displayname=Custom Statuses

listdelimiter=<br>

listmethod=nested(customEnums).lists

textmode=true

type=iterate

valueexpression=IF({label}="Special Custom Status Name",{label},"")

valueformat=HTML

[skyehansen]

@Anthony Imgrund‚ happy ending! I got the valueAsString to work instead of value! (I guess that makes sense when you look at the name of that!]

customEnums:valueAsString=[your key goes here]

customEnums:valueAsString_Mod=in

[Christina_Jarosz]

What kind of report would you put this text mode in?

[RhondaEntXLComm]

Hi, Christina, you can add the column in a report on Groups or a custom view of Groups.