Skip to Content
avatar image
Former Member

UNIONS - XML lists two tables

How come when I build a UNION action in BLS and test it using either the XML query or Xacute query, I see two tables? When I go to use this data, will I be able to treat this data as if it is one table like SQL would allow me?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 07, 2007 at 05:34 PM

    Regardless of what you see when you test the query, the applets will still treat it as a single table, typically.

    - Rick

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 07, 2007 at 02:59 PM

    The UNION action block will create two Rowsets of data. This is why you are seeing two HTML tables when you test the Query.

    I am assuming both HTML tables have the same columns. If you really want these two tables as one table, you probably don't want to use the Union block but instead a Repeater that adds rows to a separate IllumDoc.

    On the output side, you can specify which Rowset to use in a display template buy filtering with XPATH in a style sheet like \Rowsets\Rowset[2]\Row\item.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 07, 2007 at 03:03 PM

    Hi

    You can try this approach also.

    If you want to merge two tables than also you can use joiner action block.

    There is option to join as inner or outer join.So this way single output will come.

    Best Regards

    Ramshanker

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      If joiner is not suitable for purpose than take Union.

      After doing union if you run xcute query ,it will show you two tables but you can show this result in single Grid.

      How you want to display result ?

      Best Regards

      Ramshanker Upadhyay