Take the 2-minute tour ×
ExpressionEngine® Answers is a question and answer site for administrators, end users, developers and designers for ExpressionEngine® CMS. It's 100% free, no registration required.

I have a client site who is pulling in channel entries with dollar amounts in them; most of the dollar amounts are regular numbers, 2000, 100, etc., some are negative amounts (chargebacks?), -1600, etc., and some are just a dash "-".

I'm trying to filter the just dash "-" entries out of the results.

The parameter

search:tax_deductible_amount="not -"

removes all negative and just dash entries; however, the parameter with exact matching

search:tax_deductible_amount="=not -"

returns everything. Does it not recognize special characters?

Help?

Thanks!

share|improve this question
add comment

2 Answers

I've just setup a few debug entries and excluding exact dash matches does seem to work.

{exp:channel:entries channel="about" search:about_body="=not -"}

All I can suggest is that you double-check that there's no whitespace surrounding your data and that you aren't being caught out by fancy dashes.

share|improve this answer
add comment

You might want to try the add-on Search Fields:

http://devot-ee.com/add-ons/search-fields

...if you can't get it to work with the Channel Entries tag. Search Fields is free and offers some other searchoptions too.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.