 romainq
|
ad34ae5628
N.505 Regression introduced in [r4404]. Security issue - Object visibility totally screwed the APC cache (user data) is enabled. This is a change in the way SQL queries are built and therefore requires testing.
|
před 8 roky |
|
romainq
|
8fd191860b
N.434 ... Continuation... Fixed regression introduced in [r4448]. OQL (parsed) queries are optimized too but the SQL query cannot be executed. See example herebelow:
|
před 8 roky |
|
romainq
|
81cac08849
N.434 Optimized the DB queries. As an example, the query that shows the service catalog in the enhanced customer portal is now made of 5 nodes (at the class level) whereas it used to be made of 11 nodes... for the exact same results. This optimization impacts almost each queries built by iTop. The expected benefit can insignificant or not, depending on the cardinality of the data, the datamodel and the original OQL queries. We found one case where the query execution would apparently never end and it takes now less than a second. The risk with such a change is that is affects most of the queries built by iTop -requires testing!
|
před 8 roky |
|
romainq
|
c05b6818e5
N°436 Core API: Correctly (mathematically!) handle the "allow all data" flag, with UNIONS and INTERSECTIONS. Requires testing
|
před 8 roky |
|
romainq
|
1d69c5f27c
OQL: fixed an old limitation, hierarchies can now be expressed both ways. Example of a query that now works fine: SELECT Organization AS root JOIN Organization AS child ON child.parent_id BELOW root.id WHERE child.name LIKE 'Combodo'. In the previous implementation, the operator was interpreted as '='.
|
před 9 roky |
|
romainq
|
99ec255431
Internal: DBSearch::Intersect to throw an exception whenever any of the merged queries have a queried class that does not correspond to the first joined class. This is a limitation of the current implementation of Intersect. Allowing such use cases would require quite a rework of that API.
|
před 9 roky |
 dflaven
|
ccef399cfa
Support of date and time custom formats... continuing towards the beta !
|
před 9 roky |
|
romainq
|
0064a82cd2
Fixed regression introduced with [3912] : autocomplete not working (new User request with lots of existing user requests)
|
před 9 roky |
 glajarige
|
682a9c7b5d
DBSearch : Allow join between DBUnionSearch by adding the DBUnionSearch::Join verb
|
před 9 roky |
|
romainq
|
3c7638bf00
Exclude magic parameters when listing query parameters (refactoring from run_query) This enables the use of magic parameters in the exports. The issue was less exposed in iTop 2.2.0 because only one single magic parameter was available.
|
před 9 roky |
|
romainq
|
0dff1739a5
Internal: fixed the verb DBObjectSearch::IsAny
|
před 9 roky |
|
romainq
|
b5c84b99ca
Internal: dehardcoded OqlUnionQuery::GetClass against the metamodel reflection API
|
před 9 roky |
|
romainq
|
5f0de18ba6
Core API: added DBSearch:SetSelectedClasses
|
před 9 roky |
|
romainq
|
e8b4c78402
#1140 UNION queries not working -in fact, loss of the optimization on column load when filtering on org hierarchies (retrofit possible but the fix will be located in MetaModel)
|
před 10 roky |
|
romainq
|
9628e5b4a1
Fixed regression introduced in 2.2.0 beta. Warning issued when opening an organization for modification
|
před 10 roky |
|
romainq
|
61383b5378
#1123/#1133 The optimization on loaded columns in SQL queries was inoperant for some queries, resulting in a stopper issue if such queries were added to a union query (2.2.0 beta)
|
před 10 roky |
|
dflaven
|
3473e5259b
Bug fix: typo causing the generation of invalid SQL queries (in some rare cases).
|
před 10 roky |
|
romainq
|
5ed735e8d0
#942 OQL now supporting unions. Unions support polymorphism and can be used anywhere in the application.
|
před 10 roky |
|
dflaven
|
fc2c1498a6
Better error reporting (thanks to Stefan Goethals for suggesting it).
|
před 10 roky |
|
romainq
|
a97ec14388
#983 Sortering not possible on multi-column queries
|
před 10 roky |
|
dflaven
|
b6cefa790f
Fix for a warning about mysql_free() revealing a problem with DBObjectSet
|
před 11 roky |
|
romainq
|
4fe6b12cb0
OQL normalization and dashlets have been made independent from the class MetaModel
|
před 12 roky |
|
romainq
|
f5904fd2ea
#702 The second implementation of this fix was still incomplete (not compatible with some constraint queries)
|
před 12 roky |
|
romainq
|
57369a92a7
#702 The first implementation of this fiw was not incomplete (not compatible with some constraint queries)
|
před 12 roky |
|
romainq
|
82b2e16742
#702 Ignoring the class when looking up for a polymorphic ext key
|
před 12 roky |
|
romainq
|
0549edf93a
Added a comment to explain why the APIs AddCondition_PointingTo and AddCondition_ReferencedBy must be left unprotected (do not clone the passed filter). See trac #639
|
před 12 roky |
|
dflaven
|
51219cc518
Fix for a SQL error (regression) in the Portal
|
před 12 roky |
|
romainq
|
a148f032eb
Fixed stopper issue (found with an audit) due to copies of DBObjectSearch not cloned (or not cloned well)
|
před 12 roky |
|
romainq
|
d354d5c131
Integrated the multiple select in the portal (search closed tickets)
|
před 12 roky |
|
romainq
|
eafa11ecfe
Updated copyright (2012) and license (LGPL changed to AGPL)
|
před 12 roky |
