5 Replies Latest reply: Oct 11, 2012 8:10 PM by user1022639 RSS

    ViewObject LOV query is executing again and again..

      Hi Experts,

      Currently in my application VO has one LOV component

      DeparmentVO - countryID (LOV) pointing to the CountryVO

      Where CountryVO is a query based and it depends on the user session language "Select countryID, country from Counties where language=:language

      Now application works fine, however whenever the user launched the page the countryVO query is executed again and again and it is not cached. In the DeparmentVO view accessor the is there any way we can specify the CountryVO to be taken fro cache? Or is there any configuration that we need to do inorder to run the country query only once per session?

      Looking forward you advice on this.