Ticket #127 (closed defect: fixed)

Opened 4 years ago

Last modified 4 years ago

CQL search is not always returning all relevant documents

Reported by: Michiel.Schok Owned by: robert
Priority: major Milestone: MediaMosa 1.7
Component: Core Version: 1.7.0.1
Keywords: Cc:
MoSCoW: Estimated time after impact analysis:
Related to project: none Tested:
Accepted: yes Estimated Hours:

Description

Example below is for SURFmedia, app id 5 on the VP-core environment.

When searching for the string 'nav 100 jaar' in the description, we expect to find asset-id 30092. That asset is not found.

"100 JAAR WONINGWET" also does not return the same asset.

The rest-call we use is:

<request_uri>[GET] asset?cql=((description+=+"nav")+AND+(description+=+"100")+AND+(description+=+"jaar"))+&hide_empty_assets=true&limit=10&offset=0&aut_domain=zeelandnet.nl&app_id=5</request_uri>

Any idea what is going on? Is CQL to blame, or do we request the wrong way?

Change History

Changed 4 years ago by Michiel.Schok

We have performed several tests in house. It seems like a limit on the number of characters of the description that is searched. Limit is not fixed but it's in the 1000-1100 range.

Does that make sense?

Changed 4 years ago by MC-arjen

  • owner set to robert
  • status changed from new to assigned

Changed 4 years ago by robert

  • status changed from assigned to closed
  • resolution set to duplicate

The text '100 jaar woningwet' is beyond the 1000 chars threshold, so this is the reason why the asset is not found. This is a known bug and has been reported.

Changed 4 years ago by Michiel.Schok

Can you please give me another trac-id where it is reported, so I can 'subscribe' to that thread?

Changed 4 years ago by Frans

  • status changed from closed to reopened
  • version set to Not Resolved
  • resolution duplicate deleted

Won't find it. This is it.
Removed duplicate and setting status to not resolved.

Changed 4 years ago by MC-arjen

This is a issue which is reported in VP-Core trac: #17 ... I have no problem to leave it in this resolution/status until it is solved there.

Changed 4 years ago by admin

  • milestone changed from MediaMosa 1.6 to MediaMosa 1.7

Changed 4 years ago by MC-arjen

  • status changed from reopened to closed
  • resolution set to fixed

released in 1.7.0.1

Changed 4 years ago by Frans

  • version changed from Not Resolved to 1.7.0.1

Changed 4 years ago by Michiel.Schok

  • accepted changed from no to yes

CQL now return the assets mentioned above, where the searchstring is on the end of the description (>1000 chars).

Note: See TracTickets for help on using tickets.