queries.sh

pm2 start backlog.js --no-autorestart --name "ous" -- "select organisationunitid,uid,code,created,lastupdated,lastupdatedby,name,shortname,parentid,path,hierarchylevel,description,openingdate,closeddate,comment,url,contactperson,address,email,phonenumber,userid,translations,attributevalues from organisationunit;" "organisationunitid,uid,code,created,lastupdated,lastupdatedby,name,shortname,parentid,path,hierarchylevel,description,openingdate,closeddate,comment,url,contactperson,address,email,phonenumber,userid,translations,attributevalues" "organisationunit"
pm2 start backlog.js --no-autorestart --name "psi" -- "select o.uid ou,o.name,o.path,psi.programstageinstanceid::text,psi.uid,to_char(psi.created,'YYYY-MM-DD HH:mi') created,to_char(psi.created,'MM') month,to_char(psi.lastupdated,'YYYY-MM-DD HH:mi') lastupdated,programinstanceid::text,programstageid::text,attributeoptioncomboid::text,psi.deleted,psi.storedby,to_char(duedate,'YYYY-MM-DD HH:mi') duedate,to_char(executiondate,'YYYY-MM-DD HH:mi') executiondate,psi.organisationunitid::text,status,completedby,to_char(completeddate,'YYYY-MM-DD HH:mi') completeddate,eventdatavalues,assigneduserid::text,psi.createdbyuserinfo,psi.lastupdatedbyuserinfo from programstageinstance psi inner join organisationunit o using(organisationunitid) where psi.created >= '2022-01-01';" "programstageinstance"




node backlog.js "select organisationunitid::text,uid,code,created,lastupdated,lastupdatedby::text,name,shortname,parentid::text,path,hierarchylevel,description,openingdate,closeddate,comment,url,contactperson,address,email,phonenumber,userid::text,translations,attributevalues from organisationunit;" "organisationunitid,uid,code,created,lastupdated,lastupdatedby,name,shortname,parentid,path,hierarchylevel,description,openingdate,closeddate,comment,url,contactperson,address,email,phonenumber,userid,translations,attributevalues" "organisationunit"