Useful SQL
We've had a couple of calls recently where users have been able to load a CV in to IQX when adding a new candidate but when they go to the CV tab in IQ...
Thu, 21 Jun, 2018 at 10:27 AM
Run in SQLTool to see what time the nightly backup for Monday, Wednesday and Friday starts. Change MWF to TTS for the second backup in a routine. This wi...
Thu, 21 Jun, 2018 at 10:30 AM
INSERT INTO WPKAssignedRole (OwnerID, WPKRoleID) ON EXISTING SKIP SELECT Staffid, 'HIDEPP45' FROM Staff
Thu, 21 Jun, 2018 at 10:31 AM
Select * from person where name = ‘xxx’ to get personid Then select * from blobstore where class='j' and id= <personid> double check thi...
Thu, 21 Jun, 2018 at 10:32 AM
After a Server move clients that link images to their timesheets will need the file paths updated so that images that were linked before the server move can...
Thu, 21 Jun, 2018 at 10:36 AM
This contains information on how to add in missing info to the shared tables and how to set the transfer batch back if it needs to be re-run MISSING INFO ...
Thu, 21 Jun, 2018 at 10:37 AM
Find candidates who were last updated in a certain year e.g. 2009; select * from person where changedate = '2009' Update the date of an individ...
Wed, 18 Jul, 2018 at 10:10 AM