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: structure
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 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
Subscribe community to a user
I’ve been asked today by one of the reader “How to subscribe a user to a community though a back-end”. And here is the answer to the question: There is a stored procedure that will do that for you. The … Continue reading
List users per role
Admin Console of HR.Net allows only to list users by their primary role. And secondary roles are in a shade. To display all users that belong to a particular role (primary or secondary) you can use this bit of sql: … Continue reading
Table definitions
For those of you wanting to know where HRNET stores meta information about tables and table-fields: look into oc_fileddefs for field definitions – type of data, validation, etc. For field captions and descriptions go to oc_filedlanguages.