Task #2381

Improve Search engine : Join management

Added by moyo over 9 years ago. Updated over 9 years ago.

Status:ClosedStart date:10/29/2010
Priority:NormalDue date:
Assignee:moyo% Done:

100%

Category:Search Engine
Target version:0.80

Description

Add :
- condition to add a specific condition to the ON clause (itemtype=XXX or other)
- beforejoin (with table / linkfield / addcondition...) to permit to add a table between reference one and linked one
- addjoin (with table / linkfield / addcondition...) to permit to add a table without reference to existing link
- jointype : child (computer/ computerdisks) / itemtype_item (ticket / items)

Problem : cascading beforejoin...

Hope it will permit to reduce specific cases

- In a second time (after GLPI 0.80) review addLeftJoin prototype (pass it of searchoption) to manage it easily. Also put linkfield in joinparams...

- In a third time make link between objects in classes instead of in SearchOption.

Associated revisions

Revision 12935
Added by moyo over 9 years ago

first try for see #2381

Revision 12939
Added by moyo over 9 years ago

add ischlid serach param : see #2381

Revision 12940
Added by moyo over 9 years ago

more work on see #2381 : add beforejoin condition

Revision 12941
Added by moyo over 9 years ago

see #2381 : manage several links with a table using several condition

Revision 12943
Added by moyo over 9 years ago

more work on see #2381

Revision 12953
Added by moyo over 9 years ago

manage same table join using 2 different way : see #2381

Revision 12954
Added by moyo over 9 years ago

manage where clause for last see #2381

Revision 12955
Added by moyo over 9 years ago

more work on see #2381

Revision 12956
Added by moyo over 9 years ago

more work on see #2381

Revision 12959
Added by moyo over 9 years ago

work on join tickets : itemtype / item see #2381

Revision 12962
Added by moyo over 9 years ago

work on network join : problem for vlans... see #2381

Revision 12963
Added by moyo over 9 years ago

several before join (for vlans for example) see #2381

Revision 12964
Added by moyo over 9 years ago

work on contracts see #2381

Revision 12965
Added by moyo over 9 years ago

more work on see #2381

Revision 12968
Added by moyo over 9 years ago

fix search engine for multi users : see #839 and see #2381

Revision 13061
Added by moyo over 9 years ago

fix massive action see #2381

Revision 13184
Added by moyo over 9 years ago

see #2381 more work

Revision 13185
Added by moyo over 9 years ago

see #2381 : work on software versions

Revision 13187
Added by moyo over 9 years ago

more work on see #2381

Revision 13188
Added by moyo over 9 years ago

see #2381 for plugins

Revision 13189
Added by moyo over 9 years ago

more work on see #2381
TODO : infocoms

Revision 13190
Added by moyo over 9 years ago

fixed #2381

Revision 13266
Added by moyo over 9 years ago

clean code see #2381

Revision 13358
Added by moyo over 9 years ago

fixed #2536 to trunk / need to modify see #2381

History

#1 Updated by moyo over 9 years ago

  • % Done changed from 0 to 50

#2 Updated by moyo over 9 years ago

  • Status changed from New to Resolved
  • % Done changed from 50 to 100

#3 Updated by moyo over 9 years ago

  • Status changed from Resolved to Assigned
  • % Done changed from 100 to 50

#4 Updated by moyo over 9 years ago

  • Status changed from Assigned to Resolved
  • % Done changed from 50 to 100

Applied in changeset r13190.

#5 Updated by moyo over 9 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF