If we need to reset transmission flag to nova by huge samples , run the query as below and save as CSV to get the all the specimenID.
select array_to_string(array_agg(specimenid::integer), ‘,’) from patient_specimens where date(registerdate) between ‘2020-07-17‘ AND ‘2020-07-20‘ AND status ilike ‘%RP%’ AND registeredby ilike ‘%NOVA%’
Change the date in blue.
Open your csv and the content should be something like below.
Copy the sample ID and add to URL below.
If you using the URL from client PC:
http://ipaddressserver:18080/chemolims/service/nova-process.jsp?mode=generateResult&sampleid=4208791,4208803,4208802,4208800,4208785,4208784,4208846,4208808,4208809,4208798
If you using the URL from main server
http://localhost:18080/chemolims/service/nova-process.jsp?mode=generateResult&sampleid=4208791,4208803,4208802,4208800,4208785,4208784,4208846,4208808,4208809,4208798
