Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

There are two external lists like 'Project' and 'Task'. Task referencing project by using field ProjectID. I've created external content types. For 'Project' content type I've marked field 'ProjectName' as Title. For 'Task' I've added an association. Than created lists with InfoPath forms.

Here is a prblem: When adding or editing a task there is an item picker for ProjectID field. And when user have selected an item the ProjectID is shown in the box. Not the project name. When I've marked 'ProjectName' as Title for 'Project' content type it puts project name in the box but shows an error:

No exact match was found. Click the item(s) that did not resolve for more options. You can also use Select button to choose External Data.

enter image description here

Any ideas?

share|improve this question
add comment

1 Answer

You need to define filter parameters on your read list operation for your ECT in sharepoint designer. For example, create a wildcard filter for text filtering, and set it to default. Then that filter with your selected field will be the default search parameter in your external item picker.

  1. In SharePoint Designer, navigate to External Content Types.

  2. Right click on your External Content Type and select Edit External Content Type.

  3. On the ECT settings page double click the Read List Operation. enter image description here

  4. Click next on the Read List Operation's dialog window.

  5. Click Add Filter Parameter.

  6. On the right, click (Click to Add).

  7. There are some straight forward options you can pick here. I normally select Wild Card filter type as that will produce the most matches preventing the user from having to type the full name.

enter image description here

Selecting Use to create match in external item picker will create suggestion as you see in the next image:

enter image description here

Finally save the changes to your external content type and export the model if you need to add it to version control or need a backup of the current stae.

share|improve this answer
    
Adding explicit steps just for clarity. –  Robert Kaucher Dec 20 '12 at 17:53
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.