0
edits
Changes
Created page with 'The result data set from a report can be used as criteria for another report using the following syntax: :<font size="3">'''@Report[''reportid'',''column #'',''data type'']@…'
The result data set from a report can be used as criteria for another report using the following syntax:
:<font size="3">'''@Report[''[[reportid]]'',''column #'',''data type'']@'''</font>
where data type is 0 for numbers and 1 for text
on report one (id=12345) - select tracking id, firstname, lastname from funding uta where userid=@userid@ (current user) and rolename="Conflict"
This return all item where current user is in conflict.
on report two -select tracking id, funding name, panel name from funding uta, panel uta where panel user=current user
This return all funding item where current user is in panel committee.
Next step is to put report one as a criterion on report two.
userid=@userid@ and userid NOT IN( @Report[12345;1;0]@ )
where 12345 is the report id, 1 means use the data in the 1st column (there are 3 columns on report one) and 0 means the column contains numbers.
[[Category:Reports]]
:<font size="3">'''@Report[''[[reportid]]'',''column #'',''data type'']@'''</font>
where data type is 0 for numbers and 1 for text
on report one (id=12345) - select tracking id, firstname, lastname from funding uta where userid=@userid@ (current user) and rolename="Conflict"
This return all item where current user is in conflict.
on report two -select tracking id, funding name, panel name from funding uta, panel uta where panel user=current user
This return all funding item where current user is in panel committee.
Next step is to put report one as a criterion on report two.
userid=@userid@ and userid NOT IN( @Report[12345;1;0]@ )
where 12345 is the report id, 1 means use the data in the 1st column (there are 3 columns on report one) and 0 means the column contains numbers.
[[Category:Reports]]