You are here: Foswiki>Tasks Web>Item10628 (12 Apr 2011, SvenDowideit)Edit Attach

Item10628: MongoDB query does not do numeric OP's on number fields / prefs correctly, because atm, everything isa string.

pencil
Priority: Urgent
Current State: Confirmed
Released In: n/a
Target Release: n/a
Applies To: Extension
Component: MongoDBPlugin
Branches:
Reported By: SvenDowideit
Waiting For: SvenDowideit
Last Change By: SvenDowideit
I'm not at all sure how to fix this in a performant way.

I probably have to make a numeric_value field everywhere - PREFS, ATTACHMENTS, whatever, and when there is an $lt etc, detect and use the other value?

cos string ops need to work ok on non-strings too?

might try out converting to numerics in db tho

-- SvenDowideit - 12 Apr 2011

 

ItemTemplate edit

Summary MongoDB query does not do numeric OP's on number fields / prefs correctly, because atm, everything isa string.
ReportedBy SvenDowideit
Codebase
SVN Range
AppliesTo Extension
Component MongoDBPlugin
Priority Urgent
CurrentState Confirmed
WaitingFor SvenDowideit
Checkins
TargetRelease n/a
ReleasedIn n/a
Topic revision: r1 - 12 Apr 2011, SvenDowideit - This page was cached on 14 Oct 2020 - 02:11.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy