Creating a "report" / article of uploads
Posted: 01 Mar 2010, 20:04
Hi All,
Now that I have started to use Phoca, I would like to create a "report" / article doing the following:
Selecting a single section: (i.e.; "Music")
Then selecting some (but not all) of the categories: (i.e., "Repertoire" and "Holiday", but NOT "Bonus".
Then listing all of the file names.
The Article should look like this:
Repertoire:
My Gal Sal.pdf
sweet_adoline.pdf
Holiday:
silent_night.pdf
jingle_bells.pdf
It would be nice to include any notes that go with it. If I can't do this in Phoca, does anyone know how I can access the database with SQL and put the results in an article?
Thanks,
jws
Now that I have started to use Phoca, I would like to create a "report" / article doing the following:
Selecting a single section: (i.e.; "Music")
Then selecting some (but not all) of the categories: (i.e., "Repertoire" and "Holiday", but NOT "Bonus".
Then listing all of the file names.
The Article should look like this:
Repertoire:
My Gal Sal.pdf
sweet_adoline.pdf
Holiday:
silent_night.pdf
jingle_bells.pdf
It would be nice to include any notes that go with it. If I can't do this in Phoca, does anyone know how I can access the database with SQL and put the results in an article?
Thanks,
jws