Skip to content

I suggest you ...

← OnePlaceMail (Desktop)

Delay when using a BCS based external data column

SharePoint 2010

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.

https://d2r1vs3d9006ap.cloudfront.net/s3_images/933930/Lookup1.PNG?1375235470

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:

https://d2r1vs3d9006ap.cloudfront.net/s3_images/933932/Lookup2.PNG?1375235725

Once it's finished returning records the Find correctly shows the "Name" column.

https://d2r1vs3d9006ap.cloudfront.net/s3_images/933935/Lookup3.PNG?1375235790

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" ..

https://d2r1vs3d9006ap.cloudfront.net/s3_images/933936/Lookup4.PNG?1375235860

Clicking okay on that the "Find" field changes to "Name" and the matching records are returned within seconds..

https://d2r1vs3d9006ap.cloudfront.net/s3_images/933939/Lookup5.PNG?1375235912

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)?

0 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Daniel Cottam shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Prashanth Hamse commented  ·   ·  Report

    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.

  • Elissa commented  ·   ·  Report

    Hi Daniel,

    Thanks - great to hear!

    Elissa

  • Daniel Cottam commented  ·   ·  Report

    Thankyou, setting the limit filter appears to have resolved the issue!

  • Elissa commented  ·   ·  Report

    Hi Daniel

    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:

    http://lightningtools.com/business_connectivity_services/creating-limit-filters-in-sharepoint-designer-2010/

    I hope this resolves this issue for you, if not please let us know!

    Thanks

    Elissa

OnePlaceMail (Desktop): Issue

Categories

Feedback and Knowledge Base

(thinking…)