15 Replies Latest reply: Apr 13, 2012 7:27 AM by MichaelSchilling RSS

    Windchill search

    Copper
      Does anyone know how to send a search query from a HTML-form and retrieve the search result from windchill server. I want to create a simple search instead of using PDMLink UI.
        • RE: Windchill search
          PatrickHarriss Copper
          Look in the customizers guide for information about using the QuerySpec and QueryResults objects. If you provide more information on the search criteria you are looking for I could help further.
            • RE: Windchill search
              ptc-2049169 Copper
              You can use webjects to query information from Windchill. You can launch query by URL at get result as XML. Apply for information to WCAdaptersGuide.pdf
                • Query data from Windchill
                  Copper
                  Use the Report Manager to create the search and results page. Then save the search page offline and modify the resulting HTML.
                    • Re: Query data from Windchill
                      Copper
                      That is a possibility, but that is too much manual labour. I want a search box quering the PDM-link. not manually retrieve the data and handle it.. There will be alot of searching...

                      "David Mertz" wrote:

                       

                      Use the Report Manager to create the search and results page. Then save the search page offline and modify the resulting HTML.

                        • still a problem
                          Copper
                          The thing is that I have no clue to how to communicate with Windchill. What would be nice is if someone had a tutorial or step by step on how to set up a simple query from windchill to retrieve, lets say, all drawings starting with P/N 40894*. The result should be a table with the drawings listed. I know how to sort the retrieved data in PHP but I dont know how to set up the infoEngine or write the JSP. I also want the P/N to be clickable so taht I can have it in PDF (Which have been published, but the consultant never made it accessable to us).
                            • Search,
                              Copper
                              I found a search function in Ch. 11 of either Customization or adapters guide. But I get Errormessage when I try to run the Demo. Does anyone know why? Message:DCA ERROR: Can not find configuration with id=com.ptc.search:page.search.part for context=(locale=en_US rendererType=java ) I use: http://<host>/Windchill/wtcore/jsp/com/ptc/core/ca/web/gw/gw.jsp?alias=com.ptc.search:page.search.part
                                • RE: Search,
                                  TimGilbert Copper
                                  Magnus, Did you ever find your answer. I would like to do something similar and would appreciate any help you could give me. Thanks, Tim
                                    • regarding search..
                                      Copper
                                      Hi, No I havent. Not yet. Though I have come closer in my quest. If you look at http://www.datajett.com/ (found it just, and havent had time to evaluate. But it may be some nice things to look at. The direct link is: http://www.datajett.com/windchill/WC_Dev.htm Also look under : http://www.datajett.com/windchill/ There might be documents that can help us. If you are serious in trying to do this without expensive consultants, I am more than happy to provide what ever information I come accross. my email is: magnus.gabell@nikehydraulics.se

                                      "Tim Gilbert" wrote:

                                       

                                      Magnus, Did you ever find your answer. I would like to do something similar and would appreciate any help you could give me. Thanks, Tim

                        • Re: Windchill search
                          FeofilovIvan Bronze

                          You can use custom search application by Windchill, http://plmservice.ru/2011/03/windchill-live-search/

                          source code available.

                          • Re: Windchill search
                            larsene Copper

                            Thankyou for that Ivan, but, although your application is interesting, it is not what I am looking for.

                            I have an excel file used by other offices, in wich are some list of part numbers.

                            I would like to add a column in this file (updated by a vb macro) in wich one will be a hypertext link to open the drawing in internet explorer.

                             

                            something like:

                             

                            For i=0 to 1000
                            cells(i,1).value = "http://myserver/myspecificURLorSpecificWebPage?'" & cells(i,2) & "*.drw'"

                            next i

                             

                            My problem is that I am not able to write the specific Url with an article number as argument, or a custom web page, wich will send me back a search report.

                            • Re: Windchill search
                              larsene Copper

                              Isn-it possible to write a custop webpage in java, wich would accept argument, and wich will do the request to intralink database using apropriate java code?

                                • Re: Windchill search
                                  MichaelSchilling Copper

                                  Hi, i've just found your thread regarding the possibility to search/query in Windchill.

                                  We've defined a really simple to use API with which you can send a URL request to Windchill and it 'answers' back with the appropriate results.

                                   

                                  We've built some applications on top of this - you can check two of them here:

                                  http://www.youtube.com/watch?v=MIAZ-kj8s4w

                                  and

                                  http://www.youtube.com/watch?v=I7CS8Ytc17E

                                   

                                  The underlying technology is also here the mentioned API. It works really fast and is extremely lightweight. I think you could absolutely use this also from Excel to talk to Windchill. You don't have to do any Java Programming and the impact on the Windchill server is minimal.

                                   

                                  Let me know if that sounds interesting!

                                  Just drop us a note at www.nexiles.com