Feature #1884

Add more query options

Added by Karsten Dambekalns almost 7 years ago. Updated almost 5 years ago.

Status:Resolved Start date:2008-10-27
Priority:Should have Due date:
Assigned To:Karsten Dambekalns % Done:

100%
Category:Persistence
Target version:TYPO3 Flow Base Distribution - 1.0 alpha 8
PHP Version: Complexity:
Has patch:

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

Related issues

related to TYPO3.TYPO3CR - Feature #1875: Add more query options to persistence backend Closed 2008-10-27
blocked by TYPO3.TYPO3CR - Task #3456: Refactor internal CR representation of object references Closed 2009-05-25

Associated revisions

Revision c2087f7d
Added by Karsten Dambekalns over 6 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
Added by Karsten Dambekalns over 6 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
Added by Karsten Dambekalns over 6 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
Added by Karsten Dambekalns over 5 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 almost 7 years ago

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

#2 Updated by Karsten Dambekalns almost 7 years ago

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

#3 Updated by Karsten Dambekalns almost 7 years ago

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

#4 Updated by Robert Lemke over 6 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 about 6 years ago

  • Status changed from Needs Feedback to Accepted
  • Assigned To set to Karsten Dambekalns

#6 Updated by Robert Lemke about 6 years ago

  • Priority changed from Must have to Should have

#7 Updated by Karsten Dambekalns about 6 years ago

  • % Done changed from 0 to 60

Only array/SplObjectStorage left to do...

#8 Updated by Karsten Dambekalns about 6 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 about 6 years ago

  • Target version deleted (283)

#10 Updated by Robert Lemke over 5 years ago

  • Target version set to 1.0 alpha 8

#11 Updated by Karsten Dambekalns over 5 years ago

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

Applied in changeset r3783.

Also available in: Atom PDF