Home Search

DriveWorks Pro 21
SppGetSpecificationsByDate

Send Feedback

SppGetSpecificationsByDate

This is now an inbuilt function, please see GetGroupSpecifications for more information.

Returns an Array containing Specification details for all Specifications in the Group.

Syntax

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

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.

State Name is the name of the State in which a Specification must be in to be returned (This is an optional property).

Example

RuleResultMeaning
SppGetSpecificationsByDate (TRUE,FALSE,TRUE){"ID","Name","Current State","Date Created","Date Modified","Project Name","Path","Created By","Last Edited By","Date Created Integer","Date Modified Integer";"4","Bracket 0004","Completed","04/02/2018","05/03/2018","Bracket","C:MyDocuments\Fittings\Specifications\Bracket 0004\DriveWorksFiles\Bracket 0004.drivespec","Matt","Ian","43135.50795138","43223.59420138";"3","Bracket 0003","Completed","12/12/2017","06/06/2018","Bracket","C:MyDocuments\Fittings\Specifications\Bracket 0003\DriveWorksFiles\Bracket 0003.drivespec","Paul","Ian","43081.59420138","43257.4245771181";"1","Bracket 0001","Pending","12/10/2017","01/05/2018","Bracket","C:MyDocuments\Fittings\Specifications\Bracket 0001\DriveWorksFiles\Bracket 0001.drivespec","Ian","Matt","43079.69568287","43105.38581018"}Will return an Array of all Specifications and their details, excluding archived Specifications.

Returned Array In Table Format

IDNameCurrent StateDate CreatedDate ModifiedProject NamePathCreated ByLast Edited ByDate created IntegerDate Modified Integer
4Bracket 004Completed04/02/201805/03/2018BracketC:MyDocuments\Fittings\Specifications\Bracket 0004\DriveWorksFiles\Bracket 0004.drivespecMattIan43125.5079513843223.59420138
3Bracket 0003Completed12/12/201706/06/2018BracketC:MyDocuments\Fittings\Specifications\Bracket 0003\DriveWorksFiles\Bracket 0003.drivespecPaulIan43081.5942013843257.4245771181
1Bracket 0001Pending12/10/201701/05/2018BracketC:MyDocuments\Fittings\Specifications\Bracket 0001\DriveWorksFiles\Bracket 0001.drivespecIanMatt43079.6956828743105.38581018

Example Using State Overload

RuleResultMeaning
SppGetSpecificationsByDate (TRUE,FALSE,TRUE,"Pending"){"ID","Name","Current State","Date Created","Date Modified","Project Name","Path","Created By","Last Edited By","Date Created Integer","Date Modified Integer";"1","Bracket 0001","Pending","12/10/2017","01/05/2018","Bracket","C:MyDocuments\Fittings\Specifications\Bracket 0001\DriveWorksFiles\Bracket 0001.drivespec","Ian","Matt","43079.69568287","43105.38581018"}Will return an Array of all Specifications and their details, excluding archived Specifications.

Returned Array In Table Format

IDNameCurrent StateDate CreatedDate ModifiedProject NamePathCreated ByLast Edited ByDate created IntegerDate Modified Integer
1Bracket 0001Pending12/10/201701/05/2018BracketC:MyDocuments\Fittings\Specifications\Bracket 0001\DriveWorksFiles\Bracket 0001.drivespecIanMatt43079.6956828743105.38581018