Automic Workload Automation

Expand all | Collapse all

xPath/xQuery with UC4 Object Var

  • 1.  xPath/xQuery with UC4 Object Var

    Posted 07-11-2018 08:37 AM

    Hi,

     

    I am trying to use VARA_XML in PromptSet. The XML is:

     

        <BOOK>
            <name>Learning_Java</name>
            <author>James_Clark</author>

            <author>Ken_Follett</author>
            <author>Steven_King</author>
        </BOOK>
        <BOOK>
            <name>7_Habits</name>
            <author>Steven_Covey</author>
        </BOOK>

    and I have a PRPT with two fields:

    1- ComboBox to list all books. so the XPath/XQuery for it is book/name and it lists all books and it assigns the result to &BOOK#

    2- Checkbox to show all authors of a book. the XPath/XQuery for it is book/author[name=&BOOK#] but this doesn't work even if I replace &BOOK# with static value like  "7_Habits". I also tried to use ' and " around &BOOK# but I got the same result, no data returned.

     

    Can any body help with that?

     

    Thanks

    Hesham



  • 2.  Re: xPath/xQuery with UC4 Object Var

    Posted 07-11-2018 05:13 PM

    Hi,

     

    I have tried the following XPath and it seems to work. I don't believe we can add AE variables in the Xpath. I will do some research and get back to you by Friday.

    .//BOOK[name = "7 Habits"]/author



  • 3.  Re: xPath/xQuery with UC4 Object Var

    Posted 07-11-2018 07:05 PM

    Hi HeshamMahmoudElSheikha604412 ,

     

    We can use variables in prompt sets. They have to be of type combo box with the option 'Dynamic reload' checked.

    If created an example here with a different xml that gives me more tags than I want.

    Maybe someone with more XPath skills can fix this.

     

    First prompt:

     

    Second prompt:

    Result:

     

    I don't know how to only get the last-name without the <award> tag.

     

    Cheers,

    Alexander