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.
Review your logic. I think i see...
PLow ≥ PHigh AND PLow ≤ PHigh
This can never be TRUE.