Dynamic Labels and Clearing Item Cache
595239Nov 7 2007 — edited Nov 10 2007Hello All, I'm in urgent need of a couple solutions if possible. I've been working on a reporting application in which I've created numerous Cascading LOVs (Select Lists). I made it dynamic enough so that when the firs LOV is selected, it either will display the next dependent LOV or display a Date picker, based on the value returned in the first LOV. I've implemented this using the ApexLib Framework so that I do not submit the page after each LOV is selected. My first issue is that I'm able to succesfullly populate the next LOV with values from a database table, but at the same time, I want to grab the Label for that LOV from the table as well. I've tried creating a Hidden item for the label and using javascript, created an Application Process to populate that hidden item with the label with on onchange event, but I can't seem to get the label to display on the LOV's Label by using, for example, &HIDDEN_ITEM. I know the Application Process is working, but for some reason I'm unable to get it to show on the label elememt for the LOV, it is just blank. I've tried changing the Label Template as i've seen this approach on some posts, but that is not working either. Am I missing something on how to put the hidden item on the label of a select list item through javascript without submitting the page?
Another question I have is that I have up to 15 cascading select lists, one dependent on the prior. So everytime I select something from the dropdown, the next LOV will show up then I select from that one, the next will show and so forth and so on. I have a onchange event on each to show/hide the next LOV. So if i'm down to the 15th lov, then decide to start over with the a new value in the first, I have all the other 14 LOVs disappearing. My question is, is there a way to also clear the cache for those other 14 LOVs when I change the value of the first, again, without submitting the page?
Thanks in advance for your help!
Lou