Quality Center / ALM Practitioners Forum
cancel

ALM 12.01 - How to restrict users from selecting parent items from a list?

SOLVED
Go to solution
Highlighted
S0PH1ST1CATED
Occasional Advisor

ALM 12.01 - How to restrict users from selecting parent items from a list?

Hi, 

We have list field in defects module where items are stored in hierarchy, so there are various parent, child and sub child nodes.

 

The users at the moment are able to select any of these items from the list while the requirement is that they should only be able to select an item with no further child items.

 

Could anyone please help as to how this can  be accomplished?

 

Many thanks

3 REPLIES
Jan Czajkowski
Honored Contributor
Solution

Re: ALM 12.01 - How to restrict users from selecting parent items from a list?

Assuming your field is BG_USER_01 and that you have set the Verify Value option, try adding this to Bug_FieldCanChange:

If FieldName = "BG_USER_01" AND NewValue <> "" Then
  Set theList = TDConnection.Customization.Fields.Field("BUG","BG_USER_01").List
  Set listNode = theList.Find(CStr(NewValue))
  If listNode.ChildrenCount > 0 Then
    Bug_FieldCanChange = False
    Exit Function
  End If
  Set listNode = Nothing
  Set theList = Nothing
End If
Jan Czajkowski

[Please do not contact me off line for receiving support. Use the forum!]
S0PH1ST1CATED
Occasional Advisor

Re: ALM 12.01 - How to restrict users from selecting parent items from a list?

Thank you sir, that was really helpful. Much Appreciated.

Jan Czajkowski
Honored Contributor

Re: ALM 12.01 - How to restrict users from selecting parent items from a list?

I forgot to add that a precondition for the code to work is that the list values are unique. If the same name appears both as a folder node and an end node, it could fail.

Jan Czajkowski

[Please do not contact me off line for receiving support. Use the forum!]
//Add this to "OnDomLoad" event