Re: Looping Search
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66767
interpreted = N
texte = This seems alot like a threaded bulletin board. So the problem is how to re-assign subordinates in the hierarchy when a supervisor disappears. One way might be to prevent deleting 2 until it's subordinates are re-assigned (i.e. throw up an error until the user fixes the condition). Not very friendly since it lacks an intelligent default. Another way is to reassign the subordinates upon deleting 2 via a default, i.e. 2 has a supervisor and when 2 is deleted, automatically assign everyone who reports to 2 to 2's supervisor. I think that's what you were proposing. Seems like a good solution too. Get 2's supervisor, search for anyone with 2 as a supervisor, replacefounditems with 2's supervisor. If an entry already has a missing supervisor [lookup =notfound], it needs to be flagged and a supervisor assigned. Bill-----Original Message-----From: Clint Davis
Sent: Wed, 05 Apr 2006 15:10:58 -0500To: "WebDNA Talk" Subject: Re: Looping SearchI *do* have a field in the database where each person's immediate supervisoris listed. Right now, Person 1 is hard coded into the page. A [search] foranyone whose immediate supervisor is Person 1 yields the Person 2 listingand so on down the chain. This works unless someone at the top is removed:if Person 2 left, Persons 3, 8, and 11 would have to be reassigned to Person1 as their immediate supervisor, or the whole chart would break.On 4/5/06 2:57 PM, "Pat McCormick" wrote:> Why not just have a field for immediate supervisor for every Person?> A demotion simply means changing the supervisor field. Or i guess it> could also mean coming to a stop. (get it? demotion? anyone?)> > > On Apr 5, 2006, at 2:24 PM, Clint Davis wrote:> >> I need to setup and org chart like this:>> >> Person 1>> -----Person 2>> ----------Person 3>> ---------------Person 4>> ---------------Person 5>> ---------------Person 6>> ---------------Person 7>> ----------Person 8>> ---------------Person 9>> ---------------Person 10>> ----------Person 11>> ---------------Person 12>> ---------------Person 13>> ---------------Person 14>> >> All of these people have a record in the personnel database with a field for>> their immediate supervisor. Can this be done with a [loop]'ed [search] versus>> my current nested [search]es? I don't want it to break if Person 3 gets>> demoted, for example.-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
This seems alot like a threaded bulletin board. So the problem is how to re-assign subordinates in the hierarchy when a supervisor disappears. One way might be to prevent deleting 2 until it's subordinates are re-assigned (i.e. throw up an error until the user fixes the condition). Not very friendly since it lacks an intelligent default. Another way is to reassign the subordinates upon deleting 2 via a default, i.e. 2 has a supervisor and when 2 is deleted, automatically assign everyone who reports to 2 to 2's supervisor. I think that's what you were proposing. Seems like a good solution too. Get 2's supervisor, search for anyone with 2 as a supervisor, replacefounditems with 2's supervisor. If an entry already has a missing supervisor [lookup =notfound], it needs to be flagged and a supervisor assigned. Bill-----Original Message-----From: Clint Davis Sent: Wed, 05 Apr 2006 15:10:58 -0500To: "WebDNA Talk" Subject: Re: Looping SearchI *do* have a field in the database where each person's immediate supervisoris listed. Right now, Person 1 is hard coded into the page. A [search] foranyone whose immediate supervisor is Person 1 yields the Person 2 listingand so on down the chain. This works unless someone at the top is removed:if Person 2 left, Persons 3, 8, and 11 would have to be reassigned to Person1 as their immediate supervisor, or the whole chart would break.On 4/5/06 2:57 PM, "Pat McCormick" wrote:> Why not just have a field for immediate supervisor for every Person?> A demotion simply means changing the supervisor field. Or i guess it> could also mean coming to a stop. (get it? demotion? anyone?)> > > On Apr 5, 2006, at 2:24 PM, Clint Davis wrote:> >> I need to setup and org chart like this:>> >> Person 1>> -----Person 2>> ----------Person 3>> ---------------Person 4>> ---------------Person 5>> ---------------Person 6>> ---------------Person 7>> ----------Person 8>> ---------------Person 9>> ---------------Person 10>> ----------Person 11>> ---------------Person 12>> ---------------Person 13>> ---------------Person 14>> >> All of these people have a record in the personnel database with a field for>> their immediate supervisor. Can this be done with a [loop]'ed [search] versus>> my current nested [search]es? I don't want it to break if Person 3 gets>> demoted, for example.-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
devaulw@onebox.com
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
New WebCatalog Version !!! (1997)
Sku numbers (1997)
(1997)
Multiple hideif's or if (2007)
Webcat table size. (2001)
SKU lookup (1997)
verify online (1997)
Thanks Grant (1997)
summ=T (2003)
FYI-AuthorizeNet-possible downtime (2001)
where's Formulas.db? (2001)
New Plug-in and Type 11 errors (1997)
Was 5.0 Pricing, now Sandbox versus Website and ruminating (2003)
Question about [encrypt] (1998)
WebCatalog NT beta 18 problem (1997)
tab as word delimiter (2000)
no global [username] or [password] displayed ... (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
Grep Question - NOT YET SOLVED (fwd) (2003)
Extended [ConvertChars] (1997)