Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Filtering in the query editor failed

tristanr1339829
Level 2
Level 2

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.PNGFiltering1.PNG

It seems, that the missing external table can not be inserted in the from clause of the SQL statement.

Is this a bug ?

0 Replies