Page 1 of 1
Schedule Date of a Job
Posted: Fri Jul 19, 2024 7:42 am
by gautam_syncezy
Hi All,
Need urgent help, in which table in the database can I find the 'Schedule Date' column for any job. Kindly help!!
Regards,
Abhinav
Re: Schedule Date of a Job
Posted: Mon Jul 22, 2024 12:54 am
by SimproAPITeam
Hi gautam_syncezy,
we don't answer database-related enquiries on this forum, maybe try referring to the Simpro Premium BI Reporting to have a better understanding of the relations.
Re: Schedule Date of a Job
Posted: Mon Jul 29, 2024 4:32 am
by gautam_syncezy
Hi SimPRO team,
You answered this question before about a database query we had on 28 May:
viewtopic.php?f=2&t=2519&p=6755&hilit=abhinav#p6755
Can you check again or direct us to the right resources to check queries on SimPRO's data warehouse? We need this query answered quite urgently.
Re: Schedule Date of a Job
Posted: Mon Jul 29, 2024 4:55 am
by spolacsek
Code: Select all
select date, start_time from simpro_schedules where job_id = 12345
Re: Schedule Date of a Job
Posted: Mon Jul 29, 2024 6:58 am
by gautam_syncezy
Hi @spolacek,
Thanks for your response, but simpro_schedules is not a table in the database. I checked just schedule and I did not see any "start_time" in it.