How to Sort Data in the XMLP?

Oracle Apps Interview QuestionsCategory: XML PublisherHow to Sort Data in the XMLP?
Questions Master asked 3 years ago
1 Answers
Shailender Thallam Staff answered 3 years ago

Syntax:-

Case 1:-
<?sort:Field_Name?><?Field_Name?>
It sorts the data in Ascending order by Default.if Order By is not mentioned

Case 2:-
<?sort:Field_Name;’Order by?>
It sorts the data based on Order By mentioned here like Ascending Or Descending

Case 3:-
<?sort:Field_Name;’Order by‘;data-type=’text’?>
It sorts the String Data based on Order By mentioned here like Ascending Or Descending

Examples:-

Case 1:-
<?for-each:EMP_DETAILS?>
<?sort:EMP_NO?><?EMP_NAME?><?end for-each?>

Case 2:-
<?for-each:EMP_DETAILS?>
<?sort:EMP_NO;’descending?><?EMP_NAME?><?end for-each?>

Case 3:-
<?for-each:EMP_DETAILS?>
<?sort:EMP_NAME;’ascending‘;data-type=’text’?><?EMP_NAME?><?end for-each?>