I have this strange situation where a specific predefined search (via a connected search component with predefined operator of “is” with the value coming from a URL value) comes up blank…
But a table based search does find the value…
Similarly, a table based filter, is not successful…
But filtering between a range does find the value…
Can anyone help me figure this out please?
Yet, different amounts seem to work?
I thought it may be a rounding issue, so I set the field to 3 decimals, but that’s not it.
Anyone?
Am I doing something stoopid, or is there a system funny?
I created a workaround with an equation converting the currency amount to a text value and searching on that, and it works, but I don’t think the extra step should be necessary.
Hey @brettlewis,
Didn’t mean to leave you hanging! I think this warrants a closer look.
Can you please submit a ticket or contact us via email/chat?
I have chatted to Lee and there appears to be a bug around currency field searches - they are working on it.
In the meantime my workaround is similar to what they suggested.
1 Like