Wish list
If you like this blog and want to say thanks in some way, here is my wish-list on Amazon. It'll be very cool to get a gift from my subscribers. Just don't forget to put your name on it -)Tags
Tag Archives: sql
Find all users in a role
You know, HR.Net users have a primary role that defines their level of access to the data. Also there are many additional roles that allow to do other stuff, like using of navigator. But additional roles don’t give any data-permissions. … Continue reading
Updating of tables ends up with a messy error message about incompatible type
After modifying one of tables in C.Net I ended up with an error message saying “Incompatible type blah-blah-blah” on table save (sorry, don’t have exact words or screenshot). Turned out that I have changed type of one of the fields … Continue reading
Convert Report to be Landscape
Today I had to make a new report in HR.Net Document Explorer. Unfortunately version of HR.Net I’m using is buggy. Every time you try to view a report preview, it crashes: Vizual claims that this error is because I’m running … Continue reading
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
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
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
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
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
Find workflows by name
Ever tried to look through all the folders with workflows searching the one that fails? Know only the name? Use this sql to show you folder names and workflows mathing the name search. select pppf.folder_name as [Folder], ppf.folder_name as [Folder], … Continue reading
Find screens by name
Ever struggled to find the screen called “something” in a tree of folders? This script will give you full location of the screen with all the folders. Just change the name in the where-clause and run this against the HRNET … Continue reading