How to get details on CALs from metadata?

[Anonymous]

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.

[#2]

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';

[Anonymous]

Hi,

Many thanks.

Here I have one doubt, from which meta file I can get this data.

[#4]

you can do a loop loading each *.meta file

(dont you have *.meta file?)

[whiteline]

These files are located in the same directory on server as your .qvw file.

[Anonymous]

I found them.. many thanks.

[whiteline]

Think you can close the question and mark "Pari Pari's" solution as right.

[Anonymous]

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.

[whiteline]

Ah,

You can use foreach statement to parse all files one by one.

See foreach in help.