Sometimes it is required to create af:query component based on a view object but it need to hide some of the attributes from criteria.
Its simple, open view object uncheck “Select in Query” attribute and it will not show while querying.
Please write back if still facing any issue.
Sometimes it is required to create a dropdown which should use base data as a variable rather than a binding.
1) Create a variable inside variables binding
2) Give variable name and create it of string type.
3) Select list binding type
4) Select second option from “Select List Binding Type”
5) Create a data mapping and use List Item configuration for default value of your dropdown.
Map code and for showing default option use Please Select
please write to us if you have any problem in configuring it at firstname.lastname@example.org
Sometimes its preferable to delete child record as well, on deleting parent table records.
Its quite easier open your association, go to behaviour, tick Composition Association and tick “Implement Cascade Delete”