Delay when using a BCS based external data column
OPM Client 6.4.2
Server Side Components 6.4.1 (I couldn't locate 6.4.2 version of server side components..)
We're experiencing a delay when using a BCS based external data column. This does reference a large list (77,685 records) but the list view in SharePoint has been set to only return 100 rows and doesn't have the delay.
When using the lookup column in SharePoint under document properties the lookup list returns a warning "Too many results have been returned. This results set may be incomplete or truncated" but the lookup appears straight away and once we enter a value in the find the matches are shown and the warning disappears.
When looking at the field in OnePlaceMail Save Dialogue the lookup takes about 30 seconds before values are returned and the "Find" field only shows "" with no options available:
Once it's finished returning records the Find correctly shows the "Name" column.
If we type in the search box without waiting for the initial results and click search we get a "Search Warning" message that "Search criteria cannot be met as Filters are not defined for the External Content Type" ..
Clicking okay on that the "Find" field changes to "Name" and the matching records are returned within seconds..
Is there any way to adjust the lookup to only fetch the first 100 by default so the find will populate with available columns but then ensure all records are searched if using a filter? (As per SharePoint document properties)?
Prashanth Hamse commented
I am trying to add Wildcard character in BCS external data connection but unable to do so. I cannot view external data type in designer mode.
I get this error message:
Search criteria cannot be met as Filters are not defined for the External Content Type. Contact your system administrator.Warning: Too many results have been returned. This result set may be incomplete or truncated.
I would like to add drop down list in nintex form which connects to external list coloumn.
Thanks - great to hear!
Daniel Cottam commented
Thankyou, setting the limit filter appears to have resolved the issue!
Thanks for the inquiry.
The best practice is to define a limit filter for Business Connectivity Services if you have a large data set.
You can do this via Sharepoint Designer, connect to your site, then "External Content Sites".
Further information can be found here:
I hope this resolves this issue for you, if not please let us know!