Want to add a SEARCH COLUMN for ....?
I want to add a column in my COMPLETE SEARCH to show the "DAYS IN STATE" for files.
Any help is appreciated.
-
Re: Want to add a SEARCH COLUMN for ....?
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.
-
Re: Want to add a SEARCH COLUMN for ....?
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.
-
Re: Want to add a SEARCH COLUMN for ....?
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.
-
-
-
Re: Want to add a SEARCH COLUMN for ....?
Although this is very useful, it doesn't really answer how to add a column in pdm explorer.
-
Re: Want to add a SEARCH COLUMN for ....?
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.
-
-
Re: Want to add a SEARCH COLUMN for ....?
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.
-
-
Re: Want to add a SEARCH COLUMN for ....?
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.
-
Re: Want to add a SEARCH COLUMN for ....?
Tim,
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.
-
-
Jan 6, 2017 9:57 AM
