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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Data Schemas - filtering FDA table data

Avatar

Level 1

I am trying to understand whether it is possible to define multiple data schemas over the same FDA table, but each one returning a different subset of data.

If this is possible, how can it be achieved (what are the xml directives to use, and any limitations or traps to be aware of).

Thank you.

1 Accepted Solution

Avatar

Correct answer by
Level 1

I can now answer my own questions:

  1. Is it possible to define multiple data schemas over the same FDA table?

    A: Yes.  As many as you like.

  2. Returning different subsets of data for a given schema:

    A: Code as follows in the schema xml:

    <sysFilter><condition expr="@field in ('val1','val2')"></sysFilter>

View solution in original post

1 Reply

Avatar

Correct answer by
Level 1

I can now answer my own questions:

  1. Is it possible to define multiple data schemas over the same FDA table?

    A: Yes.  As many as you like.

  2. Returning different subsets of data for a given schema:

    A: Code as follows in the schema xml:

    <sysFilter><condition expr="@field in ('val1','val2')"></sysFilter>