This project has moved and is read-only. For the latest updates, please go here.

SPCascadeDropdowns and filter in parentList

May 30, 2013 at 2:46 PM
Is there a way to properly filter the parentList? I had the impression I could use the CAMLqueryoptions for that (because the documentation says: "This option can be used to specify additional options for retrieval from the sourceList")

So I added:

CAMLQueryOptions: "<Query><Where><Eq><FieldRef Name=\"Active\" /><Value Type=\"Text\">1</Value></Eq></Where></Query>"

Well.. I didn't work =) any advises?
May 30, 2013 at 7:50 PM
You want to use the "CAMLQuery" parameter for that. That is the option that allows for additional filtering on the parent list. CAMLQueryOptions is a different animal altogether.
May 31, 2013 at 7:39 AM
I already use the CAMLQuery Option, for filtering the childList (my form is basically a list of options, where your name has to be in another column to enable the option for you)

CAMLQuery: "<Eq><FieldRef Name='Selected_by' /><Value Type='Integer'><UserID Type='Integer'/></Value></Eq>"

Now I'm searching a way to also filter the parentList... :-/
May 31, 2013 at 11:36 AM
Nevermind... I'm so stupid. Just use $().SPServices.SPFilterDropdown in addition... :D Thanks anyways