Data Schemas - filtering FDA table data | Community
Skip to main content
August 28, 2019
Solved

Data Schemas - filtering FDA table data

  • August 28, 2019
  • 1 reply
  • 1083 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by johnc79434800

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>

1 reply

johnc79434800AuthorAccepted solution
September 3, 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>