Reader small image

You're reading from  Microsoft Visio 2013 Business Process Diagramming and Validation - Second Edition

Product typeBook
Published inNov 2013
Reading LevelIntermediate
PublisherPackt
ISBN-139781782178002
Edition2nd Edition
Languages
Right arrow
Author (1)
David Parker
David Parker
author image
David Parker

David J Parker's background has been in data visualization ever since he struggled to produce lists of hospital equipment from Computer Aided Design models of buildings as a budding architect in the '80s. He moved into building and infrastructure asset management in the late '80s using a Unix system and gradually migrated to Windows-based systems throughout the '90s. He became a European Business partner of Visio Corporation in 1996 and presented the database-linked Visio solutions that he was providing merchant banks in London and New York with at several international conferences. David started bVisual Ltd. in 1998, which provides Visio-based solutions to various industries, and became a Silver-level Microsoft partner. He has been a Microsoft MVP (Visio) for the last 12 years and has helped Microsoft Corp, UK and Western Europe, by providing Visio solutions, training, website content, and presentations. David has had several books on Visio published and has been presenting Visio/SharePoint integration courses for many years for Microsoft Western Europe, from Oslo in the North down to Lisbon in the South. He has presented at SQL and SharePoint Saturday conferences and writes a regular blog for people interested in Microsoft Visio.
Read more about David Parker

Right arrow

The syntax for the FilterExpression and TestExpression formulae are the same as for the ShapeSheet formulae. However, Visio 2013 includes some extra validation functions such as the ShapeSheet functions, but these functions cannot be used in the ShapeSheet formulae, with the exception of those marked with an asterisk.

The following table is an extract from The Diagram Validation API blog:

http://blogs.msdn.com/visio/archive/2010/01/07/the-diagram-validation-api.aspx

It lists the special quasi-ShapeSheet functions that can be used in the FilterExpression and TestExpression formulae, and has been extended to include the new functions added in Visio 2013 (marked with *).

Function

Description

HasCategory(categoryName)*

Returns a Boolean indicating whether the shape has the specified category.

Is1D()*

Returns a Boolean indicating whether the shape is 1D or not.

Role()

Returns an integer indicating the shape role: {Element = 0, Connector = 1, Container = 2, Callout...

lock icon
The rest of the chapter is locked
You have been reading a chapter from
Microsoft Visio 2013 Business Process Diagramming and Validation - Second Edition
Published in: Nov 2013Publisher: PacktISBN-13: 9781782178002
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
undefined
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime

Author (1)

author image
David Parker

David J Parker's background has been in data visualization ever since he struggled to produce lists of hospital equipment from Computer Aided Design models of buildings as a budding architect in the '80s. He moved into building and infrastructure asset management in the late '80s using a Unix system and gradually migrated to Windows-based systems throughout the '90s. He became a European Business partner of Visio Corporation in 1996 and presented the database-linked Visio solutions that he was providing merchant banks in London and New York with at several international conferences. David started bVisual Ltd. in 1998, which provides Visio-based solutions to various industries, and became a Silver-level Microsoft partner. He has been a Microsoft MVP (Visio) for the last 12 years and has helped Microsoft Corp, UK and Western Europe, by providing Visio solutions, training, website content, and presentations. David has had several books on Visio published and has been presenting Visio/SharePoint integration courses for many years for Microsoft Western Europe, from Oslo in the North down to Lisbon in the South. He has presented at SQL and SharePoint Saturday conferences and writes a regular blog for people interested in Microsoft Visio.
Read more about David Parker

Function

Description

AND(logical expression1,logical expression2,...,logical expressionN)

Returns TRUE (1) if all of the logical expressions supplied are true. If any of the logical expressions are false or 0, the AND function returns FALSE (0).

OR(logicalexpression1,logicalexpression2,...,logicalexpressionN)

Returns TRUE (1) if any of the logical expressions are true.

NOT(logicalexpression)

Returns TRUE (1) if logicalexpression is false. Otherwise, it returns FALSE (0).

IF(logicalexpression,valueiftrue,valueiffalse)

Returns valueiftrue if logicalexpression is true. Otherwise, it returns valueiffalse.

INDEX(index,"list"[,[delimiter][,[errorvalue]]])

Returns the substring at the zero-based location index in the list delimited-by-delimiter. Or, it returns -1 if not found.

LOOKUP("key","list...