Cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Variables in query's

Pioneer
Pioneer

I am trying to find a way to run a query but ensure that the query values are compared against some attributes.

So for example if I search for a Dataset under an item revisiosn. I want to ensure that the name is <ITEMID>/<REV>

I'll never know what ITEM_ID or REV is until the query is run but I want to validate against them any ideas?

 

Tom

7 REPLIES 7

Re: Variables in query's

@Tom189 are your planning to run this query as part of a workflow?

Re: Variables in query's

Solution Partner Esteemed Contributor Solution Partner Esteemed Contributor
Solution Partner Esteemed Contributor
Careful @Tom189, some CAD integrations don't work with Datasets that include the revision in the name, only the Item Id. Be sure you're supported before changing them.

Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4

Re: Variables in query's

Pioneer
Pioneer
Yes exactly.

Re: Variables in query's

Pioneer
Pioneer
The Datasets in question are PDF's only.

Re: Variables in query's

@Tom189 , it doesn't seem likely that you will be able to do this with a simple Condition Task/Query.  Have you considered using the EPM-invoke-system-action and a simple perl script to compare the Item ID/Rev to the Dataset Name and then return true or false?  (I realize this is slight customization...)

Re: Variables in query's

Pioneer
Pioneer
Where would be the best place to start with this sort of approach?

Tom

Re: Variables in query's

You can read about the handler

https://docs.plm.automation.siemens.com/tdoc/tc/12.1/help/#uid:invoke-system-action

Mock up a simple workflow that includes the handler.

Take a look at the XML output.

Write a perl script to read the file and compare the Dataset Name to the Item ID/Rev.

Then test.