Reporting on custom statuses used by group | Community
Skip to main content
skyehansen
Community Advisor
Community Advisor
June 25, 2021
Solved

Reporting on custom statuses used by group

  • June 25, 2021
  • 1 reply
  • 1407 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by imgrund

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

1 reply

imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
Adobe Employee
June 28, 2021

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
Community Advisor
Community Advisor
June 28, 2021

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!