For Oregon Department of Transportation (ODOT) projects, contracts and subcontracts:
If you, in any capacity, have access to ODOT’s ProjectWise datasources, this ProjectWise add-on may be helpful for you to deliver work in a timely manner and in compliance with ODOT’s naming convention. This add-on installs logic which drives a document's name and description based on its custom attribute data. ODOT's previously…
It isn't always obvious which hooks you might want to use for one or more user actions in ProjectWise Explorer. You typically guess what the name of the hook is and try to locate it in the documentation. Sometimes there are hooks available that you might not realize that are being called or might be of use to you.
Recently I was trying to determine what my options were for a customization that I need to create, and…
I have been trying to figure out how do determine the path to a given folder with a SQL query for a long time. Finally I had a project where I really need this ability so I searched online for something similar.
Eventually I found this: Dump list of full paths of parent/child type records in SQL Server 2008 R2
Which I changed to look like this:
USE PWDemoMSSQLGOWITH folder_paths (o_projectno, folder_path)AS(-- Anchor…