IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

Regular Expression in Identifying query

  • 1.  Regular Expression in Identifying query

    Posted Thu September 01, 2005 12:24 PM

    Hi,

    i’m creating an XML Document Type in TN . Can I put a regular expression in “Value” while adding an identifying query. A tag named
    BUIS_LEV comes in the XML. Its value can be any string , I want the XML document to be recognized if the string contains A25 anywhere in it . Can we put a reqular expression in “Value”.

    for eg all the below values of BUIS_LEV should be considered valid and XML Document should be recognized by TN

    fafA25slf
    000.A25.A25.021.021.


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 2.  RE: Regular Expression in Identifying query

    Posted Thu September 01, 2005 03:35 PM

    Ratnesh,

    AFAIK, you cannot use regular expressions with XQL which is the language used for identifying queries.Regular expressions can be only used with WQL.

    ramesh.


    #Integration-Server-and-ESB
    #webMethods
    #B2B-Integration


  • 3.  RE: Regular Expression in Identifying query

    Posted Thu September 01, 2005 04:44 PM

    I agree with ramesh,only u can use is specifiying XML node in the XQL format for Identifying query and it searches the node if exits in the XML and recognizes it.

    HTH,
    RMG


    #Integration-Server-and-ESB
    #webMethods
    #B2B-Integration


  • 4.  RE: Regular Expression in Identifying query

    Posted Mon September 19, 2005 09:54 AM

    Looks like it’s doable, but I’m too lazy to try it myself. Look in TN: Building Your Network doc. Specifically, XQL Reference section. I tried it in queryDocument, and that worked as advertised.

    That being said, I find the idea of using RegEx to do identifying query quite hard to comprehend. Could be more trouble than it’s worth…


    #B2B-Integration
    #webMethods
    #Integration-Server-and-ESB


  • 5.  RE: Regular Expression in Identifying query

    Posted Mon September 19, 2005 03:14 PM

    Actually, I think using a regular expression to identify a document using pattern matching makes lots of sense. You can use regular expressions inside XQL using the following syntax:

    //aspectRegistry/aspect[pointcut/name[regex("mdc")]]/aspectData/name/text()

    Matches the aspect names of all aspects whose pointcut/name elements contains a name elements that start with “mdc”.

    You can also combine regex patterns for more complex queries:

    aspectRegistry/aspect[pointcut/name[regex("mdc.demo")]][pointcut/adviceType='before']/aspectData/serviceName]
    

    The second query matches only the serviceNames where the adviceType is “before” and the pointcut/name elements contain the string “mdc.demo”.

    Mark


    #B2B-Integration
    #webMethods
    #Integration-Server-and-ESB


  • 6.  RE: Regular Expression in Identifying query

    Posted Mon September 19, 2005 03:25 PM

    Mark/Yuan,

    Thanks for the inputs.

    ramesh.


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 7.  RE: Regular Expression in Identifying query

    Posted Tue September 20, 2005 04:34 AM

    Mark,

    I guess I should elaborate on what I mean by “troublesome”. I think it parallels the steps involved in finding out sender/receiver ID after identifying the TN DocType. That is, it rarely make sense to being able to extract sender/receiver ID before identifying the TN DocType. You wouldn’t know which partner is identified by “100300400” unless you know that it is a DUNS number, for example.

    So in the same way, I don’t quite understand how one would want to do RegEx to identify a DocType. Since you’re doing RegEx, that means you’re not quite sure where a certain tag or value would show up in the document – and by extension, you’re not exactly sure how the document is structured. For B2B purposes (which TN is intended), not having a strictly defined DocType (by Schema or DTD) is asking for trouble. There would be so many BRANCHes in a mapping flow, for example, since you won’t be sure which of the multiple documents you’re actually processing.

    In other words, I’m thinking of using RegEx in identifying query as a way of matching multiple document structures as the same DocType. Really don’t sound like a good idea. I think having RegEx in XQL makes a lot more sense when doing queryDocument. But, I’d love to hear about any kind of real usage for RegEx in Identifying Query…


    #Integration-Server-and-ESB
    #B2B-Integration
    #webMethods


  • 8.  RE: Regular Expression in Identifying query

    Posted Tue September 20, 2005 09:12 PM

    I think the most natural fit for using regex in TN DocType identification is to further refine the DocType. For example, you might want to identify a HighPriorityCustomerOrder rather than just a CustomerOrder when the orderPriority is some value or if the end customer (not the partner) is some value. This only makes sense if you have some different processing rules that need to be applied for one over the other and you could argue that that sort of logic fits better in a process map or flow step.

    My main point is that XQL supports regex, its easy to do and there are some valid reasons why you might want to do so. Use the right tool for the job, but always know what tools you have in the box.

    Mark


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 9.  RE: Regular Expression in Identifying query

    Posted Wed September 21, 2005 08:52 PM

    Regex isn’t necessarily required there either unless you are looking within a specific field and parsing its value.

    TN already provides element level differentiation for document identificiation.

    Better than smart data is a smart structure.
    Todd


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 10.  RE: Regular Expression in Identifying query

    Posted Wed December 07, 2005 08:15 AM

    Hi,

    I am sending the document(iDoc) from SAP to TN directly using wm.tn.receive service in routing rules.The problem is in identifing the document through document types , what I need to enter like root tag, ID and pipeline key-value pairs and what more I need to enter.

    It is the Idoc in pipeline, so what I need to enter in Idenity tab.

    Kindly, could you help me in creating document type in this scenario


    #Integration-Server-and-ESB
    #B2B-Integration
    #webMethods


  • 11.  RE: Regular Expression in Identifying query

    Posted Thu July 29, 2010 11:18 AM

    Hi,
    I need help to sort out this identifying query in TN.
    I’m working on wm6.5 version TN.
    coming to me question, in webMethods Trading Networks Users Guide 65- page number 535, its mentioned for pattern search we can use like this
    /bookstore/book/author[lastname/regex(‘Bo.’)].
    [FONT=Courier][SIZE=1][FONT=Courier][SIZE=1]

    However i tried to test this senario by creating TN document type with sample xml data which is mentioned in same TN developer users guide. I selected last-name from the xml string and selected “Add an identifying query” then it is assigned like this as
    Query = /bookstore[0]/book[0]/author[0]/last-name[0] and
    i placed Value = /bookstore/book/author[lastname/regex(‘Bo.’)]

    and tried all the posibilities which i can… but document not recognized.

    Pls can any one help me whatz wrong in this process.

    regards,
    Sam

    [/size][/font][/SIZE][/FONT]


    #Integration-Server-and-ESB
    #webMethods
    #B2B-Integration


  • 12.  RE: Regular Expression in Identifying query

    Posted Fri July 30, 2010 01:05 PM

    Fnrds,

    can any one give the solution on my question.
    We are trying to use this condition in our project.

    Pls help me.

    Regards,
    Sam


    #Integration-Server-and-ESB
    #B2B-Integration
    #webMethods


  • 13.  RE: Regular Expression in Identifying query

    Posted Mon August 02, 2010 08:12 AM

    Hi all,
    Pls can anyone give me the solution for this post
    [URL]wmusers.com.

    regards,
    Sam


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 14.  RE: Regular Expression in Identifying query

    Posted Thu August 05, 2010 05:08 AM

    Hi all,
    Atlast i tried all the ways and got solution…
    this is the query we need to assign :
    Query: /bookstore[0]/book[0]/author[0]/last-name[0]/regex(‘Bo.’)
    Value :

    Value is empty.

    Rgds,
    Sam


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 15.  RE: Regular Expression in Identifying query

    Posted Sun February 04, 2018 08:08 AM

    Hello Gurus,

    I’m trying to write a service which includes reading a xml file from a specified path and invoke bytestostring followed by xmlStringtoxmlnode and queryxmlnode services.

    However, I’m encountering issues with queryxmlnode using both wql and xql queries.All I get is null when I try to extract the List from the below sample xml

    XQL query used to pull the details of List - /List
    WQL query used to pull the details of List - doc.List

    I delacred List as output varibale under fields varibale of queryxmlnode as Record.

    Designer version - 9.6.

    Appreciate the quick help.


    #Integration-Server-and-ESB
    #B2B-Integration
    #webMethods