B1 Search - Customize Standard Searches

No planeada

Thomas Speranza

• 14 de junio de 2021 11:14

Hello,

We would like to adapt the standard searches from B1Search. Both the results view and the search parameters. Is there a possibility to adapt this or do we somehow get to the select statement that is executed in the background?

Vote

1

• 

  SSP Automation

  • 14 de junio de 2021 11:16

  Thank you for your request. It has been scheduled for review by the development team that will get back to you should there be questions.
  (Please note that as we are user-driven we can't guarantee that your request will be met unless it gets many votes and/or fit the product vision)
  Read more about the Feature Request process here
  [Internal Id: 58689]
  
• 

  Rasmus Jensen

  • 14 de junio de 2021 13:15

  I'm afraid that is not something we offer. You can use as-is or build your own, but we do not have anything for customizing the existing ones.
• 

  Thomas Speranza

  • 14 de junio de 2021 13:19

  Ok, no Problem.

  Can we get the Search Statement for the Sales Documents? Then we can customize this one for us.

   
• 

  Rasmus Jensen

  • 14 de junio de 2021 13:50

  It is a dynamically built up SQL (example it dynaimcally append all UDFs...)

  But the best way to get the SQL is to use  the B1UP's Debug Console, do a search and grab the SQL

  

  My SQL is this

  

  SELECT DISTINCT TOP 100 T0.DocEntry, T0.DocNum, T0.CardName, T0.DocDate FROM ORDR T0 LEFT JOIN OCPR T1 ON T0.CntctCode = T1.CntctCode LEFT JOIN OPRJ T2 ON T0.Project = T2.PrjCode LEFT JOIN OSLP T3 ON T0.SlpCode = T3.SlpCode LEFT JOIN OHEM T4 ON T0.OwnerCode = T4.empID WHERE (T0.DocNum LIKE '%'+@SearchString+'%' OR T0.CardCode LIKE '%'+@SearchString+'%' OR T0.CardName LIKE '%'+@SearchString+'%' OR T0.PaymentRef LIKE '%'+@SearchString+'%' OR T0.NumAtCard LIKE '%'+@SearchString+'%' OR T0.Comments LIKE '%'+@SearchString+'%' OR T0.Address LIKE '%'+@SearchString+'%' OR T0.Address2 LIKE '%'+@SearchString+'%' OR T0.JrnlMemo LIKE '%'+@SearchString+'%' OR T0.TrackNo LIKE '%'+@SearchString+'%' OR T1.Name LIKE '%'+@SearchString+'%' OR T2.PrjName LIKE '%'+@SearchString+'%' OR T3.SlpName LIKE '%'+@SearchString+'%' OR T4.firstName + ' ' + T4.middleName + ' ' + T4.lastName LIKE '%'+@SearchString+'%' OR T4.firstName + ' ' + T4.lastName LIKE '%'+@SearchString+'%' OR T0.U_BOYX_DEL LIKE '%'+@SearchString+'%' OR T0.U_BOY_E0_CCPAYEX LIKE '%'+@SearchString+'%' OR T0.U_BOY_E0_AUTHACTION LIKE '%'+@SearchString+'%' OR T0.U_BOY_E0_ONETIMCC LIKE '%'+@SearchString+'%' OR T0.U_ProjectManager LIKE '%'+@SearchString+'%' OR T0.U_BOYX_KBSTATUS LIKE '%'+@SearchString+'%' OR T0.U_fn_innendienst LIKE '%'+@SearchString+'%' OR T0.U_fn_innendienstname LIKE '%'+@SearchString+'%' OR T0.U_fn_vov_auftragsstatus LIKE '%'+@SearchString+'%' OR T0.U_FN_Tour_Nr LIKE '%'+@SearchString+'%') AND T0.DocStatus != 'C'

Iniciar sesión para dejar un comentario.