Many - to Many control - Choices Collection query constraints ignored

Question

Hi,

It seems, no matter how you may modify the query source for the 'Choices Collection' property of the many-to-many control, you always end up being shown ALL the options from the entityset selected in the 'Choices Navigation' property. This renders the control practically useless for all but the most simple scenarios. The 'Choices Collection' property setting has absolutely no effect on the data being returned, even though it is a query based on the entityset selected for the 'Choice Navigation' property.

For example, suppose there is a table which stores all the possible roles that an address can have (Invoicing, Delivery, returns, home, work) etc. In which case I don't expect to see 'home' and 'work' as options if the currently selected address belongs to a company as opposed to a person! I have set up my 'Choices Collection' query source to return what I want, but this makes no difference. I have confirmed that the query is being called simply by configuring a 'dummy' preprocess method and setting a breakpoint.

Such a shame regarding what is otherwise a great screen-real-estate-saving control! Can someone please have a look at this? Beth?

Ian MacPherson

Answer 1

Hi all,

A bit surprised no-one has come back on this! Seems to me that the m2m control does not behave as it should based on my experience.

Also, although you can add command bar(s) to it, they never actually display. Is this intentional and if so, why?

If anyone can help with my main issue (as previous post) at least, please do so as I can't believe that no-one else is expereiencing a bit of frustrattion with this control! Come on Lightswitch team, you shipped this control; I'd be really grateful for a bit of support on it!

Ian Mac

---

Ian Mac

Answer 2

Hi Ian,

Sorry I didn't see this post - I'll take a look at the issue. 

Sheel

Answer 3

Thanks Sheel I would be really interested to see what you're able to come up with!

Ian Mac

---

Ian Mac

Answer 4

Hi Ian,

Turned out to be a bug in my code - I've updated the extension.  Let me know if that fixes the problem.

It was actually intentional to remove the command bar from the control - the default behavior of the command bar is to include Add/Edit/Delete buttons which are unnecessary for this control.  My expectation was that you could add any other buttons separately if needed for the control.

Thanks!

Sheel

Answer 5

Hi Sheel,

Thanks for that, but the extension is not being marked as 'updated' to enable installation of the new version. Unless you're using some other method?

Regards,

Ian Mac

---

Ian Mac

Answer 6

Hi,

Does double clicking on the new VSIX not install a new version?  Otherwise, you'll need to remove the extension from Visual Studio then install it again.

Thanks!