<div>I wouldn't think that the searchbuilder would show the same string value though if you have the value occurring multiple times based on a parent field. In my example below the value "softwarename1.1" will show up in the searchbuilder each time I have entered it for that field. </div>
<div><br></div><div>What I was suggesting is that one way to handle this would be to make the searchbuilder page only add a string value if that string value doesn't exist in the values already. That seems like the simplest was to avoid the same value from showing up several times in the searchbuilder. </div>
<div><br></div><div>Right now what happens is, you end up with 4 "Password Reset" Values in the example below. This also would create 4 "Password Reset" in the searchbuilder dropdown, which works because the search is based on the String value and not the ID of the record.</div>
<div><br></div><div>* Active Directory</div><div> * Password Reset</div><div>* TimeSheet</div> * Password Reset<div>* TestDomain</div> * Password Reset<div>* Whatever</div> * Password Reset<div><br></div>
<div><br></div><div>Just a suggestion... but an excellent way to handle it may be to add functionality to the "Categories are based on" drop down so that you select the parent field first, and then select each value that the current value is visible for. This would let you have a more flexible relationship for building the hierarchy. </div>
<div><br></div><div>Then you could select Field1 as the Parent for Field2, but also specify that Field2.Value1 would be an option when you select Field1.Value1, Field1.Value3, Field1.Value4, Field1.Value7 - etc.</div><div>
<br></div><div><br></div><div><br></div><div><br></div><div><br><div class="gmail_quote">On Mon, Nov 14, 2011 at 10:53 AM, Kevin Falcone <span dir="ltr"><<a href="mailto:falcone@bestpractical.com">falcone@bestpractical.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On Fri, Nov 11, 2011 at 03:01:18PM -0500, Jim Lesinski wrote:<br>
> Hi,<br>
> In request tracker, how would you recommend setting up your dependent drop down lists that<br>
> have a consistent drop down value for multiple parent values? Below, under the 1st level<br>
> Administration value, I show an example of what I am asking about.<br>
<br>
</div>If you use the 'Categories are based on' feature in later 3.8 and 4.0<br>
you'll get much better search options than typing in the Category box.<br>
<br>
> * Hardware<br>
><br>
> * item1.1<br>
> * item1.2<br>
> * item1.3<br>
><br>
> * Software<br>
><br>
> * item2.1<br>
> * item2.2<br>
> * item2.3<br>
><br>
> * Administration<br>
><br>
> * password reset<br>
><br>
> * softwarename1.1<br>
> * softwarename1.2<br>
> * softwarename1.3<br>
><br>
> * profile update<br>
><br>
> * softwarename1.1<br>
> * softwarename1.2<br>
> * softwarename1.3<br>
<div class="im">><br>
> I was able to set up the outline above by using the built in "categories are based on" option<br>
> for drop down lists and entering the value one time for each parent value. The only thing that<br>
> I see as a possible issue with doing this is that the search builder then shows the drop down<br>
> text value multiple times. Maybe just a bug or improvement that could be made in the<br>
> searchbuilder (ie; only show DISTINCT dropdownlist value)? Or should I handle this a different<br>
> way?<br>
> Either way I would appreciate your insight.<br>
> Thanks,<br>
> Jim<br>
<br>
</div><div><div></div><div class="h5">> --------<br>
> RT Training Sessions (<a href="http://bestpractical.com/services/training.html" target="_blank">http://bestpractical.com/services/training.html</a>)<br>
> * Barcelona, Spain ? November 28 & 29, 2011<br>
<br>
</div></div><br>--------<br>
RT Training Sessions (<a href="http://bestpractical.com/services/training.html" target="_blank">http://bestpractical.com/services/training.html</a>)<br>
* Barcelona, Spain — November 28 & 29, 2011<br></blockquote></div><br></div>