[2023-10-17 21:51:57] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-000000000000202022.1.7.105192023-10-17T21:51:57.359Z2023-10-17T21:56:57.359Z0No Error8d721b93-6de5-4c9f-bc40-b7c44c260e61mariano.rossin@gmail.comMarianoRossin3c934aae-25b0-4905-9a93-d2626cde96e16106-08-07T07:00:00"} [] [2023-10-17 21:51:58] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.com3c934aae-25b0-4905-9a93-d2626cde96e1\n"} [] [2023-10-17 21:52:00] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.7.105192023-10-17T21:51:59.886Z2023-10-17T21:56:59.886Z0No ErrorFirm Prueba Mariano
Los Ceibos 2731San Jose of The CornerIL23121US
3425290600"} [] [2023-10-17 21:52:00] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.com3c934aae-25b0-4905-9a93-d2626cde96e18d721b93-6de5-4c9f-bc40-b7c44c260e61\n"} [] [2023-10-17 21:52:01] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.7.105192023-10-17T21:52:01.506Z2023-10-17T21:57:01.506Z0No Errormariano.rossin@gmail.comMarianoJorgeRossin2023-10-17T21:51:57.267FilerFirmAdminfalsefalse"} [] [2023-10-17 22:01:07] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, fem.envelope_id, fem.filing_status_code from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where cd.is_draft = 0 AND va.created_at >= "2023-09-17 00:00:00" AND va.created_at <= "2023-10-17 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-17 22:01:14] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, fem.envelope_id, fem.filing_status_code from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where cd.is_draft = 0 AND va.created_at >= "2020-09-17 00:00:00" AND va.created_at <= "2023-10-17 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-17 22:01:25] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, fem.envelope_id, fem.filing_status_code from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where cd.is_draft = 0 AND va.created_at >= "2020-09-17 00:00:00" AND va.created_at <= "2023-10-17 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-17 22:01:42] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, fem.envelope_id, fem.filing_status_code from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where cd.is_draft = 0 AND fem.filing_status_code = 'rejected' AND va.created_at >= "2020-09-17 00:00:00" AND va.created_at <= "2023-10-17 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-17 22:01:45] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, fem.envelope_id, fem.filing_status_code from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where cd.is_draft = 0 AND va.created_at >= "2023-09-17 00:00:00" AND va.created_at <= "2023-10-17 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-17 22:01:52] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, fem.envelope_id, fem.filing_status_code from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where cd.is_draft = 0 AND va.created_at >= "2020-09-17 00:00:00" AND va.created_at <= "2023-10-17 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-17 22:01:57] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, fem.envelope_id, fem.filing_status_code from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where cd.is_draft = 0 AND fem.envelope_id = 23346373 AND va.created_at >= "2020-09-17 00:00:00" AND va.created_at <= "2023-10-17 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-17 22:03:58] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, fem.envelope_id, fem.filing_status_code from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where cd.is_draft = 0 AND va.created_at >= "2020-09-17 00:00:00" AND va.created_at <= "2023-10-17 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-17 22:04:05] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, fem.envelope_id, fem.filing_status_code from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where cd.is_draft = 0 AND va.created_at >= "2020-09-17 00:00:00" AND va.created_at <= "2023-10-17 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-17 22:17:29] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, fem.envelope_id, fem.filing_status_code from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where cd.is_draft = 0 AND va.created_at >= "2020-09-15 00:00:00" AND va.created_at <= "2023-10-17 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] []