> I know this is more of an XPATH issue but please...What am I doing wrong?
You can either return an array of model names, or change your context item to be the model:
XMLTABLE('/vdb/model' PASSING XMLPARSE(DOCUMENT f.file) COLUMNS ModelName string PATH '@name') a
Thanks... that did it... I am was able to finish that task and get other properties as well!
Getting past that... now I'm trying to get the data-role info including permission, associated resource-name (model) and the various properties (allow-create, allow-read, etc)
Since permission is nested under data-role, how can that be done?
It all just depends on what you want to iterate over. If you want to iterate on permissions, then use that as your context item. Then if you need that correlated to role information you can have a column that references parent information RoleName string PATH '../@Name'