Announcement

Collapse
No announcement yet.

How hide a field on search

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How hide a field on search

    Dear all,
    I'm searching to hide a field from search list but I'm not able to.
    Is there a way to achieve that ?
    Thanks

    See attachment
    Attached Files

  • #2
    Yes, SEARCH - QUICK SEARCH - SELECT FIELDS

    Comment


    • #3
      Yes, thanks .
      My question was becouse I did that on all the select fields list but it Always appears as it do not feel about any setting.
      Attached Files

      Comment


      • #4
        This is the query and on mySQL works correctly.

        SELECT
        products.ProductID as ProductID,
        products.ProductName as ProductName,
        products.SupplierID as SupplierID,
        products.CategoryID as CategoryID,
        products.CompanyID as CompanyID,
        QuantityPerUnit,
        products.QuantityMinOrder as QuantityMinOrder,
        products.ValueMinOrder as ValueMinOrder,
        Quantity,
        ProductID_altern,
        UnitsInStock,
        UnitsOnOrder,
        ReorderLevel,
        Discontinued,
        Image,
        TechSheetID,
        price_list.UnitPrice as PriceUnit,
        price_list.CurrencyID as CurrencyID
        FROM
        products LEFT OUTER JOIN price_list ON products.ProductID = price_list.ProductID AND price_list.CustomerID = '[glo_CustomerID]'


        See picture
        Attached Files

        Comment


        • #5
          Hi Alvagar,
          as in other situations I have to make the grid once again copying the previous one and reinserting the SQL code....
          Very bad but the only way to clean strange behaviours of SC.
          I don't know but sometime it happens. The problem is that is not predictable... ;-((((

          Comment


          • #6
            Yes, sometimes if a form is copied the result is not same.

            Comment

            Working...
            X