Loading...

Function Topics

Comments

3 comments

  • Pat Falkner

    Once you assign a topic to the event, how is that relationship stored?

    What field in the EV200_EVENT_MASTER tells me which of the topics from the EV730_TOPICS table were selected or associated with a particular event?

  • Sean Tame

    Hi Pat,

    Have you tried looking in EV250_ABSTR_TOPICS - Contains the master list of topics used when processing abstracts. These topics may or may not be associated with an event.

    or 

    EV269_MGR_TOPICS - Contains all of the event abstract topics that an event abstract manager is responsible for.

  • Pat Falkner

    Well, I found a way to get the values but not sure it is the most efficient. I link up to the EV251_TOPIC_CROSSREF on the ORG_CODE and EVENT_ID

    SELECT dbo.EV200_EVENT_MASTER.EV200_ORG_CODE, dbo.EV200_EVENT_MASTER.EV200_EVT_ID, dbo.EV730_TOPICS.EV730_TOPIC_DESC
    FROM dbo.EV730_TOPICS INNER JOIN
    dbo.EV251_TOPIC_CROSSREF ON dbo.EV730_TOPICS.EV730_TOPIC_ID = dbo.EV251_TOPIC_CROSSREF.EV251_TOPIC_SEQ AND
    dbo.EV730_TOPICS.EV730_ORG_CODE = dbo.EV251_TOPIC_CROSSREF.EV251_ORG_CODE RIGHT OUTER JOIN
    dbo.EV200_EVENT_MASTER ON dbo.EV251_TOPIC_CROSSREF.EV251_ORG_CODE = dbo.EV200_EVENT_MASTER.EV200_ORG_CODE AND
    dbo.EV251_TOPIC_CROSSREF.EV251_EVENT_ID = dbo.EV200_EVENT_MASTER.EV200_EVT_ID

Please sign in to leave a comment.