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.

if I understand you, I think you could use a

@WHERE:PARAM:USER_DEF parameter and then "code" into the NSQL what that parameter "means";WHERE((@WHERE:PARAM:USER_DEF:INTEGER:my_parameter@ = 1AND my_calculated_range BETWEEN 0 AND 100 )OR(@WHERE:PARAM:USER_DEF:INTEGER:my_parameter@ = 2AND my_calculated_range BETWEEN 100 AND 200 )OR(@WHERE:PARAM:USER_DEF:INTEGER:my_parameter@ = 3AND my_calculated_range BETWEEN 200 AND 300 )... etc

)