DriveWorks Pro 17: Change Log [send feedback...]

Change Log (V2.1)

We have modified the following...

CPQSetup Group Table no longer requires DocWebAddress

Deleted DocWebAddress row from the Group Table

This Web Address was required for documents to be viewed on the web. However since DriveWorks 16 Service Pack 1, we have introduced a function called FsGetURL. This lets you show documents without setting up a secondary IIS site.

OrderQuoteDocuments Project

Added a Constant called DocumentsList

This Constant is used to store a table of Documents. A Constant has been used because it can be refreshed multiple times within the Project. It will update more frequently than the Variable DocumentsList used to do. It will also update via a Specification Timer automatically.

Added a Specification Macro called GetDocumentsList

This Specification Macro drives the DocumentsList Constant with a list of Documents for the selected Specification.

Added a Specification Macro called DocumentsTimer

This Specification Macro starts when the OrderQuoteDocuments Project starts. This runs a timer that will refresh the documents list every 5 seconds. The timer runs the Specification Macro called GetDocumentsList.

Modified DWVariableRootFolderPath

Formatted DWConstantItemID to four digits i.e. 0001. Text(DWConstantItemID, "0000"). It was not looking at the right folder for documents. The Order View Project was adding files into a folder called "Order 0001" but this rule was looking for files in "Order 1".

Modified the Calculation Table FilesTable, changed the Column Rule for the OpenDoc column

Changed rule from

DWVariableCPQDocWebAddress & "/Orders/Order " & DWConstantItemID & Substitute( DWConstantFolderPath , "\" , "/" ) & "/" & [3L]

to

FsGetUrl( DWVariableCPQDocFileLocation & "\Orders\Order " & Text( DWConstantItemID , "0000" ) & DWConstantFolderPath & "\" & [3L] )

Modified DWVariableDocumentsList

This variable has changed to the following rule:

IfError( ListAllDistinct( DWConstantDocumentsList , 2 ) , "")

The Constant returns a table of files. This rule filters the table for unique items to display on the Form.

Deleted CurrentAddress Macro Button on the Details Form

This Macro Button has been deleted because it is no longer required. A Specification Timer is now carrying out the work of this manual button.

Deleted CPQDocWebAddress Variable

This Variable is no longer required as part of this Project. FsGetURL replaces the need for a website to display documents. Everything can now be done with one IIS Website.

Admin-Setup Project

Deleted FilesWebsiteLabel control from the Web Addresses Form

This Control is no longer required because DocWebAddress has been removed from the CPQSetup Group Table.

Deleted FilesWebsiteURL control from the Web Addresses Form

This Control is no longer required because DocWebAddress has been removed from the CPQSetup Group Table.

Deleted Drive Control Value task called "Set Files Web Address" from the Specification Macro called SetOtherFormControls

Since DocWebAddress is no longer required and the Controls have been deleted, this task is no longer required.

ForgotPassword Project

Deleted DocWebAddress Variable

This Variable is no longer required since DocWebAddress has been removed from the CPQSetup Group Table.

OrderView Project

Deleted DocWebAddress Variable

This Variable is no longer required since DocWebAddress has been removed from the CPQSetup Group Table.

Added a new Variable called TableOfChildSpecifications

This Variable will keep a sorted list of Child Specifications. This Variable is used to get the Specification Name of each Child Project and the Product Name.

TableSelectColumns( TableSort( SppUpdateTableHeaders( TableWithSequence( DwLookupOrderItems ) , "ID" , TRUE ) , 8 ) , 1 , 2 , 9 )

Added a new Variable called SelectedItemSpecificationName

The rule for this Variable is as follows

IfError( VLookup( DWVariableSelectedItem , DWVariableTableOfChildSpecifications , 2 , FALSE ) , "" )

Modified the Variable called SelectedProductId

Changed the Rule from

DWVLookup( TableGetValue( DWSubResultsItems , 3 , DWVariableSelectedItem ) , DWGroupTableProductData , 3 , 1 , FALSE )

to

DWVLookup( VLookup( DWVariableSelectedItem , DWVariableTableOfChildSpecifications , 3 , FALSE ) , DWGroupTableProductData, 3 , 1 , FALSE )

Modified the macro task called "Set Specification Host Control" on the Specification Macro called EditLineItem

Entered the following Rule for the Specification Name property on the Set Specification Host Control task.

DWVariableSelectedItemSpecificationName

Modified the macro task called "Copy Closed Child Specification" on the Specification Macro called CopyLineItem

Entered the following Rule for the Child Specification Name property on the Copy Closed Child Specification task.

DWVariableSelectedItemSpecificationName

Modified the macro task called "Invoke Child Specification Operation" on the Specification Macro called DeleteLineItem

Entered the following Rule for the Child Specification Name property on the Invoke Child Specification Operation task.

DWVariableSelectedItemSpecificationName

Added a Constant called ReportingConstant

This reporting Constant is used for the 2 Specification Macros called "SetTeamOnOperationOrTransition" and "SetTeamOnState".

Deleted Drive Control Value task from the Specification Macro called ShowHideSuggestedProducts

Deleted "ProductQty1, 2, 3, 4, 5 Reset" tasks as they are no longer needed. The controls are no longer on the SuggestedProducts Form.

Added Check Value Conditions to the Specification Macro called AddTeamToSpecFlow

Added a Check Value condition to each Run Macro in a Loop task inside the AddTeamToSpecFlow Specification Macro. These Check Value Conditions check the count of either Transitions and Operations or States. If the number is greater than 0 then the tasks will run. If not then these tasks won't run. If the tasks run with a value of 0 an error will be added to the Specification Report. This prevents that happening.

Modified the Variable called "SearchTableData" to include search wildcards

SearchTableData was not searching tables correctly. This is because it was missing the wildcards that search for a value containing the search term.

The following rule has been modified:

TableSearch( DWVariableCurrentTableData , SearchReturn , TRUE )

to

TableSearch( DWVariableCurrentTableData , "*" & SearchReturn & "*" , TRUE )

ListView Project

Removed the macro task called "Refresh source Data" on the Specification Macro called NewSpec

This task is not needed. All started Specifications should refresh their own data. Too many refreshes were being carried out.

Removed the macro task called "Refresh source Data" on the Specification Macro called EditSpec

This task is not needed. All started Specifications should refresh their own data. Too many refreshes were being carried out.

Modified the Variable called "SearchTableData" to include search wildcards

SearchTableData was not searching tables correctly. This is because it was missing the wildcards that search for a value containing the search term.

The following rule has been modified:

TableSearch( DWVariableCurrentTableData , SearchReturn , TRUE )

to

TableSearch( DWVariableCurrentTableData , "*" & SearchReturn & "*" , TRUE )

Dashboard Project

Removed the macro task called "Refresh source Data" on the Specification Macro called NewSpec

This task is not needed. All started Specifications should refresh their own data. Too many refreshes were being carried out.

Admin-Dashboard Project

Removed the macro task called "Refresh source Data" on the Specification Macro called NewSpec

This task is not needed. All started Specifications should refresh their own data. Too many refreshes were being carried out.

Admin-Reporting Project

Removed the macro task called "Refresh source Data" on the Specification Macro called NewSpec

This task is not needed. All started Specifications should refresh their own data. Too many refreshes were being carried out.

CPQ-Staircase Project

DWVariableSpecPath

Updated this variable to format DWConstantParentSpecId to four figures i.e. 0001.

CPQ-Cupboard Project

Specification Path

Updated the Specification Path Rule to format DWConstantParentSpecId to four figures i.e. 0001.

Table of Contents