I am trying to use VARA_XML in PromptSet. The XML is:
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?