Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Problem when filtering - Could not find exactly 1 Member with name 'Status'

  Asked By: Marques    Date: Aug 21    Category: Sharepoint    Views: 910

I have created a filter on my finder-method, but I keep getting this error:

Could not find exactly 1 Member with name 'Status'
Parameter name: fieldName

My command is like this: SELECT [Status],[Projectnr],[Titel] FROM [MYTABLE] WHERE([Titel] LIKE @@TitelFilter)

And I have created all the appropriate filters, parameters etc.

I have tried entering a filter-value which I know only returns one record, but I get the same error.

If I hardcode my statement like this: SELECT [Status],[Projectnr],[Titel] FROM [MYTABLE] WHERE([Titel] LIKE '%m%')

It works fine and returns a lot of records.

Any ideas why I get the above error when filtering with a parameter?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Jonathan Scott     Answered On: Aug 21

In the XML-definition of the BDC the IN-parameter containing the filter-value, must be before the return parameter. When using the BDC Catalog Definition Editor, the IN-parameter is placed after the return parameter, if it is already present. By editing the XML-definition and moving the IN-parameter before the return-parameter, the problem  is solved.

 




Tagged: