Eclipse Community Forums: Eclipse Scout

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

TreeBox [message #1807421]

Wed, 29 May 2019 14:55

James Garringer

Messages: 4
Registered: May 2019

Junior Member

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?

Report message to a moderator

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

Fri, 31 May 2019 07:05

Patrick Baenziger

Messages: 96
Registered: September 2011

Member

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.

Report message to a moderator

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

Fri, 31 May 2019 14:48

James Garringer

Messages: 4
Registered: May 2019

Junior Member

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.

Report message to a moderator

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

Mon, 03 June 2019 11:22

The Maddes

Messages: 44
Registered: October 2018

Member

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 10 15:10:45 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter