DriveWorks Pro 15: SppGetSpecificationsByDate [send feedback...]

SppGetSpecificationsByDate

Returns a table with all specifications and details.

Syntax

SppGetSpecificationsByDate([Descending],[Include Archived],[Include Specification Properties])

Where:

Descending is TRUE to order descending, FALSE to order ascending.

Include Archived is TRUE to include archived specifications, FALSE to exclude.

Include Specification Properties is TRUE to include the specification properties, FALSE to exclude them.

Examples

RuleMeaning
SppGetSpecificationsByDate(TRUE,FALSE)Will return an array of all specifications and their details, excluding archived specifications.
SppGetSpecificationsByDate(FALSE,FALSE,TRUE)Will return an array of all specifications and their details, including archived specifications and specifications properties in an ascending order.

Example Data Returned as a Table

IDNameCurrent StateDate CreatedDate ModifiedProject NamePathCreated ByLast Edited By
6Project 0006Pending02/12/201502/12/2015LintelsD:\DriveWorks\Lintels\Specifications\Project 0006\DriveWorksFiles\Project 0006.drivespecIanPaul
5Project 0005Saved22/11/201502/12/2015CanopyD:\DriveWorks\Canopy\Specifications\Project 0005\DriveWorksFiles\Project 0005.drivespecGlenPaul
4Project 0004Completed06/11/201502/12/2015CanopyD:\DriveWorks\Canopy\Specifications\Project 0004\DriveWorksFiles\Project 0004.drivespecGlenIan
3Project 0003Pending02/11/201502/12/2015LintelsD:\DriveWorks\Lintels\Specifications\Project 0003\DriveWorksFiles\Project 0003.drivespecPaulGlen
2Project 0002Pending28/10/201527/11/2015LintelsD:\DriveWorks\Lintels\Specifications\Project 0002\DriveWorksFiles\Project 0002.drivespecIanGlen

Example Data Returned as an Array

{"ID","Name","Current State","Date Created","Date Modified","Project Name","Path","Created By","Last Edited By","";"6","Project 0006","Pending","02/12/2015","02/12/2015","Lintels","D:\DriveWorks\Lintels\Specifications\Project 0006\DriveWorksFiles\Lintels 0006.drivespec","Ian","Paul","";"5","Project 0005","Saved","22/11/2015","02/12/2015","Project","D:\DriveWorks\New folder\Specifications\Project 0005\DriveWorksFiles\Project 0005.drivespec","Glen","Paul","";"4","Project 0004","Completed","06/11/2015","02/12/2015","Project","D:\DriveWorks\New folder\Specifications\Project 0004\DriveWorksFiles\Project 0004.drivespec","Glen","Ian","";"3","Project 0003","Pending","02/11/2015","02/12/2015","Lintels","D:\DriveWorks\Lintels\Specifications\Project 0003\DriveWorksFiles\Lintels 0003.drivespec","Paul","Glen","";"2","Project 0002","Pending","28/10/2015","27/11/2015","Lintels","D:\DriveWorks\Lintels\Specifications\Project 0002\DriveWorksFiles\Lintels 0002.drivespec","Ian","Glen",""}

Table of Contents