Sample BSV: Filtering list of references in "Add"

[tford]

This sample BSV demonstrates how to:

1) Have a form to filter choices in a reference list (see screen shot below):






2) Show only instances NOT currently on the reference list:




The key is the query: "Country Choices List". The query's FIND action is modeled after the workaround shown in the User Guide -- Appendix B #14:

FIND Country WHERE COUNT RegularUser WHERE (RegularUser IN Country.Users AND RegularUser=ThisRegularUser)=0 ORDER BY Country.Name

Note that this query uses the form "Country Choices Filter". This form produces the "Country Choices Filter" in the first screen shot above.


Download Sample BSV: Add_Country_Filter_8_31_2009.bsv

After download, remove the .bin extension

[tford]

BSV Improvement challenge.

I would love to be able to restrict the region list below to only include the Regions associated with Countries NOT currently on the list:




I would like the list above to only include Region 50 and Region 000.




Can anyone devise a Filter to the Region attribute of the "Country Filter Choices" form that will accomplish this?

[bartthefish]

The only way that i can see it being possible is to modify the BO's so that it will keep record of What countries belong to a specific region, and then build a query that checks the countries that are not in the User's profile; and then find's the regions that they fall under.

I will have a look at the bsv later and see if i can figure out the wording of the query.