Latest Music Additions - Print/Report

[Argo82]

Hi Everyone,

Looking for a way to create a report to show the most recent music additions, or creating a report to display the files added between 2 dates. Can this be done? If so how?

[Marius]

Hello, you can use this report template to generate the list of latest 100 imported files: https://radiodj.ro/dw/General - Newest Files.zip
Unzip the file and place it in "C:\RadioDJv2\templates\reports\" folder. From the left filters, select the "General - Newest Files" template and "Sorty By" "Date Added" and "Descending".

By default it will list 100 results, if you need more, open the template in notepad or notepad++ and locate this code:

Code Select Expand

<!-- MySQL query block. The output table columns are buit using this query. Don't use double quotes here! -->
<meta name="query" content="
SELECT
s.date_added As 'Date Added',
s.artist As 'Artist',
s.title As 'Title',
SEC_TO_TIME(ROUND(s.duration)) As 'Duration',
s.song_type As 'Type',
category.name As 'Category',
subcategory.name As 'Subcategory',
genre.name As 'Genre'
FROM songs s
INNER JOIN subcategory ON subcategory.ID=s.id_subcat
INNER JOIN genre ON genre.ID=s.id_genre
INNER JOIN category ON category.ID = subcategory.parentid
%where% %orderby% LIMIT 100;
">

Note the last part "LIMIT 100", there you can change to whatever value you want.

[rkriggs]

I use it this way..
In the radiodj software utilities reports general library files and pick the date.
Randy