Eclipse Community Forums: Eclipse Scout

Home » Eclipse Projects » Eclipse Scout » TreeBox(Assistance understanding the tie in for LookupCalls and TreeBox)

Wed, 29 May 2019 10:55

Eclipse User

Hi all and thanks in advance for any advice you may have!

I'm trying to create a hierarchical TreeBox using a Lookup call but I must be missing some fundamental understanding because I can't quite get it to work. To elaborate, my table has three columns of interest. An order number, a part #, and cost. I would like to set up a Lookup call that returns to the TreeBox so that I see the part # as a parent and the amounts and child nodes. Any suggestions?

Re: TreeBox [message #1807492 is a reply to message #1807421]

Fri, 31 May 2019 03:05

Eclipse User

Hi there and welcome!

If I understand you correctly, you want a TreeBox like this:

Part No 1
- Cost 1
- Amount 1
Part No 2
- Cost 2
- Amount 2

To achieve the desired result, your LookupCall needs to return three LookupRows.
The trick to make them hierarchical, is to set the parentKey for the children to be equal to the key of the parent row.
You can use the withParentKey method on the LookupCall to set the parentKey, the key itself is usually set in the LookupRow constructor.

Re: TreeBox [message #1807511 is a reply to message #1807492]

Fri, 31 May 2019 10:48

Eclipse User

Thank you for the response and apologies but I don't quite follow. To clarify my question some more:

I am using a LookupCallService that extends AbstractSqlLookupService, and this has overridden getConfiguredSqlSelect() that I feed an SQL String to. In the database table that this is set up to query I want to relate two columns in a hierarchical way. For instance part# and cost. Part# is not unique though and occurs multiple times throughout the table and is associated with different costs. I'd like to generate a TreeBox that allows me to see all the costs for one part# like so:

part#1
- cost1
- cost2
part#2
- cost3

Despite the above example it is unlikely for costs associated to a specific part# to actually be sequential in the database.

Re: TreeBox [message #1807556 is a reply to message #1807511]

Mon, 03 June 2019 07:22

Eclipse User

Hi James,

i think Patrick was leading the right direction.
As far as i understand, the SQL knows the relation from costX to part#X.

So as a solution i would suggest that you create two columns in your SELECT like
"reference" and "parentreference" and set the values the way you need them.

The rest will be solved by the hierarchical treebox or whatever hierarchical structure you decide.

Hope it helps you out a bit :)

Cheers

Previous Topic:	Display Search Form when activating the Page
Next Topic:	data transfer from TreeField to the server module

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 22 23:05:59 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter