Sometimes either the support team or a knowledge-base article will require you to apply some SQL code to make some changes to data or the database structure. To do this the Web Portal for the NX Server provides an SQL Manager interface to paste in or load from file SQL code that can then be executed. To do this, please follow these steps:
- Log on to the web interface for the Hiretrack NX server to update the database. If you are at the server machine you can enter http://127.0.0.1:10088 as the address into a web browser.
If you are not at the server , when you log onto the NX client it shows you the server address on the splash screen as NavigatorNX@192.168.0.15, for example. In which case you should enter http://192.168.0.15:10088 as the address.
- On the top right of the page is the link to the 'SQL Manager' click on the link and use the same username and password as before.
- Select the Alias for the current database you are using and paste into the SQL edit area the code you need to run, overwriting the 'Select * From' text that appears by default. Alternatively, if you have been given the code in an .SQL or .TXT file then you can "Choose File" and the click "Now Load Chosen File" to load it's code into the SQL edit area.
- You are now ready to go. Press the "Execute SQL" or "Backup and Execute SQL" button to run the code. Some code will run very quickly, other code may take some time. Please be patient in the case of the latter. Some browsers will indicate that processing is taking place with a spinning "loading/working" animated icon on the tab for the web page. You will know that code has completed with either a set of results being displayed at the bottom of the main edit area (for a SELECT SQL statement) or Query Execution Complete will appear for other types of SQL statement:
Example of completed SELECT SQL statement
Example of UPDATE SQL statement