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: find_by_sql
Start stalled workflows from beginning
When workflows stall, they get stuck on the stage that caused the issue. Many times over it is useful to start the workflow from the start – a complete re-run. But there is no way to do that in the … Continue reading
Workflow service borked! Again!
Workflow service is extremely useful and extremely fragile. About once a month I get a call from a customer with the problem that boils down to Workflow Service not operating. Today I just had to see what is sitting in … Continue reading
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
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
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