Skip to main content
johnc79434800
New Participant
Aug 28, 2019 10:49 PM UTC
Solved

Data Schemas - filtering FDA table data

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.
johnc79434800Accepted solution
New Participant
Sep 3, 2019 3:28 AM UTC

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 reply

1 reply

johnc79434800AuthorAccepted solution
New Participant
Sep 3, 2019 3:28 AM UTC

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>
Translate
Terms & ConditionsAccessibility statement

Loading footer...