Windchill Customization

Hi, I wrote a SELECT statement that basically queries all Change Activities for all Change Orders (please ignore the * selector for now):SELECT*FROM WTCHANGEORDER2 INNER JOIN INCLUDEDIN2 ON WTCHANGEORDER2.branchiditerationinfo = INCLUDEDIN2.BRANCHIDA3A5 INNER JOIN WTCHANGEACTIVITY2 ON INCLUDEDIN2.BRANCHIDA3B5 = WTChangeActivity2.branchiditerationinfo Now I would like to convert this to a Windchill QuerySpec.What I am trying to do is to get attributes for both the Change Activity and the Change Order. For now I used the * selector but I would like to select attributes from WTChangeActivity2 and WtChangeOrder2. As of my intuition, you need to specify an "output" class for your query spec, so what class or type those objects from the Query spec belong to but in my case this would be mixed because I need attributes from both types. Is there a way how I can do this or do I need to split my query up (i.e. first query all Change Orders and then query all Change Activities

I think one of the first exercises when customizing Windchill is making use of Queryspec API to search for objects in the database. Given a number string, find me the Parts that match and do something with them. If we are taking input from the browser, what consideration must we do so that we do not open ourselves up to SQL Injection?  Does the API already handle this for us internally?    Given that I am providing the where clause a string value directly from the user's input, how do we make sure it does not contain another SQL statement? Is that where its done, checking before adding to where clause? I know that we can put checks on any exceptions that are thrown from bad input that can expose data. Just curious where developer's responsibilities lie and what PTC has already handled.

What is the use of AvailableAttributes.xml file?

When trying to compile the Windchill Customizations (developed originally using JDK 8/Windchill 11) using JDK 11 (Windchill 12) we are getting compilation issues due to several packages being accessible from multiple modules.   For ex: org.w3c.dom package is now included in jdk11 jar by default (Module Path), but is also present in ie3rdpartylibs, xmlParserAPIs and dom4j jars (Class path).   We understand that JDK 11 is enforcing a modularity check to ensure the same package is not referenced in multiple jars. However it is also understood that module-info.java is not necessary to be configured for JDK 8 to 11 migration. As long as the relevant jars are added to the classpath, the code should be able to compile using JDK 11 as well.   How does PTC handle these issues when working with JDK 11 and Eclipse (version 4.16)?    

Hello, Does anybody has suggestion on how to launch PSI in Linux Environment? I try to launch it using the setup file in the installer but it fails. I have previously launched it in Windows using the same setup file and it launches the GUI without any problem. Any suggestions on the same would be helpful, Thanks,Ramsha  

Hi Community, I created a new flow by clicking new template from the templates page. But the flow gets stuck at the first step and gives an error that it should not give, what could be the reason for this?  Even though I defined all the parameters correctly, nothing changed.Code:wt.doc.WTDocument doc = (wt.doc.WTDocument) primaryBusinessObject; docNumber=doc.getNumber(); docName=doc.getName(); Error:wt.workflow.engine.FailedExpressionException: wt.util.WTException: java.lang.NullPointerException Nested exception is: java.lang.NullPointerException Nested exception is: wt.util.WTException: java.lang.NullPointerException Nested exception is: java.lang.NullPointerException 

Hi All I have a customization that displays the structure of a selected part with the columns being thier attributes in a JSP. All the columns are editable with textboxes in each row. I have a find and replace function in that page that allows me to replace text in mass. But I'm unable to do it as beyond a particular row count, when I try to find a text using document.getElementById it returns null. I tried the solution https://www.ptc.com/en/support/article/CS132804 which disables redrawing rows but still no luck. I'm able to do it only when I scroll through the entire table and load all the rows manually. Is there any workaround or is there any script that would load all rows of a table.

 Hi community! I can send a task to more than one person, as in the image below.But I need to make a distribution within the group to determine who will perform these tasks.For this reason, how can I assign a task to more than one person with the 'accept task' button?   

Initially posted in this topic   Hi @HelesicPetr , I want to print different statements in different logger. Can you please help me here?For example, I want different loggers purpose wise. Please refer to the below section. private static final Logger LOGGER = LogManager.getLogger(LoggerExample.class ); private static final Logger LOGGER_PRE = LogManager.getLogger("LoggerExample_Pre"); private static final Logger LOGGER_SUMMARY = LogManager.getLogger("LoggerExample_Summary"); private static final Logger LOGGER_POST = LogManager.getLogger("LoggerExample_Post"); private static final Logger LOGGER_ERROR = LogManager.getLogger("LoggerExample_Error");  

Hi community!I want to get the values of some attributes from the users from the task.When I define an attribute to the activity, I do this by selecting the required option, but when I do this, it wants to get that value as mandatory.How can I make attributes mandatory in task?

In Windchill Rest Services Product Management>getPartStructureI used $expand = Components($expand=Part,PartUse;$levels=max)  API , It executed for 4 mins. To reduce execution time, i want to provide 3 field names in $select query. Kindly refer the attached JSON document to form the query to fetch the field 'PartNumber, ComXXXEngineeringSequences, ItemTypeComXXXIndustriesItemType'. I able to fetch two fields using query $expand = Components($expand=PartUse($select=ComXXXEngineeringSequences)) But when I tried to fetch ItemTypeComXXXIndustriesItemType using query $expand=  Components($expand=Part($select=ItemTypeComPolarisindPolarisIndustriesItemType);$levels=max)It throwed error  [ - The property 'ItemTypeComXXXItemType', used in a query expression, is not defined in type 'Part'.] Kindly check the attached file and let me know how to fetch 'PartNumber, ComXXXEngineeringSequences, ItemTypeComXXXIndustriesItemType' together.

Initially posted as a new reply, here:   Hi,  Could you help me to solve ESI 902 error cause task get stuck for ECN in WF    

Hi Community,I have loaded windchill demo data using loader command and now I need to understand whether we have mBOM in Windchill server or not. How we can differentiate between different BOM structures available in the Windchill Server from the UI?  I went through some PTC articles and also youtube video where I found that we can have option of Electrical or Mechanical before starting Part Name, number etc. How I can enable that?Attaching ss for reference.  Thanks,Sid

Does anyone use rich text on the change notice with ESI sending to SAP?  If so how do you handle the html tags that windchill adds to your description?

Hi all, I have a wizard jsp page where I have defined an MVC table and a html button. The intent is once the user clicks the button, system will reload the table using PTC.jca.table.Utils.reload. My table builder contains code which makes an API request to get some validation response which will be displayed on the table. A wizard button on UI will be enabled/disabled based on table row output (safe to assume table will always have one entry). I have noticed that once I reload the table and try to get the updated row(s) I don't get any values since the table is still reloading by the time the program calls "PTC.jca.table.Utils.getTableRows". To mitigate this I set a timeout so it waits for table to finish reload, but I cannot determine on average how long it would take to make the call. Is it possible to have some async/await in this scenario? Or perhaps use a different approach?  I went with the above approach since I want the user to know an operation is happening

Views created in View Administration is not reflecting while creating a new downstream part in BOM Transformer. 

Dear All, I have a Design Part  WTPart1 associated to WTPart2 and WTpart3. Also the WTPart is linked to  CAD ASM and CAD Part via EPMMemberLink.  I am able to get the LineNumber available in WTPartUsage link for Design Parts , how do i retrive the Line Number via API for the ASM and CAD Part  WTPart1  (  CAD ASM )     - -WTPart2  ( CAD Part )     - - WTPart 3 ( CAD Part )  BR,Sriram R    

Hello Community, I have a requirement where I need to generate a PDF file which will contain some of the attributes of Change Notice, I am not sure how exactly I should go about it. Requesting you to share some details to create a pdf in the code. Thanks,Sha

What are the steps to export the info from Change Notice:process status shown below to a pdf  file ?  I need to create a list of roles,user name, vote, completed date, comments.   

How can we get the enditem of wtpart subtype?   

Hello, I am currently migrating the codebase from Windchill 11.1 to 12.0 and facing issues in the new log4j 2.0 package, namely in the following APIs-Layout layout = new PatternLayout("%d [%t] %-5p %c - %m%n");FileAppender appender = new FileAppender(layout, WTProperties.getServerProperties().getProperty("wt.logs.dir")+ File.separator + "SetStateOfAffectedObjects.log");logger.addAppender(appender); Anybody has any suggestions for the same? Thank you,Ramsha   

I am working on customizing the workflow task notication templates and have a few questions.   1.)  Why does the activityNoficationURL method not get put in comments but all of the other methods do?  (It will fail if placed in comments.)  [Red Box]   2.)  Where is the extra condition "notification" for activityAttributes documented.  [Blue Box]     3.)  How do I get just the task URL without all of the extra garbage?  [Orange Boxes]   4.)  Why does the task list the process name instead of the task name?  Is this controlled by a preference?  If not, can the process name itself be changed?  (I'm already dynamically changing the task name.)     Thanks!

Hello All,I want to make Particular group of user should be the always reviewer and approver for the object during promotion request.Is it possible through configuration.Thanks.   @HelesicPetr  

Dear allIt's wonderful to see all your inputs in these forums ! We have a Windchill change process where we need to generate custom partslist (BOM) in a pdf format with a predefined template (header , footer , logo etc). Inspite of all the efforts(customization) from the team it still is not possible. (I know this is not an OOTB function from Windchill) I reach out to all of you to seek your comments /suggestions We are using Windchill 12.0.2 .  Thank you in advance. 

How to write a custom UI validator that runs on a Change Request, when 'New->Create New Change Notice' is clicked, can we use preUIValidation that checks the state of the Change request, and throw an error message/warning in the UI if state is 'Under Review', and it should let users create Change Notice when state is 'Implemented'. What are the files that need to be customized to achieve this?