Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to get CALs assigned to each document from metedata. I have tried to check details from xml files avaialble in QVPR. But exact details are not avaialble. Can anyone advice me how to get CALs and user details from metadata.
try:
LOAD
filename() as Document,
@1 as User
FROM
(txt, codepage is 1252, no labels, delimiter is spaces, msq, filters(
Transpose()
))
Where left(@1,1) = 'Q';
Hi,
Many thanks.
Here I have one doubt, from which meta file I can get this data.
you can do a loop loading each *.meta file
(dont you have *.meta file?)
These files are located in the same directory on server as your .qvw file.
I found them.. many thanks.
Think you can close the question and mark "Pari Pari's" solution as right.
I want to track Document CALs allocated/assigned to document and for each document how many named CALS and Document CALS assigned..So for these details I am trying to check in xml files..
Please help to advice.
Ah,
You can use foreach statement to parse all files one by one.
See foreach in help.