Category Archives: SQL Server

Picklist search

Sometimes it is handy to have a deeper look on the HR.Net Picklists. Picklists are set values of text data. Opposing to plain text fields, picklists can have only set number of values and can not be easily changed by … Continue reading

Posted in Admin Console, SQL Server | Tagged , , | Leave a comment

Screen changes do not go through

After the update to HR.Net 3.0 we encountered a new problem: changes to screens/workflow forms done in Admin Console did not come up on the actual front-end. In the previous version it took about a minute to get the updated … Continue reading

Posted in Admin Console, Applications Server, SQL Server | Tagged , , | Leave a comment

Change the start number of autogenerated field value

Sometimes you have auto-generated fields in tables. Most of the times this field is a ID-number of an item. And not every time you want to start numbers from 0. For example, I have to export some historic data into … Continue reading

Posted in SQL Server | Tagged | Leave a comment

How to associate a SQL hrnet user correctly

The hrnet SQL user attached to the hrnet database is not synchronised with the hrnet SQL user correctly on the server The following symptoms can occur: 1. When logging in to the HR.net web application the screen brings up a … Continue reading

Posted in SQL Server | Leave a comment

Workflow stage is out of reach on the screen

When you have a very complex workflow and it is bigger than your screen, in older versions (before 3.0.2) of HRNET you won’t be able to access the stages sitting outside your screen. This is a known bug in the … Continue reading

Posted in Admin Console, SQL Server | Tagged | Leave a comment