Saltar al contenido principal

B1 Search - Customize Standard Searches

No planeada

Comentarios

4 comentarios

  • SSP Automation
    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

    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 Hüttner

    Ok, no Problem.

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

     

  • Rasmus Jensen

    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.