Molkobain
64df429715
Merge remote-tracking branch 'origin/support/3.2' into develop
2026-07-02 21:12:38 +02:00
Molkobain
d6ef4fb7bb
N°9687 - Fix incorrect return type for the DBObjectSearch::ApplyDataFilter() function ( #939 )
...
* N°9687 - Fix incorrect return type for the DBObjectSearch::ApplyDataFilter() function
* N°9687 - Add unit test
* N°9687 - Improve unit test after code review
* N°9687 - Improve unit test after code review
2026-07-02 16:11:32 +02:00
Stephen Abello
2674e9c47f
Merge branch 'support/3.2' into develop
...
# Conflicts:
# tests/php-unit-tests/unitary-tests/core/ormDocumentTest.php
2026-03-31 15:51:27 +02:00
Stephen Abello
e467ca83cf
N°8532 - Apply filters on all DBSearch classes ( #848 )
...
Co-authored-by: Molkobain <lajarige.guillaume@free.fr >
Co-authored-by: Thomas Casteleyn <thomas.casteleyn@super-visions.com >
2026-03-31 15:41:28 +02:00
Eric Espie
dad39c3ebe
Merge support/3.2 into develop
2026-02-24 13:55:55 +01:00
Eric Espié
48e584503e
N°8782 - Union queries allow all data ( #807 )
...
* 8782 - Union queries allow all data
* N°8782 - Union queries allow all data
2026-02-23 15:10:09 +01:00
odain
b0a792afab
N°8796 - Add PHP code style validation in iTop and extensions - format whole code base
2025-11-07 20:39:38 +01:00
odain
890a2568c8
N°8796 - Add PHP code style validation in iTop and extensions - format whole code base
2025-11-07 15:39:53 +01:00
Anne-Cath
7b95d65f60
N°3653 - Remove parameter for \DBObjectSearch::GetQueryParams
2025-08-01 10:05:40 +02:00
Molkobain
ad36066126
📝 Copyright year bump
2024-05-06 18:35:31 +02:00
Eric Espie
5f359b2b61
N°6151 - Allow to select classes on union outside the already selected classes
2023-05-31 14:40:13 +02:00
Eric Espie
d8b21e11ed
N°6182 - Fix crash with UNION OQL queries when classes / aliases are different
2023-04-26 15:09:12 +02:00
Eric Espie
2907efde4b
N°6151 - Portal rules: source_oql containing UNION not allowed
2023-04-06 11:07:05 +02:00
Molkobain
c767ebe989
📝 Copyright year bump
2023-03-17 18:28:47 +01:00
Pierre Goiffon
815870fe6b
Merge remote-tracking branch 'origin/support/2.7' into support/3.0
...
# Conflicts:
# application/cmdbabstract.class.inc.php
# dictionaries/cs.dictionary.itop.model.php
# dictionaries/da.dictionary.itop.model.php
# dictionaries/de.dictionary.itop.model.php
# dictionaries/es_cr.dictionary.itop.model.php
# dictionaries/fr.dictionary.itop.model.php
# dictionaries/hu.dictionary.itop.model.php
# dictionaries/it.dictionary.itop.model.php
# dictionaries/ja.dictionary.itop.model.php
# dictionaries/pl.dictionary.itop.model.php
# dictionaries/pt_br.dictionary.itop.model.php
# dictionaries/tr.dictionary.itop.model.php
# dictionaries/zh_cn.dictionary.itop.model.php
2022-02-22 09:36:06 +01:00
acognet
83e98ef2b8
N°4284 - Object modification: Attribute value lost if not allowed to be seen
2022-02-17 17:06:06 +01:00
acognet
788caf9c50
N°4284 - Object modification: Attribute value lost if not allowed to be seen
2022-02-14 12:26:16 +01:00
Molkobain
8dd96ea636
Copyright year bump
2021-03-15 09:29:45 +01:00
Pierre Goiffon
6cd0670d6b
🎨 Fix parameter for all DBSearch::AllowAllData impl
2020-10-01 10:09:34 +02:00
Eric
dbada2f72a
N°3238 - Fix multi-words search in FilterBrick and ManageBrick
2020-09-04 17:34:59 +02:00
Eric
ace676dc24
N°2585 - Fix alias problem in portal scopes
...
The re-aliasing map structure now allows multiple mapping for the same alias (used for the translations of UNIONS)
2020-07-23 16:41:57 +02:00
Eric
8122270476
N°3176 - OQL: Fix malformed UNION queries in portal scopes
...
Fix regression in Unit tests
2020-07-22 17:30:38 +02:00
Eric
94f9b16c03
N°2589 - Infinite loops when logging with a Contact having a non empty TagSet field
...
Add ListParameters to DBSearch for nested queries
2020-06-24 15:18:11 +02:00
acognet
f7ea6c09cd
N°2589 - Infinite loops when logging with a Contact having a non empty TagSet field
2020-05-05 19:00:24 +02:00
Eric
f94e86ecea
🐛 Add missing function
2020-02-14 17:18:00 +01:00
Eric
3ae4ca89f4
N°1213 - Allow NOT IN SELECT in OQL syntax - support of UNION queries and "nested nested" queries
2019-12-03 17:14:53 +01:00
Denis Flaven
36584092e5
(Experimental) Export a DBSearch as an array/JSON structure.
2019-11-13 18:03:58 +01:00
Eric
5642552f9a
N°1888 - Filter search with another search
2019-10-23 12:56:02 +02:00
Eric
36b325f71d
N°2517 - Supportability - OQL Explain
2019-10-17 11:06:31 +02:00
Eric
7d8e8df0c5
N°2272 - OQL performance (fix 2.5 regression)
2019-09-10 13:06:47 +02:00
bruno DA SILVA
22416cc0be
:note: PhpDoc generation for the public API
...
- typo (tunning => tuning)
- rework of the README.md
2019-05-24 14:05:22 +02:00
OИUЯd da silva
9c75cb4537
:note: PhpDoc generation for the public API ( #63 )
...
- generate phpdoc to a dokuwiki compatible format
- add/update the phpdoc of a selection of class methods
2019-05-21 12:05:52 +02:00
Eric
e4619fbc0f
N°1724 - Fix external key search error when an UNION is used as a filter in the datamodel
2018-11-06 10:01:36 +01:00
Eric
518d94f5f3
Fix audit bug (DBUnionSearch::AddConditionForInOperatorUsingParam() does not exist) when category is a UNION and rule flag 'Valid objects?' is 'true' and there are invalid entries in the result of the audit.
2018-11-06 08:49:35 +01:00
Eric
389a1791d7
N°828 - GetSelectFilter issue with DBUnionSearch
2018-11-06 08:49:35 +01:00
Pierre Goiffon
40a4e6d7b0
Fix files using CrLf, convert them to Lf to have the whole repo using Lf
...
Warn your git config (core.autocrlf = input or true)
2018-09-04 17:59:51 +02:00
Eric Espié
03f9a9fcac
N°1161 - Add functions, order by and limits to DBSearch::MakeGroupByQuery()
...
SVN:trunk[5350]
2018-02-16 12:59:35 +00:00
Eric Espié
23f2ea5031
N°1026 - Portal requests are too slow
...
* Counts on union requests are more optimized
* Requests for combo box values are more optimized
SVN:trunk[5249]
2018-01-15 15:16:20 +00:00
Pierre Goiffon
b2494ebaf7
Create abstract DBSearch#GetSQLQueryStructure() to allow "call hierarchy" to work
...
Visibility to public to allow testing
SVN:trunk[5187]
2018-01-02 14:19:54 +00:00
Romain Quetiez
248f8d6fd4
Obsolescence: finalizing the implementation of the flag (hide obsolete objects, show an icon on hyperlinks and a tag on the object details, user preference defaulting to the new setting 'show_obsolete_data')
...
SVN:trunk[4739]
2017-05-17 08:51:10 +00:00
Romain Quetiez
3644553886
N.609 Some multi-column UNION queries failing with various symptoms such as "Class 'IT Department' not found" or "An object id must be an integer value"
...
SVN:trunk[4634]
2017-03-29 19:58:02 +00:00
Romain Quetiez
d3f5d05063
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.
...
SVN:trunk[4469]
2016-10-28 09:08:30 +00:00
Romain Quetiez
fe6ae6f2eb
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!
...
SVN:trunk[4448]
2016-10-07 08:45:24 +00:00
Romain Quetiez
23193153c6
N°436 Core API: Correctly (mathematically!) handle the "allow all data" flag, with UNIONS and INTERSECTIONS. Requires testing
...
SVN:trunk[4404]
2016-09-19 13:08:32 +00:00
Romain Quetiez
3c9072bb65
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 '='.
...
SVN:trunk[4233]
2016-06-21 14:38:08 +00:00
Guillaume Lajarige
4b7fb20eaf
DBSearch : Allow join between DBUnionSearch by adding the DBUnionSearch::Join verb
...
SVN:trunk[3952]
2016-03-16 16:45:39 +00:00
Romain Quetiez
4006fce0f2
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.
...
SVN:trunk[3948]
2016-03-11 20:42:04 +00:00
Romain Quetiez
0f4301af01
Core API: added DBSearch:SetSelectedClasses
...
SVN:trunk[3815]
2015-11-09 10:35:51 +00:00
Romain Quetiez
baf54a7c02
#942 OQL now supporting unions. Unions support polymorphism and can be used anywhere in the application.
...
SVN:trunk[3631]
2015-07-08 17:10:40 +00:00