IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  queries on joins

    Posted Wed August 15, 2001 11:46 AM

    Hello,

    We have some problems using the predefined joins.

    Here is an example of one our query on a join (using key):
    In this query we try to gather information about the projects (PROJET) a person (PERSONNE) is assigned to, using the person’s name (NOM) as a parameter and asking the project’s subject (SUJET_PROJET) as a response:

    /TUTEUR[@NO_PERS/IDREF_PERS/NOM=‘Nastasi’]/@NO_PROJ/IDREF_PROJ/SUJET_PROJET

    Where TUTEUR is the name of the join Doctype, IDREF_PERS(join to the doctype PERSONNE using the attribute NO_PERS) and IDREF_PROJ (join to the doctype PROJET using the attribute NO_PROJ) are the objects in the schema that represent the joins (we can send you the schema files if necessary).

    We have some problems when we make this kind of query on our predefined joins, the result is sometimes quite unexpected like:
    1- Data that is not associated with the key we made the query on (random data) is returned
    2- Only one result (of many) is returned when we make a query on a specific join

    It seems that, from a join, we cannot go through two doctype trees at the same time. Is it normal?


    #webMethods
    #API-Management
    #Tamino