w_date=$(date '+%Y_%m_%d_%H_%M_%S') nb_jour=$1 # Nombre de jour
cmd=$(mysql -u redsrv -pmotdepasse redmine --skip-column-names << EOF select concat('RAILS_ENV=production rake redmine:plugins:project_extras:reminder_by_ids issues="',group_concat(t1.id SEPARATOR ' '),'" message="blabla" user="ET"') from issues t1 where datediff(current_date , t1.updated_on) <= $1; EOF) echo $cmd $cmd