Author Archives: admin

Find a Report By Name

It’s been a while since the last post. But the blog is not dead, I keep working with HR.Net and when I find good enough reason to post here, I do. Here is the new gem I had to discover. … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Find all workflows that use a picklist, by picklist name

One of my readers did ask if there is a way to find all the workflows that use a particular picklist. A little bit of digging and here you go: select pppf.folder_name as [Folder], ppf.folder_name as [Folder], pf.folder_name as [Folder], … Continue reading

Posted in Uncategorized | Tagged , , , , | Leave a comment

Lost a picklist? Find it with a query

Many times over I did spend a lot of time looking for a particular picklist. I know the name, but have no idea what folder it is in. And if you have more than just a few of them, it … Continue reading

Posted in Uncategorized | Tagged , | 3 Comments

Yet Another Successful Project

And yet another successful project with HR.Net is coming to an end. Oh how I miss those sleepless debugging nights and clients with tears of joy! Anyway, I’d like to remind my readers that I am available to work on … Continue reading

Posted in Uncategorized | 2 Comments

Find all workflows that email particular address

Quite often people within organisation change roles or leave. And if your HR.Net workflows were programmed to email that person, you’ll have to go into these workflows and change the address. But if you have thousands of workflows? you don’t … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Switch to Attached Documents Page

A while back, when I worked with HR.Net version 3, I came up with a bunch of random JavaScript hacks. Now I’m working with version 4. JavaScript API has been changed and some of my tricks do not work in … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

Autosave a screen

I had a question asked ages ago about Auto-Save of a screen. And Dan Hutson have just posted an answer to this question: // auto-save after this many minutes var countDown = 15; // get current time at screen load … Continue reading

Posted in Uncategorized | Tagged , , , , | Leave a comment

Wild-card for searches

Some things in my work I take for granted and don’t realise that can be not obvious. One of my readers Steph noted, HR.Net uses percent sign % as a wild-card in searches. So whenever you do search for a … Continue reading

Posted in Uncategorized | 4 Comments

jQuery

In case you have not realised, HR.Net is using jQuery for some of it’s functionality on screens. So power of jQuery is at your mercy when you write the Custom Scripts for the screens. Shame that the version of jQuery … Continue reading

Posted in Uncategorized | Tagged , , , | 7 Comments

Find screen by base table

Find all the screens that modify particular table select pppf.folder_name as [Folder], ppf.folder_name as [Folder], pf.folder_name as [Folder], f.folder_name as [Folder], scr_lang.SCREENNAME, scr_lang.DESCRIPTION, scr.* from OC_SCREENS scr inner join OC_SCREENLANGUAGES scr_lang on scr.SCREENID = scr_lang.SCREENID left join OC_ADMINCONSOLE_FOLDERS f on … Continue reading

Posted in Uncategorized | Tagged , | 3 Comments