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 -0500 To: "WebDNA Talk" Subject: Re: Looping Search I *do* have a field in the database where each person's immediate supervisor is listed. Right now, Person 1 is hard coded into the page. A [search] for anyone whose immediate supervisor is Person 1 yields the Person 2 listing and 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 Person 1 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 -0500 To: "WebDNA Talk" Subject: Re: Looping Search I *do* have a field in the database where each person's immediate supervisor is listed. Right now, Person 1 is hard coded into the page. A [search] for anyone whose immediate supervisor is Person 1 yields the Person 2 listing and 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 Person 1 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:
Bug alert! (1997)
Sorting error (1997)
Error Lob.db records error message not name (1997)
Undeclared variables (2004)
WebCat with WebTen (1998)
Auto Unsubscribe (2000)
Help! WebCat2 bug (1997)
Max Record length restated as maybe bug (1997)
using showpage and showcart commands (1996)
searching for items that begin with a number (2004)
calculating tax rates, mail order solutions and version 2 (1997)
# fields limited? (1997)
WebCat2 - Getting to the browser's username/password data (1997)
WebCatalog/WebMerchant Manuals Available (1998)
Ad Serving Software (2002)
Help name our technology! (1997)
linetiems in thankyou.tpl (1997)
[isfile] ? (1997)
Location of Browser Info.txt file (1997)
limitation found on group searching (1997)