Jasper Ideas

Accept Comma-Separated List in Filter

Currently, in the ad hoc editor, when you create a filter based on a string you can only enter a single value (the "equals" operator) or select multiple values from a list (the "is one of" operator). We are looking to be able to enter a list of values separated by commas. For example, if the filter is set to the "equals" operator, we want to be able to enter a value such as: AB, BC, CD, DE, EF, FG, GH, HI, IJ.


While we can manually select all of the values using the "is one of" filter, that can be extremely time consuming depending on how many values need to be selected.

  • Guest
  • Oct 19 2022
  • Under consideration
Components JasperReports Server, AdHoc, Filters
  • Attach files
  • Timo Neisho commented
    20 Oct, 2023 06:07am

    Any news when will this be available?

  • Admin
    Damayanti Anand commented
    9 Jan, 2023 11:16am

    Thank you for you idea. We will consider it as an enhancement request.

  • Anil Kumar Madan commented
    29 Nov, 2022 02:10pm

    This should accept the values separated by new line character as well. in this way, we can copy the values from excel and paste in filter. like below.

    235098829

    235098830

    235098831

    235098832

    237242419

    237242420

    237242421

    237242422

    237242423

    237242424

    237242425

    237242426

    237242427

    237242428

    237242429

    237242430