Hi all,
I have created an extension table for the nms:recipient table and joined there another view of the datamart.
Here is the code snippet:
<!-- Tristan Roppel 04.04.2017 -->
<element integrity="true" desc="PNRORT" externalJoin="true" label="PNRORT" name="PNRORT"
revLink="recipient" target="dkb:CRM_AL_ADRESSE_POST" type="link">
<join xpath-dst="@PERS_NR" xpath-src="@PersNr"/>
</element>
<!-- Test für den Join -->
This join works fine when you are are searching for instance for the first name, last name and city, which is linked in the joined view.
But when I try do set a filtering statement for instance "city = 'Berlin'" then I got a error message like this.![Filtering2.PNG Filtering2.PNG](/t5/image/serverpage/image-id/5746i2E9A05525F94C9FB/image-size/large?v=v2&px=999)
![Filtering1.PNG Filtering1.PNG](/t5/image/serverpage/image-id/5747iAB9853E9424DC59D/image-size/large?v=v2&px=999)
It seems, that the missing external table can not be inserted in the from clause of the SQL statement.
Is this a bug ?