Custom Query (2152 matches)

Filters
 
Or
 
  
 
Columns

Show under each result:


Results (1675 - 1677 of 2152)

Ticket Resolution Summary Owner Reporter
#249 invalid Regex search rgrp dread

Reported by dread, 4 years ago.

Description

Search of package name and title (and other fields) using regular expressions.

Current example use-case: Wanting to specify packages with title beginning with 'B'.

Issues:

  • Syntax for specifying regex over natural language search - could it be contained in the q param so be available to users of the WUI, or do we simply make it alternative fields?

Implementation:

  • Postgres reg ex searching detailed here:

http://www.postgresql.org/docs/current/static/functions-matching.html#FUNCTIONS-POSIX-TABLE

#252 invalid Change revision object so that it has parent(s) attribute dread johnbywater
#312 invalid Race condition creating PackageRating rgrp dread

Reported by dread, 4 years ago.

Description

On ckan.net there are a few packages which cause a 403 exception when you try to rate them: http://www.ckan.net/package/rate/coins-data?rating=3

The exception is occuring here: ckan.rating:39 in set_rating rating_obj = rating_query.one() InvalidRequestError?: Multiple rows returned for one()

It looks like this package got rated twice in quick succession, creating two similar PackageRating? objects. This race condition needs to be solved and these particular rating objects repaired.

Note: See TracQuery for help on using queries.