IT Process Automation

  • 1.  IRF - Form Limit

    Posted Mar 20, 2015 11:15 AM

    Hi,

     

    I have a select box in Service Catalog that are filled with the result of a query. I also have a similar select box with the same values in PAM. We are talking about a query with about 30000 results.
    In Service Catalog the query runs normally (a little bit slow but we can handle it) but in the PAM IRF the select box doesn't show the values.
    I have tried a top 5000 and it works correctly, with a top 10000 is very slow and with all values is unusable.

     

    Anyone knows about the limitation of the IRF in PAM and how to work around this?

     

    Regards,
    Sergio Castro



  • 2.  Re: IRF - Form Limit

    Posted Mar 31, 2015 12:21 PM

    Can anyone help Sergio?

     

    Thanks

     

    IRF - Form Limit

    This question is Not Answered.(Mark as assumed answered)

     

    Hi,

     

    I have a select box in Service Catalog that are filled with the result of a query. I also have a similar select box with the same values in PAM. We are talking about a query with about 30000 results.
    In Service Catalog the query runs normally (a little bit slow but we can handle it) but in the PAM IRF the select box doesn't show the values.
    I have tried a top 5000 and it works correctly, with a top 10000 is very slow and with all values is unusable.

     

    Anyone knows about the limitation of the IRF in PAM and how to work around this?

     

    Regards,
    Sergio Castro



  • 3.  Re: IRF - Form Limit

    Posted Mar 31, 2015 11:00 PM

    Hi Sergio,

    I'm not sure why you need to populate over 10 000 results. Better solution is run more specific SQL query to get exact results. Try run SQL query by calling JavaScript after your form is already loaded via for example onClick event and as input variable that can narrow your results you can use a value from some text field.

    Milan