IT Process Automation

  • 1.  how to populate drop down list from a sql table in IRF form

    Posted May 15, 2018 06:53 AM

    Hi Support

     

    we were developing  IRM form. There is requirement of putting a drop down list and content of the drop down to be coming from a sql table based on the select query . how this can be achieved in CA ITPAM tool.



  • 2.  Re: how to populate drop down list from a sql table in IRF form
    Best Answer

    Broadcom Employee
    Posted May 15, 2018 08:46 AM

    Please see the Out of the Box content for a specific example of how to accomplish this:

     

    If you do not have the out of the box content you can click the Browse Out-of-the-Box Content button on the home tab, or import the content found here:

    Out_of_the_Box Content / Predefined Processes.  



  • 3.  Re: how to populate drop down list from a sql table in IRF form

    Posted May 15, 2018 08:54 AM

    Michael,

     

    Ha!  Beat me to the draw while I was editing!

     

    J.W.



  • 4.  Re: how to populate drop down list from a sql table in IRF form

    Posted May 15, 2018 08:53 AM

    There is an example of this is the Pre-Defined Content.

     

    Library - Pre-Defined Content

     

    If that is not in your Library, then add it from the Home screen by selecting 'Browse Out-of-the-Box Content'

     

    Home Screen

     

    Also, check out this thread:

    AM 4.3.1 - IRF - Insert an empty element into a Select result

     

    J.W.



  • 5.  Re: how to populate drop down list from a sql table in IRF form

    Posted May 17, 2018 01:03 AM

    Need suggestion for the piece of code for connecting to Oracle database . with this below code we are not able to connect to Oracle database . pls suggest .

     


      
      driverName : function() {
     //change to your DB driver
     return 'oracle.jdbc.driver.OracleDriver';
     //return 'com.mysql.jdbc.Driver';
      },
     
      connectionURL : function() {
     //change to your DB JDBC URL
     return 'jdbc:oracle://<DB_HOstname>:1521;DatabaseName=<DB_NAME>';
     //return 'jdbc:mysql://<computername>:3306/<dbname>';
      },
     
      userName : function() {
     //change to your DB username
     return '<DB_Username>';
      },
     
      password : function() {
     //change to your DB password 
     return '<DB_Password>';
      },



  • 6.  Re: how to populate drop down list from a sql table in IRF form

    Posted May 24, 2018 10:32 AM

    Dambaru,

     

    I apologize for the late response. 

     

    The only thing I can recommend is to test all the parameters in a separate Oracle client - if you have not already.  Can you post the connection errors from from your <install directory>\Program Files\CA\PAM\server\c2o\log at time of testing?  Probably the keyword is 'jdbc'.  If no one here can assist further then I would open a support case with CA.

     

    J.W.