1 Reply Latest reply on Sep 6, 2012 6:03 AM by JimMac

    Global Field finding range?

    bookalaka_1

      Title

      Global Field finding range?

      Post

      I have a Products portal that I would like to filter by price  range using global fields. I created g_PriceLow, g_PriceHigh and g_PriceCalc that = g_PriceLow&"..."g_PriceHigh . My relationship is g_PriceLow x ProductsPrice, g_PriceHigh x ProductsPrice and g_PriceCalc x ProductsPrice filtering the portal using ((Order_Entry::gSearchField_PriceLow  ≥ Order_Entry::gSearchField_PriceHigh and Order_Entry::gSearchField_PriceLow  ≤  Order_Entry::gSearchField_PriceHigh) )

      I used a similiar formula on a date range search with success but this doesnt work at all. What connection am I missing?

      Thank you for the help.