I've got a report with two lov's, where the user is able to change the lov value and submit it. After submit the status of the item P100_status will be changed in Disable. Based on this value the lov's must be disables with apex_disabled.
How can I disable these columns based on the value of P100_status?
What version of Apex?
While I was testing 1ef posted the solution I wanted to suggest - using a dynamic action. I got it to work after some tweaking the values but was mirroring the report columns with page items.
Specifically I had a form with a field ":P3_ARTIST". I created a dynamic action disabling a bunch of fields if the artist = 'Error' which indicates the record is an error and should be otherwise ignored. I was able to disable the fields when "P3_ARTIST" (have to use quotes to avoid a smiley face!) = 'ERROR' but had to leave the single quotes off the definition. Also tried an IN LIST to add the term 'Multiple' to the processing and that worked, again without the quotes around the word like
A different approach that might work is to use APEX_ITEM calls in your report to conditionally set the disabled flag based on a value in the row
nielsmans, if this works for you please give credit to 1ef.
1ef, can you change your alias to something more type-able?
Message was edited by: riedelme
This is te SQL for the report: The bold marked must be disble when P100_status is=disabled. when status is enabled the must be editable
where FORM_NR = :P2070_FORM_NR
In dynamic action you have enable disable option based on true or false. So to create a dynamic action write click on the Item To_Unit_Code and follow the steps. I think you would be able to create the dynamic action. You can create multiple dynamic action based on same page Item. Give it a try.
For using dynamic actions on report columns you need to use the jQuery selection as selection mechanism.
I personally use the name attribute of the columns input items for the jQuery selector.
The selector would then be [name="fXX"] where XX is a number.
Use your browsers developer tools to see the FXX you would need for your column.
If your report column uses the COLUMN_HEADERS substitution string you could use that in your jQuery selector.
This method is a bit more future proof because the fXX might change if a column is added and will change if the column order changes.
For more on jQuery selectors see jQuery's documentation