AnsweredAssumed Answered

Sheet Variable SQL

Question asked by Tom Strohscher on Apr 29, 2019

I've been working on a workflow to determine and set the drawing revision.

I've been getting inconsistent results I've had difficulties tracking.

I've narrowed down a problem I'm seeing with the revision variable value on the sheet tab of a drawing data card.

 

I would like to run a report query that can show me the file name, revision number, revision variable value on the @ tab of the data card, and revision variable value on the Sheet of the data card.

 

The value on the sheet tab is causing my workflow to fail.

 

We are using an A-Z, AA-ZZ revision scheme.

Outcomes