Posts

Checking Data Changes in ADF

Some times you  want to check if the data has been modified by the user or not. We can remember how easily we make this in forms builder using ":System.record_status" or :System.block_status" or :System.form_status". But the ADF world is somehow different. Just write this code

How to get value form a list or poplist

Instead of looping throw the iterator to get the value from the index, You can simply set the property "valuePassThrough" = true in the list

How to make summary Column.How to calculate Sum of a column.

Image
Hi I have a af:table that displays information about Employee vacation. I want to sum the value of the column "ActualNumberOfDays". Here is the table. I will Explain how I calculated the total of the "Acutal days" column. 1- I Created a readonly view based on Query SELECT     v_emv.ID emv_id,     v_emp.EMP_ID emp_id,     v_emp.EMP_NAME_AR ar_name_full,     v_emp.EMP_NUM,     v_vat.NAME_AR,     v_emv.START_DATE,     v_emv.END_DATE,     v_emv.NUMBER_OF_DAYS,     v_set.ACTUAL_END_DATE set_end_date,     v_emv.HOLIDAYS,     v_emv.VACATION_STATUS,     v_set.ACTUAL_NUMBER_OF_DAYS - NVL(v_set.ACTUAL_HOLIDAYS, 0) - NVL(v_set.MISSION_DAYS, 0) actual_number_of_days  FROM     HRS_V_EMP_BASIC_INFO v_emp,     HRS_V_EMP_VACATIONS v_emv,     HRS_V_VACATION_TYPES v_vat,...

تاسيس الشركات ذات المسؤلية المحدودة

http://www.lawforall.info/index.pl/incorporation_of_llcs

error in internet explorer

http://www.oratraining.com/blog/2010/04/internet-explorer-has-closed-this-webpage-to-help-protect-your-computer/

how to create dynamic menu based on table

http://biemond.blogspot.com/2008/11/dynamic-menu-based-on-roles-database.html

How to create fixed list in ADF

Image
1- create a read only view object based on a query example: SELECT 'Reject' DESCRIPTION ,'BCK' CODE FROM DUAL UNION ALL SELECT 'Accept' DESCRIPTION ,'GM' CODE FROM DUAL 2- in the base view object (your main view object that you want to add the fixed list) add a new Transient attribute for example "Manager_descision" 3- Create view accessor in the main view abject that referes to the readonly query VO 4- associat a LOV to your Transient  attribute that is based on your view accessor   Note that you must add list return value to retrun the value to the database attribute to save the returned value in the DB 5- in your page drag and drop the transient attribute from the data control to the page as selectOneChoceList 6- go to the page Bindings and select the attribute in the strucure window and right click to add attribute names and attribute values 6- save and run the page