nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Expression builder and 'in list' or 'in array'?

Max Bo

Hi, Is it somehow possible to use the expression builder for a data aggregatin filter like this: dataSetRow["status"] in Array('good', 'excellent') or dataSetRow["status"] in list('good', 'excellent') So far none of the two above seems to work

Max

Find more posts tagged with

Comments

BRM

You might have a look at this post <a data-ipb='nomediaparse' href='http://www.birt-exchange.org/forum/index.php?/topic/30341-visible-if-stringx-contains-specific-text/?hl=indexof#entry120742'>http://www.birt-exchange.org/forum/index.php?/topic/30341-visible-if-stringx-contains-specific-text/?hl=indexof#entry120742</a>

Max Bo

Thanks, but that is not really, what I am looking for. I am looking for the Expression buiilder equivalent of SELECT articleFROM article_tableWHERE status in ('used', 'good', 'perfect') So far I have worked in the expression builder with a construction like this dataSetRow["status"] == 'used' ||dataSetRow["status"] == 'good' ||dataSetRow["status"] == 'perfect' Max

BRM

Javascript doesn't support that syntax though. You might also look at this... <a data-ipb='nomediaparse' href='http://stackoverflow.com/questions/237104/array-containsobj-in-javascript'>http://stackoverflow.com/questions/237104/array-containsobj-in-javascript</a> If it is something that you will use a lot you could write your own custom function that supports the syntax you are after.

CBR

RhinoScript is a implementation of JavaScript entirely written in Java. This means that you could also use Java in your RhinoScript expressions. This means that you could also write an expression like that:Define a global variable at some point in your report, the best place is probably the beforeFactory event of the report:<pre class="_prettyXprint _linenums:0">filterList = new java.util.ArrayList();filterList.add("used")filterList.add("good")filterList.add("perfect")</pre>After defining the global variable you could use it in any expression. The ArrayList class defines a method contains that will return true if the given string is in that list, otherwise it will return false. So your filter expression will look like that:<pre class="_prettyXprint _linenums:0">filterList.contains(dataSetRow["status"])</pre>