Custom Query (2152 matches)

Filters
 
Or
 
  
 
Columns

Show under each result:


Results (931 - 933 of 2152)

Ticket Resolution Summary Owner Reporter
#245 duplicate Support for composite primary keys rgrp rgrp

Reported by rgrp, 4 years ago.

Description

Problem here is that foreign key then becomes "complicated" (composite).

  • Could also deprecate continuity_id field in favour of the basic foreign key on ie
#246 duplicate Support for primary key not named id rgrp rgrp

Reported by rgrp, 4 years ago.

Description

At the moment setting of continuity_id depends on base table pkcol being id. Should not be hard to change this -- and may get for free as part of ticket:245 (composite primary keys)

#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

Note: See TracQuery for help on using queries.