AnsweredAssumed Answered

Global Field finding range?

Question asked by bookalaka_1 on Sep 6, 2012
Latest reply on Sep 6, 2012 by JimMac


Global Field finding range?


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.