SetRecordStatus, SetRecordStatus('datasource','status'), to change the current record in the Store. where status can be 'New','Insert','Query','Update'. InvokeValidateService, InvokeValidateService ('datasource',CallBack()). evaluateSelectSQL, evaluateSelectSQL('sqlquery', boolean), to query the tables in database from pre-query or postquery. When true it queries the APPS schema and when false it queries the XXRA schema. executequery, executequery(sql, params,boolean), When true it queries the ...
Auto Query, Automatically executes the query on the Grid's Data Source thus pre- populating the data when the page is rendered. Make sure this property is checked for the child Grid, otherwise the child Grid will not refresh when the parent record is changed. When defining master/child relationship, make sure the <a href="#Parent_Data_Source">Parent Data Source</a> is set and the Auto Query is checked. Auto Height: It dynamically adjusts the grid's height based on the number of records fetched.
When do we use it? If you want to execute pre or post conditions on the data source object's state changes, you can go with server side scripting. Apart from validations, you can also use this feature to do defaulting as well. Note: Any defaulting performed in the Post operations (eg After Insert, After Update) will be updated on the UI but not persisted to the database until the user perform a Save action. Pre and Post conditions on Datasource object are. Before Insert Row; Before Update Row; Before Delete ...
|Server Side Development Advanced Topics Java|
Either you can enter the itemid in the text field or use the Icon to open a Pop-up and use the LOV to search and select the item. Preview Page and click on the button to check the action. Done! This is how the output looks when the Hide Button is clicked. Similarly you can use 60+ pre-defined actions on a Button or Link. Why not try Action Show? Try it out yourself and see how easy it is..... ← Lesson 8: Make Button Render on the Panel Header; Index; Lesson 10: Create Table Using SQL Query Browser →
101 California Street, Suite 2710
San Francisco, CA 94111
440 N. Wolfe Rd.
Sunnyvale, CA 94085
Office 11, 5th Floor, Building 9,
Mindspace IT Park