1 Reply Latest reply on Mar 31, 2014 10:19 AM by Brian McEwen

    Version Free Variable Questions

    Paul Wyndham

      I am working on creating some custom EPDM reports. The point is to have workflow states set a date during certain transitions. This would allow a report to look through the vault and pull the info on any file that has been in one of these states for more that 7 days - for example.

       

      For this I created some variables and set the workflow transitions to update the corresponding variable with triggered. When the next state is triggered it removes the value from the previous data variable. Then, the report would no longer find it in error. The problem with both regular and version free variables is that when the state transition happens version 5 has date 2014-03-26 and the new version 6 has the date 1900-01-01 in it. The 1900 date is not a problem as I can write the SQL query to ignore it.The problem is that version 5 is still picked up and reported on.

       

      Why does the version free variable get left behind in the data base? I would think it would update the version number so that it only maintained one line for that variable. Well, I guess 2 or more lines since it insists on having a line for each configuration, even if you don't use configurations and every part always has 2 configurations.

       

      Why do I have to put variables on the data card in order to actually modify them with the state transition? I don't want them on the data card, I just want it a background thing.

       

      Why doesn't the card editor box for "Show in Explorer" turn off the text box when unchecked? Why can't you resize the card to something smaller that the area that has the boxes you don't want to show?

       

      If you have the Updates all configurations option selected, why does it still make 2 lines in the data base?

       

      Here is a screenshot of the database listing after the first state.

      ReviewState.JPG

      Then again after transitioning to the next state.

       

      ApprovalState.JPG

       

      If I go onto the data card and modify the variable it functions correctly and just updates the date and does not require checkout.

      But, it does go through and create 2 line items for each version of the file.

      AllVersionsAdded.JPG

       

      How is this helpful?

       

      In this view from the query I am getting 2 file to show up twice because they have the old date for Review state in version 5 and the new date in version 6 for the approver state.

       

      Query.JPG

       

      We are currently using EPDM 2013 SP3.0 with SolidWorks 2013 SP3.0.

      Any ideas would be greatly appreciated.

        • Re: Version Free Variable Questions
          Brian McEwen

          I don't know anything about reports yet, but I have encountered some of these issues in other ways.

           

          Version Free (VF) variables - I've only used EPDM 2014 and you have the option to make a Version Free variable Update "All Versions" or  Update "Latest Version".  If you have the same option in 2013 it seems like that would cover it? But I don't fully follow how you are handling the variables, step by step would make it more clear.

           

          An aside - I had trouble with getting a workflow transition action to update a VF varaible. I don't know why, in other cases it worked, but I ended up writing a Dispatch action to update the variable. That makes me suspisious that VF variables are not bug free. 

           

          """""""If you have the Updates all configurations option selected, why does it still make 2 lines in the data base?""""""""  Well, as you said there are at least 2 configs for each solidworks file. If the value applies to the whole file then probably one place is enough.  I think it will just go to the @ config if you uncheck this - give it a try. 

           

          By the way - I think in 2013 they added the Delayed In State notification (just in case you don't know about it), but it probably has different functionality that what you are looking for.

           

          """"""""""Why do I have to put variables on the data card in order to actually modify them with the state transition? I don't want them on the data card, I just want it a background thing."""""""""

          You can hide them using Control Logic - just make the condition something that will always be true (Text Contains... and just leave a blank).  I made my hidden variables small and squeezed them into little spaces (on the card editor view). Could also set up a tab to contain these.

           

          Show In Explorer - unintuitive, but this check box is just for showing varaibles in the Preview tab of the Explorer.