Forms Framework FAQs

22.2 Forms Framework FAQs

What should I do when I have large volume of data to be exported?

It is recommended to use BIP reports or OBIEE reports if you have to export large volume of data.

How do I export the columns added to the grid using Field Chooser option?

Perform Grid Export operation to export the columns added to the grid by Field Chooser option.

'Expand All/ Collapse All' button is not visible in the Hierarchy Browser window. What should I do?

Expand All/ Collapse All button is disabled if the number of hierarchy nodes is more than 50 and if it is a non-custom hierarchy. Hierarchy with more than 50 nodes is considered as large hierarchy and the data will be fetched dynamically when you expand the parent node.

What is the difference between the two Searches available in the Hierarchy Browser window?

In the new Hierarchy Browser window introduced from 7.3.5.1.0 version, there are 2 search options available:

DB Search (Top search container): It will search the required node in database and displays the result as shown below. This search is performed on full hierarchy nodes.
UI search (Below the hierarchy): This search will find the required node in the UI and will show in tree structure.

Note:
In case hierarchy nodes are more than 50 and if it is a non-custom hierarchy, then the UI search will not show the required node in tree structure, until all the nodes are expanded and loaded manually in the UI.

What is a Custom Hierarchy?

Custom hierarchies will be having the parameter configuration customQuery as shown below and the customized query will be taken from the HIERARCHY_FILTER_MASTER table.

Configuration in xml:

<CONTROL ID="1003" TYPE="41">

</EXTRAPARAMETERS>

</CONTROLPROPS>

</CONTROL>

For custom hierarchy, all the hierarchy nodes are loaded in UI without any limit.

So, even if the hierarchy nodes are more than 50, the UI search will show the required node in tree structure and ExpandAll and ExpandBranch images will be enabled.