This content has been marked as final. Show 7 replies
Well, i don't think you can perform it by doing visible or invisible the item/button. I can share one idea to create two image files one for granted and one for denied. In you multi record block create one image item (non-database) and read the image on that item in POST-QUERY (block-level) based on status values as you have if condition...
TRIGGER = POST-QUERY (BLOCK-LEVEL) IF :STATUS.C_STATUS = 'GRANTED' THEN READ_IMAGE_FILE('image_path\access_given.JPG','JPG','BLOCK_NAME.IMAGE_ITEM_NAME'); ELSE READ_IMAGE_FILE('image_path\access_denied.JPG','JPG','BLOCK_NAME.IMAGE_ITEM_NAME'); END IF;
Just a note:
READ_IMAGE_FILE('image_path\access_given.JPG','JPG'...) might cause some performance issues (if you have lot of data displayed) as every time you do something on the block (post-query) this has to go to the server to get the image.
A better way is using READ_IMAGE_FILE (image,’URL’,item) as this get loaded from the local JAR's (assuming you have all your images deployed into a jar).
sing this code i am able to obtain the visibility of icons but it affects the entire column.SET_ITEM_INSTANCE_PROPERTY just for 1 item
SET_ITEM_PROPERTY works on the whole 10 records
So u can't use them both in the same time this is the cause of ur output code...
Pls read & Try this Solution
Hope it works...