Newbie Questions

Re: Drop-Down List Box Hide existent item in list

Abeyenen7 — Sun, 03 Sep 2017 01:44:57 GMT

HI William, Did the solution worked for you. Please provide support am currently facing the same issue.

Re: Drop-Down List Box Hide existent item in list

Abeyenen7 — Mon, 28 Aug 2017 15:08:02 GMT

Please, can you do walk throw?

Re: Drop-Down List Box Hide existent item in list

william.ru — Wed, 04 Jan 2012 00:58:03 GMT

Hi Patrick Halstead, Thanks for your so kindly reply my question in detail. I will try to one more column to filter the secondary data source. Thank you.

Re: Drop-Down List Box Hide existent item in list

Patrick Halstead — Mon, 02 Jan 2012 06:22:07 GMT

Hi William.Ru,

I seem to recall that we developed a clever sample for this in the past but now I can't find it. Filtering doesn't work here because you need to compare against previously selected items. You could write code to do some kind of IsMember check but there is a simpler way. Basically, you just need to set "selected" boolean or checkbox value that is at the same level as the items in the secondary data source. Just have it bring down another column and set this to "GOTCHA" or whatever when they pick it. Then, add a filter that compares against this second column and only chooses the sibling fruit where the new column is not equal to GOTCHA. Something like that ought to do the trick. There should be a download somewhere on this site for that. Maybe search for "unique dropdown" ...

Best of luck,

PS> to set the new sibling column to GOTCHA when the fruit is selected, you have to add a filter on the set which isn't supported out of the box (qRules SetValue will do). So another idea which may not even require the new column is to try adding a filter to the dropdown you add a condition where you look up in the table the value of the current node and checks whether it exists. Might involve a tricky xpath that checks for the size of the substring returned or something like that since existence is not an xpath function.

Drop-Down List Box Hide existent item in list

william.ru — Sat, 31 Dec 2011 06:58:22 GMT

I have drop-down list box control in a custom list form, it binds to a another list(Secondary date source). For example: Drop-Down List Box A: Apple, Banana, Orange, Strawberry; What I want to do is: If there is a list item which has selected "Apple" in drop-down list box A, when user create a new list item he will not see "Apple" in the drop-down list box A. What rules should I apply? Thanks.