KBA-01761: Predefined Route Extension
Question: Can we apply logic to the result of predefined routes? Answer: Yes. If the SQL object [custom].pu_DocRouteCheck exists, it…
Read more
Tag Archive: SQL
KBA-01759 Validation and Document Logic Overview
Questions: How do ATC Workflow and Save Extensions interact? Can I use both ATC Workflow and Save Extensions? I want to…
Read more
KBA-01711: Data Layer Housekeeping Extension Scripts
Question: How can I have the system data layer run some script every time the web application starts up? Answer:…
Read more
KBA-01683: Site Register Setup
Question: sfPMS ships with two registers: The Change Item Register and the Submittal Item Register. Can I set up a…
Read more
KBA-01681: Migrating to a new SQL Server Reporting Server
Question: Are there any tricks to migrating reports, particularly custom reports from a legacy server to a new SSRS server…
Read more
KBA-01667: Register Now Exclusive to Another User
Question: When I tried to save a new Item on my Change Order document, I got a message Cannot add…
Read more
KBA-01658: Handling Payment Over Contract Amount via Approval Extension
Question: Can we invoke extra processing if a payment exceeds the current contract amount? Answer: Yes. The scenario goes something…
Read more
KBA-01652: Windows Credentials and SSRS Setup for sfPMS
Question: What Microsoft Windows credentials does the Spitfire configuration require? How do I setup Access Rights to SSRS for use by…
Read more
KBA-01635: Dynamics SL CST files not Running
Purpose & Scope: Microsoft Dynamics SL customizations are not opening, and VBA Code appears with the message: Compile Error: User-defined…
Read more
Full Text Indexing Report
This report summarizes the SQL full text indexing being used. Note: although the image above does not show the Output…
Read more