Tag Archives: find_by_sql

Find workflows/mailers with particular subject

Sometimes I get support requests quoting an email received from HR.Net and asking to modify that email text or add more recipients. And then I need need to find that workflow containing the mailer that sent out that particular message. … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

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

Posted in Uncategorized | Tagged , | Leave a comment

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

Posted in Uncategorized | Tagged , | Leave a comment

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

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

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

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

Posted in Uncategorized | Tagged , , | Leave a comment

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

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