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

    Formatted Seach

    Barbara Peterson

      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?

      • Reply
        • 1. Re: Formatted Seach
          Richard Duffy

          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