Feature #1884

Add more query options

Added by Karsten Dambekalns about 12 years ago. Updated about 10 years ago.

Status:
Resolved
Priority:
Should have
Category:
Persistence
Start date:
2008-10-27
Due date:
% Done:

100%

PHP Version:
Has patch:
Complexity:

Description

Querying is very basic right now.

When doing a query against object properties the following should work:
  • equality
    • checking against an object should work
    • checking against a value contained in an array/SplObjectStorage should work
  • lessThan, greaterThan, lessThanOrEqual, greaterThanOrEqual
  • like
  • something along the lines of IN

Associated revisions

Revision c2087f7d (diff)
Added by Karsten Dambekalns over 11 years ago

FLOW3:
  • added and/or/not to the query mechanism, refs #1884
TYPO3CR:
  • changed the way Lucene queries are built to allow more flexibility
  • added and/or/not to the query mechanism, refs #1875
  • some changes to handling of bound variables

Revision 18ab3356 (diff)
Added by Karsten Dambekalns over 11 years ago

FLOW3:
  • equality comparisons in persistence can now be done case-insensitive (in QueryInterface and Repository), refs #1884, refs #2811
TYPO3CR:
  • changed more use of PersistenceManager into PersistenceManagerInterface
  • added support for case-insensitive equality comparison in QueryInterface implementation, fixes #2811
  • implemented Literal, LowerCase, UpperCase in QOM
  • reduced the number of tables used for storing properties by roughly 50%
  • removed Lucene search backend
  • added in-RDBMS property index and new search backend based on it, refs #1886
FLOW3 Distribution:
  • removed Lucene package from Global packages
  • removed install.sh, it was broken anyway

Revision 30699a92 (diff)
Added by Karsten Dambekalns over 11 years ago

FLOW3:
  • equality comparisons in persistence can now be done case-insensitive (in QueryInterface and Repository), refs #1884, refs #2811
TYPO3CR:
  • changed more use of PersistenceManager into PersistenceManagerInterface
  • added support for case-insensitive equality comparison in QueryInterface implementation, fixes #2811
  • implemented Literal, LowerCase, UpperCase in QOM
  • reduced the number of tables used for storing properties by roughly 50%
  • removed Lucene search backend
  • added in-RDBMS property index and new search backend based on it, refs #1886
FLOW3 Distribution:
  • removed Lucene package from Global packages
  • removed install.sh, it was broken anyway

Revision 8571e9fd (diff)
Added by Karsten Dambekalns almost 11 years ago

[~TASK] FLOW3 (Persistence): Got rid of Literal, BindVariableValue, Ordering, Selector and QueryObjectModel; relates to #6267.
[+API] FLOW3 (Persistence): QueryInterface now has signatures for in() and contains(), relates to #1884.
[+FEATURE] FLOW3 (Persistence): Implemented query operators for in() and contains(), resolves #1884.

History

#1 Updated by Karsten Dambekalns about 12 years ago

  • Project changed from TYPO3.TYPO3CR to TYPO3.Flow
  • Category deleted (Query handling)

#2 Updated by Karsten Dambekalns about 12 years ago

  • Subject changed from Add more query options2 to Add more query options
  • Category set to Persistence

#3 Updated by Karsten Dambekalns about 12 years ago

  • Priority changed from Should have to Must have
  • Target version set to 1.0 alpha 1

#4 Updated by Robert Lemke over 11 years ago

  • Status changed from New to Needs Feedback

Please specify this ticket a bit more so we know when it can be closed.

#5 Updated by Karsten Dambekalns over 11 years ago

  • Status changed from Needs Feedback to Accepted
  • Assignee set to Karsten Dambekalns

#6 Updated by Robert Lemke over 11 years ago

  • Priority changed from Must have to Should have

#7 Updated by Karsten Dambekalns over 11 years ago

  • % Done changed from 0 to 60

Only array/SplObjectStorage left to do...

#8 Updated by Karsten Dambekalns over 11 years ago

  • Target version changed from 1.0 alpha 1 to 283

Postponing this to a later release, the array/SplObjectStorage support needs more work.

#9 Updated by Robert Lemke over 11 years ago

  • Target version deleted (283)

#10 Updated by Robert Lemke almost 11 years ago

  • Target version set to 1.0 alpha 8

#11 Updated by Karsten Dambekalns almost 11 years ago

  • Status changed from Accepted to Resolved
  • % Done changed from 60 to 100

Applied in changeset r3783.

Also available in: Atom PDF