[Alexander Bautz]

Thats good. The 500 error is the first query encountering the “throttling threshold”. It then resets and uses another method for querying in chunks of 5000 items.

Alexander

[Alexander Bautz]

I’m glad it worked technically, but as you have observed the load time will suffer – especially in older IE versions.

You might be able to use the Autocomplete plugin – have you looked at this one for this scenario?

Alexander

[Alexander Bautz]

This should work as it is in fact EditForm. Let me know if you have any further questions.

Alexander

[Alexander Bautz]

Sorry for the delay – I sometimes get a pileup in my inbox…

Yes, this is basically what the solution is designed for.

Here is a basic example:

	"applyTo":"EmployeeID",
	"helpText":"Enter the Employee number...",
	"listGuid":"EmployeeInfo",
	"listBaseUrl":"/Sites/MySite",
	"showField":"EmployeeNumber",
	"rowLimit":15,
	"listOptionsOnFocus":false,
	"reValidateOnLoad":false,
	"setFields":[
		{
			"fromFIN":"Departmend",
			"toFIN":"Departmend",
			"skipIfEmpty":false
		},
		{
			"fromFIN":"Manager",
			"toFIN":"Manager",
			"skipIfEmpty":false
		}
	]					
});	

Let me know if you have any questions.

Best regards,
Alexander

[Alexander Bautz]

I have fixed this in the upcoming release, but need to address a few more possible bugs / enhancements before I can publish it.

Best regards,
Alexander

[Alexander Bautz]

Hi,
Sorry for the delay – can you give me some more information? – is it a Lookup column, or a vLookup column in DFFS you are referring to?

Alexander

[Alexander Bautz]

I’m glad it worked out.

Best regards,
Alexander

[Alexander Bautz]

Thanks for the feedback – I’m glad it worked out.

Best regards,
Alexander

[Alexander Bautz]

Hi,
Sorry, but this is not possible with SPJS-casc. You can however make it work if you use the spjs-lookup solution, but it will need some custom coding to make one filter the other.

If you haven’t already found another solution, I might be able to help you with an example sometime later this week. Let me know if you need my help.

Alexander

[Alexander Bautz]

I have now posted an update to the spjs-casc.js / spjs-casc_min.js file (v3.525): get it here

This is the changes:

Added a method to bypass the list throttling occurring in SP 2010 and 2013 when exceeding 5000 items in a list. Please note that the query will take some time if you have more than 5000 items in the list.

I’m sorry I did not see this immediately, but I must have confused it with another of my solutions.

Ryan:
Can you try this new version, and if you still have trouble, try using the ID column in the “Comma separated list of fields (FieldInternalName) in the lookup list.” field in DFFS backend where you configure Cascading dropdowns. Also turn on “Write debug information to the top of the page” and let me know if you see anything in the top of the page.

Alexander

[Alexander Bautz]

Hi,
I may have misled all of you trying to get this working on a large list. I mistakingly thought this solution relied upon the “queryItems” / “queryItemsThrottled” in SPJS-utility.js, but clearly I remembered wrong.

I’ll look into it and rewrite it to support the “queryItemsThrottled” method from SPJS-utility.js to split a query failing because it triggers the “list view threshold” of 5000 items.

Ryan: I’m not sure this will fix your problem, but it’s worth a try. I’ll post here when I have updated the solution.

Sorry for the inconvenience,
Alexander

[Alexander Bautz]

Could you try changing to only ONE level (field) in the cascading dropdown configuration in DFFS backed to see if this prevents the error? – also, the indexing might take some time to complete so maybe you need to retest this tomorrow.

Alexander

[Alexander Bautz]

Yes, It has to do with this setting, but my “plan” with the “queryItemsThrottled” in SPJS-utility.js was to overcome this limitation but splitting the query in chunks of 5000 items.

Could you possibly try to index the columns you use in the dropdown (in the source list) to see if this helps?

PS: Are some of these columns of lookup, person or taxonomy / managed metadata?

Alexander

[Alexander Bautz]

Hi,
Can you post the URL to your NewForm? – replace the domain with “contoso.com” to not reveal your real domain name.

Alexander

[Alexander Bautz]

Hi,
From your code snippet it looks like you must change the quotes in your last line – the last one looks like it is not right.

If this is not the issue, please include the error message you receive.

Alexander

[Author]

Posts