Data Schemas - filtering FDA table data

Avatar

Avatar

johnc79434800

Avatar

johnc79434800

johnc79434800

28-08-2019

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

johnc79434800

Avatar

johnc79434800

johnc79434800

02-09-2019

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>

Answers (0)