I want to add a column in my COMPLETE SEARCH to show the "DAYS IN STATE" for files.
Any help is appreciated.
If you are looking to add an empty column that you can add data to later in Excel, make a dummy variable and add it to the BOM column set. If you want a calculated value, you won't be able to do this with the search tool, you'll need to make a report.
This is a good idea. I'm following this for the feedback to see if there is a way.
Perhaps there is a way to be able to add a column to be able to list date of last state change.
You can easily set the date using an action to set a "date" variable during a transition. Then add a column for the date variable in your search columns. I set up a job list using this approach along with the due date at my last job.
I don't know if you can set up a variable to equal current date minus the state change date. If there is, it would be cool to know.
David - I would set up a custom search card with a custom column list to do what you want.
EPDM Days in State Notification Task Addin - YouTube
EPDM Days in State Task Addin | WLM Services LLC
User reports - Enterprise PDM
Graphics Systems' SolidNotes: Reporting on Time in a Workflow State
Although this is very useful, it doesn't really answer how to add a column in pdm explorer.
To add/delete/rearrange colums with results in PDM explorer, you have to use Administration tool - > Columns. There you can create custom explorer view colums, but also don't forget to assign them to users, otherwise they will not work.
P.S.: I'm sorry I use image from web for the administration tool, but currently I'm vacation and don't have access to SW.
Thanks Shaodin. I had already looked at the task add-in by WLM Services and it is good. To work for me though, it would be nice for it to have a MENU COMMAND page like the PDF task does. Then I could make it available for all users to run at their discretion.
Dave, it's not possible directly in the search window without T-SQL and some API or reporting. You can get close by cobbling something together but that is why we created the ATLAS PDM Reporting API.
Here's someone trying to do something very similar but not "exactly" what you are doing.
Counter in Dispatch?
Thanks for the feedback. I am disappointed that this is the answer, but not surprised. Guess I will need to come up with another, more complicated way to solve my problem.
Web2 has it by default just to make you more unhappy
I hadn't noticed. Interesting that the web version has it and the Windows Explorer version does not...
I am not sure how to do it with SolidWorks PDM Search, but I have done it with Complete Search in Windows explorer:
Still no "Days in State" column, or am I missing something?
I don't have PDM Professional so I can't do this for myself. But if I could I would create a PDM variable called "Days in State" and make sure its on all the file cards I want it to associate with.
I would then create a macro that gets the current state date and subtracts that from that days date. The only problem is that this macro would need to run daily to update the variable on all files.
In each File card can make field with a formula it seems: $Sub ($Time (), %Data%).
The Data field can be filled through Workflow, Dispatch, Api, etc.
Depending on this Data, probably it is possible to receive value of type - "Days in State" or "Days without changes" or something else.
There where there will be no this Date - there will be no Value.
If it is necessary - probably it is possible to make Dispatch script for filling in all necessary files and for use by Search..
Perhaps, it is of a certain interest and has the right for existence and use.
Hey Dave! Long time no chat... as everyone has mentioned, there are some many ways to get what you want. Also, it is available in web2 interface. There is a counter somewhere that has this info already calculated, which is what the web2 UI and delayed in state notification function is based on.
However which way you choose to you get what you want, don’t forget to vote on SPR 822266 - which is the ER for exactly what you want. This lets development know more ppl want it and bumps the priority of the ER. cheers!
Retrieving data ...