Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
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>