• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
    •

    Table to find out custom forms associated with a protocol

    Technical Questions
    #1

    Posting on behalf of Jitendra @ UNSW:

    Hi Poornima,

    Thanks for quick reply. Another question what is the table I need to refer to check whether there any DEs created for a protocol ?

    -JJ

    #2

    Hi Jitendra,

    Please use below query to find all forms with their associated protocol titles:
    select caption, title from catissue_form_context fc
    join dyextn_containers c on c.identifier = fc.container_id
    left join catissue_collection_protocol cp on cp.identifier=fc.cp_id
    where
    fc.entity_type is null or fc.entity_type != ‘Query’

    If the protocol title is null in the results, it means that the form is associated with all protocols.

    You can add condition for protocol title if you want for specific protocol.

    Thanks,
    Poornima