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?
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
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.
I don't know how to only get the last-name without the <award> tag.