Looking for code that I can add to a workflow that will search for CNs that are not at resolved state in the system with the same attribute value as a WTdoc.
We currently have an attribute (Sales Order Number) that is filled in when creating a change notice. Let's say they have entered 34225 as the SO number. I also have a WTdoc that has the same SO number and once the WTdoc is created there is a workflow that is automatically kicked off. I need code that will take 34225 from the WTdoc and search all open CNs for ones that have that same number....I would probably use a conditional node to get an email sent out when it does find an open CN, else it would just continue with the workflow.
Anyone have code they can share? I have reached out to PTC, but they have yet to supply anything relevant and they are starting to push back saying they don't supply complete code....surprising that that is the answer to customers when it comes to something small and simple like this.
Anyway, any help would be greatly appreciated.
Thanks,
Greg
