Configuring Hierarchy

Labels
AJAX(112) App Studio(6) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(8) OAuth Scopes(1) OAuth2(11) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(10) PKCE(2) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(178) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(80) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Wednesday, February 27, 2013PrintSubscribe
Configuring Hierarchy

The “hierarchy-parent” tag can be used to present a hierarchical view of information.

Note that hierarchy is only available in the second generation data sheet view.

First, create the HR sample web application using Oracle Database Engine.

Adding a New Page

When generation is complete, activate the Project Designer. On the Project Explorer toolbar, click on the New Page icon.

Creating a new page.

Assign a name to the page:

Property Value
Name Hierarchy

Press OK to save. Drop the new Hierarchy page node on the right side of Home page to place it second in the menu.

Dropping Hierarchy page onto Home page.     Hierarchy page is second in the menu.

Switch to the Controllers tab. Right-click on EMPLOYEES data controller and press Copy.

Copying EMPLOYEES controller.

Switch back to the Pages tab. Right-click on Hierarchy page and press Paste. The data controller will be instantiated as a data view.

Pasting onto Hierarchy page.     The data view has been instantiated as a data view in a container on the page.

Configuring Hierarchy in Data Sheet

Double-click on Hierarchy / c101 / view1 (EMPLOYEES) / grid1 view node.

View 'grid1' of EMPLOYEES controller.

Change the view type.

Property New Value
Type Data Sheet

Press OK to save. Double-click on Hierarchy / c101 / view1 (EMPLOYEES) / grid1 / MANAGER_ID –> MANAGER_LAST_NAME data field node.

Data field 'MANAGER_ID' of view 'grid1'.

Tag the data field as the hierarchy parent.

Property New Value
Tags hierarchy-parent

Press OK to save.

Viewing the Results

On the toolbar, press Browse. The data sheet will now be organized according to the hierarchy.

Hierarchy in the Oracle sample database.