Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Listbox Limiting or Narrowing for form List box | ||||||
---|---|---|---|---|---|---|---|
Product: | Base | Reporter: | voobase <marty> | ||||
Component: | code | Assignee: | AOO issues mailing list <issues> | ||||
Status: | UNCONFIRMED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | drewjensen.inbox, issues | ||||
Version: | OOo 1.0.0 | ||||||
Target Milestone: | --- | ||||||
Hardware: | Unknown | ||||||
OS: | All | ||||||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
voobase
2009-02-23 13:26:02 UTC
To me, this sounds like a "filter control", e.g. a special case of the more general idea where the user input in a control limits (filters) the content displayed in a (logical) form. In this case, there's just currently an open window for all users wanting this to vote for it :) See http://blogs.sun.com/GullFOSS/entry/still_have_some_wishes_for for details. No, I do not believe it is a similar concept. A "filter control" is, as you mentioned, concerned with changing the filter set for a form and possibly then organising a reload of the form. Using one listbox to narrow the selection in another would instead require one listbox control to effect a second listbox control. A list box "filter control" would be concerned with displaying information from your form such as.. display all names with surname "Smith". A list box which narrows another would instead be concerned with entering information into a form (mostly), for instance select in one list box the manufacturer and then the list in the second list box is immediately limited, to only show the model's available from that manufacturer. Presently a "filter control" is already easily achievable in Base with only a couple of lines of macro code required (to organise a form reload). The trick is to use the link/join between a mainform and subform. To limit the list in a listbox depending on anothers selection requires much more code. To see for yourself the difference between the two, please have a look at these two example databases. The first is for a "drop down record switcher" which would be a similar concept to the "filter control" and is found here... http://www.oooforum.org/forum/viewtopic.phtml?t=72134 The second is for an example database called "classes" which is found here... http://www.oooforum.org/forum/viewtopic.phtml?t=71055&postdays=0&postorder=asc&start=15 (You will need to import the macro file separately for this one which should be in the zip file). I believe, on the community forums, it has been asked more often by at least a factor of 2 to 1 for help to get one list box to narrow another, other than for a listbox to filter a form. Ah, I see what you mean. Well, assuming that the second list box is filled from the database, too (and does not use value lists), then if the first list box would act as filter control not for its form, but for the result set which populates the second list box ... then I could somehow save my "this is a filter control" approach :) But you're right, those are different things. Just wanted to add a few comments here: I would agree that the more common request is to have a selection in one list box influence the available choices in a second list box. At least from my anecdotal experience. Also, that when the question from uses is regarding using a list box to filter a result set that the use of a simple macro usually results in a reasonable outcome for the user - when it is to alter the items in a second list box it is much more problematic. Going along with the discussion here, I also agree that the hurdle that seems to be the most troublesome is the inability to get at the actual FK value used by the control - another way to say this might be - the inability to get at the actual result set that produces the itemList. Adding a new property to the ListBox control to expose this FK value would be one way to approach this, sure. At this point at least the creation of the required macro would be about equal in complexity to that of the listbox as filter. Created attachment 80383 [details]
New content type item in Form properties dialogbox
RFE: add to Form properties dialogbox, a new item for "Content type" to choose a listbox control.
This will more helpful for end-users.
|