CA Service Management

 View Only
  • 1.  Jasper Server - Input Controls, Multi select Query

    Posted Oct 19, 2017 09:10 AM

    Hi,

    How should I configure Input Controls - Multi-select Query?

    My configure:

    - Type: Multi-select Query

    - Name the Query: Userid

    - Link a Data Source: /organizations/servicemanagement/capability/datasources/sdm_ds

    - Define the Query: SELECT casd.cnt.userid FROM casd.cnt

    - Value Column: casd.cnt.userid (userid)

    Result = Blank list :-(

     

    Thanks

    Jan



  • 2.  Re: Jasper Server - Input Controls, Multi select Query

    Posted Oct 19, 2017 10:57 AM

    Hi Jan - are you doing this in Jasper Studio?

    Can you share a screenshot of how you have this set up?

    Thanks,

    Jon



  • 3.  Re: Jasper Server - Input Controls, Multi select Query

    Posted Oct 19, 2017 11:17 AM

    @Jon

     

    You defined the input control in Jasper Report Server.  In Studio (in the .jrxml) is where it is actually referenced.

     

    Cheers!

     

    Steve



  • 4.  Re: Jasper Server - Input Controls, Multi select Query

    Posted Oct 19, 2017 10:58 AM

    SteveTroy - do you have any possible insight on this one?



  • 5.  Re: Jasper Server - Input Controls, Multi select Query

    Posted Oct 19, 2017 11:12 AM

    Jan,

     

    Did you set the Visable Column?

     



  • 6.  Re: Jasper Server - Input Controls, Multi select Query

    Posted Oct 20, 2017 03:02 AM

    Hi Steve,

    yes, I set the Visible Column (attachments)



  • 7.  Re: Jasper Server - Input Controls, Multi select Query

    Posted Oct 20, 2017 10:03 AM

    Hi Jan, I just spoke with SteveTroy - he is going to do some testing on this a bit and will let you know if we can replicate the same behavior.



  • 8.  Re: Jasper Server - Input Controls, Multi select Query
    Best Answer

    Posted Oct 20, 2017 03:23 PM

    Jan,

     

    Prefixing the query string with casd.cnt was the culprit.

     

    Change the query to “select userid from cnt where userid is Not Null”

     

     

    And change the Value and Visible columns to userid

     

     

     

    And it should work for you.

     

     

     

    Regards,

     

    Steve



  • 9.  Re: Jasper Server - Input Controls, Multi select Query

    Posted Oct 21, 2017 05:08 PM

    Hi jan.pokorny - did SteveTroy's post help you out here?



  • 10.  Re: Jasper Server - Input Controls, Multi select Query

    Posted Oct 26, 2017 01:42 PM

    Hi Jon,

    Yes.

    Thanks