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.

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