Details

    • Type: Task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.3
    • Component/s: Database, ElasticSearch
    • Labels:

      Description

      The DB table resource_index is redundant with the new Elasticsearch index named components. Using this new index brings complexity when web services rely on pagination of results. In that case a temporary workaround is to replace the SQL join on resource_index by upper(projects.name) like %xxx%. That's good enough for the administration web services that search for projects only (not files):

      • api/qualitygates/search, parameter "query"
      • api/ce/activity, parameter "q"
      • api/permissions/search_project_permissions, parameter "q"
      • api/components/search, parameter "q"
      • api/permissions/bulk_apply_template, parameter "q"
      • api/projects/search_my_projects, parameter "q"
      • api/measures/component_tree, parameter "q"
      • api/components/tree, parameter "q"

      The two last WS are the only one which could be improved in future. Relying on power of Elasticsearch index should improve user experience, for example of page "code".

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                simon.brandhof Simon Brandhof
                Reporter:
                simon.brandhof Simon Brandhof
              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: