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
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
Find workflows triggered on particular fields
This blog is not dead! It’s been a while since my last post here, but I’m back with some fresh ideas and scripts. Thanks to my new assignment with HR.Net. If you would like to find all the workflow triggers … Continue reading
Find screens that edit particular field in a table
As a follow-up from yesterday post about finding workflows that change field in a table, today I needed to find all the screens that contain particular field from a table. Here is the SQL query: select pppf.folder_name as [Folder], ppf.folder_name … Continue reading
Find workflows that change particular table field
Today my task was to find out what workflows are changing particular field within particular table. I could go through all the workflows and all the data-writers and check. But I have hundreds to choose from, I’ll spend all day … Continue reading