Hi,
Using the (relatively new) bug search page, I was trying to filteri
among the (unclosed) RC bugs targeting Trixie but I was not able to
restrict[0] to the Debian Game team eam (not easy to put the right
value (pkg-games-de...@lists.alioth.debian.org), any select list? like
pattern? regex?).
Best regards,
Patrice
[0] to get an AND in place of an OR regarding bugs.source clause in
the following UDD query.
select id, bugs.package, bugs.source, severity, title, last_modified,
status, affects_stable, affects_testing, affects_unstable,
affects_experimental
from bugs
where id in (select id from bugs_rt_affects_testing)
and not (id in (select id from bugs_merged_with where id > merged_with))
and not (status = 'done')
AND (severity >= 'serious'
OR bugs.source in ('plib-doc', 'uqm-russian', 'frogatto',
'lightyears', 'cevomapgen', 'solarwolf', 'genesisplusgx', 'c-evo-dh',
'frogatto-data', 'slimevolley', 'warzone2100', 'xmahjongg',
'gtkballs', 'corsix-th', 'libsmacker', 'lgeneral', 'cube2',
'minetest-mod-lucky-block', 'billard-gl', 'qtads', 'pokerth',
'viruskiller', 'connectagram', 'cdogs-sdl',
'minetest-mod-character-creator', 'amoebax', 'endless-sky',
'minetest-mod-currency', 'gnomekiss', 'gplanarity',
'libretro-core-info', 'gav', 'zoom-player',
'minetest-mod-infinite-chest', 'teeworlds', 'dopewars', 'bsdgames',
'ii-esu', 'xbill', 'oss-compat', 'minetest-mod-basic-materials',
'game-data-packager', 'fheroes2', 'zaz', 'openyahtzee', 'cytadela',
'projectl', 'mini18n', 'val-and-rick', 'scorched3d', 'nikwi',
'openal-soft', 'tworld', 'flight-of-the-amazon-queen',
'gargoyle-free', 'jester', 'asciijump', 'crispy-doom', 'pygame-sdl2',
'heroes', 'asylum', 'extremetuxracer', '3dchess', 'funnyboat',
'libchdr', 'pangzero', 'mupen64plus-core', 'blobby', 'ri-li',
'gltron', 'colobot', 'ufoai-music', 'allegro5', 'lincity-ng',
'libretro-beetle-psx', 'supertuxkart', 'pcsx2', 'tenmado', 'bulletml',
'minetest-mod-xdecor', 'curseofwar', 'pekka-kana-2',
'simutrans-pak64', 'biniax2', 'libretro-gambatte', 'cegui-mk2',
'vkbasalt', 'libretro-desmume', 'frotz', 'trigger-rally',
'minetest-mod-ethereal', 'matanza', '0ad-data', 'sauerbraten',
'xgalaga++', 'ace-of-penguins', 'fteqcc', 'wing', 'grhino',
'reminiscence', 'heroes-data', 'unknown-horizons',
'minetest-mod-craftguide', 'hawknl', 'libclaw', 'edgar',
'steam-installer', 'hex-a-hop', 'ltris', 'python-sfml', 'xboxdrv',
'allegro4.4', 'nestopia', 'enemylines3', 'libsoil', 'nexuiz-data',
'torus-trooper', 'mednafen', 'minetestmapper', 'ares', 'blupimania',
'minetest-mod-homedecor', 'debian-games', 'pyracerz',
'adonthell-data', 'gamazons', 'xaos', 'freegish', 'libretro-nestopia',
'libretro-beetle-vb', 'berusky2', 'pokemmo-installer', 'abe',
'gnujump', 'einstein', 'pacman4console', 'alien-arena-data',
'oneisenough', 'minetest-mod-intllib', 'btanks', 'torcs', 'fenix',
'vodovod', 'pentobi', 'alure', 'micropolis-activity', 'freesweep',
'openarena-oacmp1', 'xbomb', 'openarena-players', 'plee-the-bear',
'gravitywars', 'fretsonfire-songs-sectoid', 'xzip', '2048', 'kxl',
'astromenace', 'ddnet', 'blockattack',
'minetest-mod-unified-inventory', 'dolphin-emu', 'dhewm3',
'pink-pony', 'amphetamine', 'wolf4sdl', 'sdl-ball', '0ad', 'unshield',
'noiz2sa', 'planetblupi', 'rbdoom3bfg', 'chipmunk',
'visualboyadvance', 'icebreaker', 'yquake2', 'hexalate', 'tanglet',
'sdlbasic', 'mupen64plus-video-glide64mk2', 'hyperrogue',
'pipenightdreams', 'lugaru', 'drascula', 'ceferino', 'darkplaces',
'cutemaze', 'triplane', 'darkradiant', 'quarry', 'enigma',
'runescape', 'kraptor', 'liquidwar', 'openarena-misc', 'airstrike',
'renpy', 'pathological', 'morris', 'playonlinux', 'gnome-breakout',
'peg-e', 'lordsawar', 'libretro-beetle-pce-fast',
'excellent-bifurcation', 'freeorion', 'ufoai-maps', 'scummvm-tools',
'deutex', 'invaders', 'bzflag', 'wesnoth-1.14', 'armagetronad',
'pinball', 'cube2font', 'redeclipse', 'bloboats', 'mame', 'dangen',
'uqm-content', 'xjump', 'langdrill', 'minetest-mod-pycraft',
'xwelltris', 'gweled', 'ballerburg', 'xgalaga', '7kaa',
'openarena-maps', 'pax-britannica', 'chromium-bsu', 'supertransball2',
'alex4', 'gamine', 'libdumb', 'berusky-data', 'libsfml',
'mupen64plus-video-glide64', 'desmume', 'foobillardplus', 'crimson',
'a7xpg', 'tatan', 'flatzebra', 'cube2-data', 'xpat2', 'godot',
'brainparty', 'ufoai-data', 'trackballs', 'bouncy', 'qxw', 'pcsxr',
'pathogen', 'xscavenger', 'hedgewars', 'gravitation', 'pixfrogger',
'nexuiz', 'mupen64plus-ui-console', 'openarena-data', 'fillets-ng',
'xinv3d', 'minetest-mod-throwing-arrows', 'games-thumbnails',
'assaultcube-data', 'heroes-sound-tracks', 'boswars', 'quakespasm',
'powder', 'monster-masher', 'love', 'mancala', 'monsterz', 'galois',
'rrootage', 'out-of-order', 'simutrans-pak128.britain', 'xsok',
'xboard', 'greed', 'adonthell', 'xchain', 'assaultcube',
'openarena-textures', 'pixbros', 'sludge', 'minetest-mod-moreores',
'gfpoken', 'supertux', 'penguin-command', 'asc-music',
'open-invaders', 'ioquake3', 'openssn', 'atanks', 'primrose',
'netrek-client-cow', 'heroes-sound-effects',
'garden-of-coloured-lights', 'springlobby', 'raincat', 'irrlicht',
'performous', 'zatacka', 'woof-doom', 'xpenguins', 'auralquiz',
'fillets-ng-data', 'burgerspace', 'scottfree', 'mrboom', 'parsec47',
'pinball-table-gnu', 'bam', 'bullet', 'kcheckers', 'wesnoth-1.18',
'monopd', 'enemylines7', 'uqm', 'blastem', 'transcend',
'spacearyarya', 'mupen64plus-rsp-z64', 'lbreakout2', 'late', 'spring',
'qqwing', 'xmoto', 'steamcmd', 'qonk', 'gngb',
'lure-of-the-temptress', 'pushover', 'ballz', 'tetrinetx',
'lgeneral-data', 'dreamchess', 'yabause', 'fairymax', 'xye',
'recastnavigation', 'gigalomania', 'osmose-emulator',
'fretsonfire-songs-muldjord', 'angband-audio', 'steam', 'slashem',
'libcsfml', 'between', 'koules', 'fife', 'play.it-adventure',
'widelands', 'nethack', 'minetest-mod-nether', 'play.it',
'openarena-players-mature', 'etw', 'cookietool', 'asc',
'minetest-mod-mobs-redo', 'minetest-mod-mesecons',
'mupen64plus-input-sdl', 'minetest-mod-throwing', 'kobodeluxe',
'jumpnbump', 'moon-lander', 'warmux', 'kball', 'tint', 'trophy',
'geki3', 'scummvm', 'powermanga', 'performous-composer', 'mame-extra',
'nbsdgames', 'minetest-mod-quartz', 'pianobooster', 'pysiogame',
'dsda-doom', 'tecnoballz', 'play.it-vv221', 'alienblaster', 'teg',
'pysolfc-cardsets', 'phlipple', 'libretro-bsnes-mercury', 'bastet',
'glmark2', 'gtkatlantic', 'gmult', 'lmemory', 'freealut',
'astromenace-data', 'blocks-of-the-undead', 'mygui', 'barrage',
'stella', 'titanion', 'openpref', 'megaglest-data',
'amphetamine-data', 'mupen64plus', 'whichwayisup', 'krank', 'nsnake',
'briquolo', 'minetest-mod-unifieddyes', 'box2d', 'netpanzer',
'libretro-snes9x', 'jstest-gtk', 'surgescript', 'mrrescue',
'lgogdownloader', 'chocolate-doom', 'cultivation', 'rott',
'blockout2', 'angrydd', 'higan', 'pong2', 'antigrav', 'freecol',
'pnglite', 'fenix-plugins', 'opencity', 'opentyrian', 'pente',
'minetest-mod-3d-armor', 'zsnes', 'pegsolitaire', 'mousetrap',
'wesnoth-1.16', 'ogre-1.9', 'meritous', 'pinball-table-hurd',
'mednaffe', 'minetest-mod-protector', 'gnurobbo', 'freedroidrpg',
'retroarch-assets', 'funguloids', 'brutalchess', 'openarena',
'mupen64plus-video-arachnoid', 'freeciv', 'megaglest', 'kanatest',
'openarena-088-data', 'nettoe', 'wordwarvi', 'freedoom',
'caveexpress', 'ufoai', 'minetest', 'iortcw', 'quesoglc',
'tumiki-fighters', 'marsshooter', 'gtetrinet',
'libretro-beetle-wswan', 'gunroar', 'goverlay', 'pacman.c',
'kodi-game-libretro', 'eureka', 'enet', 'stormbaancoureur',
'redeclipse-data', 'alien-arena', 'lbreakouthd', 'residualvm',
'mupen64plus-rsp-hle', 'tuxfootball', 'holotz-castle',
'play.it-community', 'jag', 'dd2', 'ezquake', 'openjazz', 'retroarch',
'openarena-085-data', 'xletters', 'doomsday', 'overgod', 'pysolfc',
'open-adventure', 'vcmi', 'minetest-mod-moreblocks',
'beneath-a-steel-sky', 'clanlib', 'jumpnbump-levels', 'glfw3',
'berusky2-data', 'atomix', 'seahorse-adventures', 'openjk',
'prboom-plus', 'ode', 'pvpgn', 'ketm', 'passage', 'pmars',
'mupen64plus-video-z64', 'pingus', 'tuxpuck',
'minetest-mod-pipeworks', 'crack-attack', '1oom', 'filler', 'berusky',
'minetest-mod-skyblock', 'mgba', 'geki2', 'xteddy', 'mu-cade',
'lierolibre', 'rocksndiamonds', 'mupen64plus-qt',
'mupen64plus-audio-sdl', 'ogre-1.12', 'rcheevos', 'neverball',
'doom-wad-shareware', 'ardentryst', 'ghextris',
'mupen64plus-video-rice', 'empire', 'openmw', 'fifechan', 'angband'))
order by last_modified desc
