1 Reply Latest reply on Jan 22, 2018 5:57 PM by Richard Duffy

    Formatted Seach

    Barbara Peterson
    Barbara Peterson Jan 19, 2018 4:11 PM

      I am trying to create a formatted search that will bring up a list of a BP customer's Equipment Cards.  Syntax below.

      SELECT T0.[internalSN], T0.[itemCode], T0.[itemName]  FROM OINS T0 WHERE T0.[customer] = $[OCRD.CardCode]

       

      Even through I am using the OINS table when I click the golden arrow in the results I takes me to the Bill of Materials, then I click the Item again and I go to the Item Master, even though I am using the OINS table.  Does anyone know if there is a way to change the path of the golden arrow in a formatted search?

      • 181 Views
      • Categories: Version: 9.2, Module: Service
      • Tags:
      • Reply
        • 1. Re: Formatted Seach
          Richard Duffy
          Richard Duffy Jan 22, 2018 5:57 PM (in response to Barbara Peterson)

          Barbara, the golden arrow is flagged in a query automatically based on the table structures that you are using and the content in those tables...no surprise or secrets there right?

           

          The Equipment Card itself has a record number and thats what you need to add you your query so it looks like this...

           

          SELECT T0.[insID], T0.[internalSN], T0.[itemCode], T0.[itemName]  FROM OINS T0 WHERE T0.[customer] = $[OCRD.CardCode]

           

           

          I hope this helps