Ticket #233 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

Sort on 'mediafile_duration' gives strange result

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

Description (last modified by Michiel.Schok) (diff)

When performing a search query on assets and sorting by 'mediafile_duration', we observe strange results. Some of the assets appear twice in the result list.

Compare the following two results:

[GET] asset?limit=50&hide_empty_assets=true&cql=((owner_id==SURFNET.michiel))+sortby+mediafile_duration

...
<item_count_total>32</item_count_total>
...

and

[GET] asset?limit=50&amp;hide_empty_assets=true&amp;cql=((owner_id==SURFNET.michiel))+sortby+title

...
<item_count_total>29</item_count_total>
...

It seems as if the 'external assets' with an empty 'mediafile_duration' appear as well at the top of the list, as on the bottom of the list.

Change History

Changed 3 years ago by Michiel.Schok

  • description modified (diff)
  • summary changed from Sorteren op 'mediafile_duration' geeft vreemd resultaat to Sorteren op 'mediafile_duration' gives strange result

Changed 3 years ago by Michiel.Schok

  • summary changed from Sorteren op 'mediafile_duration' gives strange result to Sort on 'mediafile_duration' gives strange result

Changed 3 years ago by Frans

  • version 1.7.2 deleted
  • milestone changed from MediaMosa X.X to MediaMosa 2.1

Changed 3 years ago by forgacs

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

Changed 3 years ago by forgacs

  • owner changed from forgacs to robert

Robert: I can confirm this behaviour. If an asset has is_external = TRUE and mediafile_duration is empty, then it appears in the list two times.

Changed 3 years ago by robert

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

Fixed. Problem was caused by empty mediafile_duration values and the new way we sort in 2.x.

Changed 3 years ago by Michiel.Schok

  • tested changed from no to yes
  • accepted changed from no to yes

Both rest-calls now result in '50 items'.

Note: See TracTickets for help on using tickets.