query on MVG field with "IS NULL" does not work / no results when MVL does not have a Primary Id Fie

Hi All,

I have a BC "Opportunity" and created a Link "Opportunity/My Partner Accounts".

Parent BC: Opportunity

Child BC: Account

Search Spec: [Type] = 'XYZ'

(inter table: S_OPTY_ORG)

In BC Opportunity I did the following:

- created MVL based on this Link

- created a field based on this MVL

Note: as there is no primary partner information available for this custom MVL, the MVL does not have a Primary Id Field specified, and the "Use Primary Join" property is set to FALSE.

In the end I exposed the field to an applet.

So far so good. Now I have issues when querying "IS NULL". It does not return any rows, although 99% of the records do not have a partner associated.