AnsweredAssumed Answered

How to use a portlet parameter with a range

Question asked by urmas on Feb 21, 2017
Latest reply on Mar 7, 2017 by Dave_3.0

Say you have a calculated field which has color mapping for ranges.

You then put the field in an NSQL portlet.

How would you filter with that?

If it were in the content then you could  use Case statement and get the value (if the calculated values are not already calculated in a view).

A quick search for "parameter range" and "case parameter" did not give anything which I could have picked as useful.

 

Is it possible to build a @WHERE:PARAM:USER_DEF:INTEGER:my_caluclated_field... statement to work with the ranges?

Just using the field and selecting Value Range displays only All in the filter drop down.

And selecting color display all the colors in the system while only Green, Yellow and Red are in use.

Outcomes