Schedule Date of a Job

Posts about the simPRO API. Help/support/how-to etc.
Forum rules
  • Check the documentation first. Before posting questions, please check the documentation to ensure it doesn't already cover what you need.
  • No spam. All automated messages, advertisements, and links to competitor websites will be deleted immediately.
  • Post in relevant sub-forums only. Messages posted in the wrong topic area will be removed and placed in the correct sub-forum by moderators.
  • Respect other users. No flaming or abusing fellow forum members. Users who continue to post inflammatory, abusive comments will be deleted from the forum after two warnings are issued by moderators.
  • Harassment. No threats or harassment of other users will be tolerated. Any instance of threatening or harassing behavior is grounds for deletion from the forums.
  • Adult content. No profanity or pornography is allowed. Posts containing adult material will be deleted.
  • Bandwidth. All images and signatures must be 500 x 500 pixels or smaller. Posts containing over-sized images and signatures will be removed.
  • Illegal content. No re-posting of copyrighted materials or other illegal content is allowed. Any posts containing illegal content or copyrighted materials will be deleted.
Post Reply
gautam_syncezy
Posts: 12
Joined: Tue Nov 29, 2022 3:59 pm

Schedule Date of a Job

Post by gautam_syncezy » Fri Jul 19, 2024 7:42 am

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
Top
SimproAPITeam
Posts: 831
Joined: Wed May 01, 2024 2:31 am

Re: Schedule Date of a Job

Post by SimproAPITeam » Mon Jul 22, 2024 12:54 am

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.
Simpro API Team | Simpro Software Group
Top
gautam_syncezy
Posts: 12
Joined: Tue Nov 29, 2022 3:59 pm

Re: Schedule Date of a Job

Post by gautam_syncezy » Mon Jul 29, 2024 4:32 am

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.
Top
spolacsek
Posts: 52
Joined: Fri Aug 10, 2018 1:33 am

Re: Schedule Date of a Job

Post by spolacsek » Mon Jul 29, 2024 4:55 am

Code: Select all

select date, start_time from simpro_schedules where job_id = 12345
Top
gautam_syncezy
Posts: 12
Joined: Tue Nov 29, 2022 3:59 pm

Re: Schedule Date of a Job

Post by gautam_syncezy » Mon Jul 29, 2024 6:58 am

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.
Top
Post Reply

Return to “General Discussion”