Trac Ticket Queries

In addition to reports, Trac provides support for custom ticket queries, used to display lists of tickets meeting a specified set of criteria.

To configure and execute a custom query, switch to the View Tickets module from the navigation bar, and select the Custom Query link.

Filters

When you first go to the query page the default filter will display tickets relevant to you:

• If logged in then all open tickets it will display open tickets assigned to you.
• If not logged in but you have specified a name or email address in the preferences then it will display all open tickets where your email (or name if email not defined) is in the CC list.
• If not logged and no name/email defined in the preferences then all open issues are displayed.

Current filters can be removed by clicking the button to the left with the minus sign on the label. New filters are added from the pulldown lists at the bottom corners of the filters box ('And' conditions on the left, 'Or' conditions on the right). Filters with either a text box or a pulldown menu of options can be added multiple times to perform an or of the criteria.

You can use the fields just below the filters box to group the results based on a field, or display the full description for each ticket.

Once you've edited your filters click the Update button to refresh your results.

Navigating Tickets

Clicking on one of the query results will take you to that ticket. You can navigate through the results by clicking the Next Ticket or Previous Ticket links just below the main menu bar, or click the Back to Query link to return to the query page.

You can safely edit any of the tickets and continue to navigate through the results using the Next/Previous/Back to Query links after saving your results. When you return to the query any tickets which were edited will be displayed with italicized text. If one of the tickets was edited such that it no longer matches the query criteria the text will also be greyed. Lastly, if a new ticket matching the query criteria has been created, it will be shown in bold.

The query results can be refreshed and cleared of these status indicators by clicking the Update button again.

Saving Queries

Trac allows you to save the query as a named query accessible from the reports module. To save a query ensure that you have Updated the view and then click the Save query button displayed beneath the results. You can also save references to queries in Wiki content, as described below.

Note: one way to easily build queries like the ones below, you can build and test the queries in the Custom report module and when ready - click Save query. This will build the query string for you. All you need to do is remove the extra line breaks.

Using TracLinks

You may want to save some queries so that you can come back to them later. You can do this by making a link to the query from any Wiki page.

[query:status=new|assigned|reopened&version=1.0 Active tickets against 1.0]

Which is displayed as:

Active tickets against 1.0

This uses a very simple query language to specify the criteria (see Query Language).

Alternatively, you can copy the query string of a query and paste that into the Wiki link, including the leading ? character:

[query:?status=new&status=assigned&status=reopened&group=owner Assigned tickets by owner]

Which is displayed as:

Assigned tickets by owner

Using the [[TicketQuery]] Macro

The ​TicketQuery macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting.

Example:

[[TicketQuery(version=0.6|0.7&resolution=duplicate)]]

This is displayed as:

#11

Problems from Scafu

#12

Problems from Scafu pt 2

#13

Problems from Scafu pt 3

#15

Problems from Scafu pt 5

#18

Target can't be found

#23

clan titles

#35

Quests

#71

Skills

#89

Effect NullPointException

#109

Problems with Gameserver Starting

#113

NPE in RequestBuyItem.runImpl

#116

Cubics does not working on Shillien Knight (possibly others class)

#118

NPE in CharStat.getMaxHp

#123

Clan privileges

#158

Quest State (cond) refreshing

#159

Privileges for Pledge Classes

#163

Herbs

#193

Bug Report

#210

NPE in AllyInfo.writeImpl

#216

Quest progress doesn't update in client

#218

anonymous

#236

incorrect password, account is missing

#241

can't updating quest tab during quest

#264

npc

#265

NPE

#275

NPE

#283

NPE?

#328

Big Bug!!!

#341

The mobs go through the walls

#344

wyren?

#346

Error of CommunityBoard!!

#353

wyverns and pets

#393

NPE L2AuctioneerInstance

#414

callSkill

#415

L2Attackable doDie

#416

some problems with Silver Chamber CH

#421

Shadow Sense skill of the DE doesn't work

#425

Zariche skill bug

#429

L2AuctioneerInstance NPE

#430

get error while using wyvern manager

#438

I have add new castle info the mercticket, please see will it be help and I think the part I add will need to modify

#456

I found a bug about Raidboss

#502

NPE in serverpackets.UserInfo

#505

Zariche bug

#528

geodata bug

#534

NPE in L2AuctioneerInstance.onBypassFeedback

#541

NPE in L2AuctioneerInstance

#545

quest

#547

pets problem

#548

Problems for Cursed Weapon

#560

herbs issue

#561

Pet Desapearing Bug

#572

bugs

#652

No item handler registered

#697

Bad RequestBypassToServer: java.lang.NullPointerException at net.sf.l2j.gameserver.model.actor.instance.L2AuctioneerInstance.onBypassFeedback(L2AuctioneerInstance.java:295)

#719

Day/night spawn problem

#740

//showdroplist and //editnpc not working

#747

NPE in L2AuctioneerInstance.java

#782

Stats Window does not update correctly with some Passive Skills.

#791

Autochat is not working

#805

icon item in clan skill list

#811

problem with skills

#817

a Bug with the Final Frenzy passive skill (galdiator)

#835

Flags in siege?

#864

Buffer Underflow - Critical Issue DP 2952 GS 752

#899

Dueling code causes PvP Flaging due to incorrect check for status

#913

autoChat still

#914

NPE Macro GS 801 DP 3003

#916

Client Crash with some gm options

#921

Community Board Client Critical Error

#952

P DEF

#954

BUG CRITICAL !

#959

Unknown Packet: 48 on State: AUTHED

#974

mass skills animation

#992

NPE at net.sf.l2j.gameserver.templates.L2Weapon.getSkillEffects(L2Weapon.java:381)

#994

some packets

#1008

The sword which was cursed

#1028

Update client

#1031

Cursed Weapon Glow

#1056

CurseWeapon enchant Client effect

#1087

Problem with Zariche

#1088

Elixirs

#1094

update server protocolo revision 446

#1113

Canot add defensors in sieges

#1122

duel malfunction

#1133

When you add/change sub-class ,it will showed tow of main-class and cannot show the sub-class here.Sorry of my english

#1141

Auto SS

#1172

Physical Mirror and Magic Mirror need new handler

#1175

need a litle help here

#1176

Found a Royal Guard

#1193

Stuck after killing a monster

#1224

Character rotation movement are not working

#1240

DA's final fortress doesnt stops even if char is fully healed

#1272

Lethal strike issue

#1278

Fortress doors

#1290

server errors plz help me !!!

#1297

big problem with summon any button skill on them does not work

#1309

Unknown packets 1 and 48

#1311

CAN'T compile the code

#1314

bug with skill aegis stance

#1327

Please , look this ticket , we heave the same problem.

#1332

changeset 1084 - lags / DC

#1334

Bug with skill store on exit

#1336

Plz gve files

#1339

msdos

#1340

clan bug lider no change tittle, and is not change priviliges for clan

#1362

Can't Change weapon when you're attacking

#1369

bug //reload html

#1399

bug edit npc

#1400

Olympia Bug

#1411

Using items while casting

#1419

admin commands problem

#1421

Elixir RE-DELAY USE

#1433

IndexOutOfBoundsException on L2Party.java

#1445

IllegalArgumentException on CursedWeapon.java

#1452

Summoner Bug!

#1459

IndexOutOfBoundsException on L2Party.java

#1460

bug 8

#1478

Invisible GM's not always Invisible

#1493

problems with npc and mobs

#1498

Dark Elven and Elven Teritory soe

#1500

Error in compile...

#1508

Build error in L2CastleChamberlainInstance.java

#1513

banchat

#1541

Switch class bug

#1542

Castle Siege Registration Error

#1561

Chatbanned char can write private to others (at least GMs)

#1572

macro lenght issue

#1574

Sit and Stand

#1602

bug

#1608

Some geo problem in logs:

#1609

Skill Relax

#1614

bug

#1617

some errors

#1671

CLs' multi-sighning on siege...

#1686

NPE in L2ClanMember

#1713

players can't use manor

#1715

WARNING: could not store macro

#1722

Unknown Packet

#1723

NullPointerException

#1724

unknow packet

#1734

Summons

#1743

[1402] critical error

#1748

NPE manor

#1762

NPC 31356 class not found

#1785

seven sings festival and bsoe

#1819

loginserver shutdown itself issue

#1821

Help Unknown Packet

#1866

dublicate http://www.l2jserver.com/trac/ticket/1823

#1883

Hair dont get changed when equipping circlets/head accessories

#1920

"You Missed" message is not showed on the client.

#1924

cant born in Theme Park

#1925

Serious bug on Death: "To Village" dont working!

#1936

great lag at siege

#1963

NPE

#1971

Server Console Compleatelly flodded with errors in RequestSaveInventoryOrder

#1975

Fight in towns possible after login

#1976

Siege Headquarters not working

#1980

Mistake of pets

#1994

Salvation bow and other events bows don't need arrows

#1996

JDK 1.6.0 AMD64 JVM on a CORE2DUO: GM command //admin Throws GPF en L2Client

#2008

NPE bosszone

#2028

SOE critical bug

#2031

Data too long for column 'commands' at row 1

#2051

Critical Error - Duplicate

#2070

using skill and potion

#2074

Wolf tranformation to Black Wolg

#2076

Potion Effect Icon Dissappears

#2091

cannot see target

#2138

Duplicated Entry error

#2181

Attempting to add existing items to DB

#2186

academy members are visible on main clan list

#2207

Duplicate entry

#2230

Lots of errors

#2242

duplicate id - item lost

#2245

Summon hate

#2247

Mobs dont return back to their place

#2287

Dance of Shadow

#2290

Dance of Shadow, recast bug

#2294

Character cannot log in

#2323

Duplicate item ID's

#2324

Herbs problem

#2325

banchat bug

#2351

war tag doesn't show up all the time

#2354

potion usage

#2375

Olympiad Bug (new ticket)

#2386

Healing potions work is not correctly

#2389

Experience bar doesn't move any more but levelling up work

#2406

Transformation NPE

#2410

Chat Ban

#2411

Transformations bug

#2427

healing potion effect

#2428

BufferUnderflowException

#2430

Transformation exeptions

#2431

Transformation SQLException

#2432

Alternative Datatables not loading properly

#2442

what's this error??

#2448

transformation update info - sql exception / interrupted exeption

#2453

Transformations

#2455

Could not store char effect data ERROR

#2461

banchat problem.

#2483

Could not restore character data?

#2489

seven sign buff/debuff is dissapearing after reconnect

#2491

Duplicate entry error on store effect data

#2507

custom_etcitem

#2512

store effect error

#2528

Unsupported Custom Version.

#2530

java.lang.NullPointerException

#2534

NPE Could not restore clan privs by rank

#2571

Catacombs and Necropolises Entrance

#2592

NPE

#2595

Talisman Bodyslot Support

#2599

Could not store char effect data:Duplicate entry '268645126-4215-0' for key 1

#2603

unknown body slot:

#2610

Primeval island

#2620

Traps

#2640

NPC not loaded ...

#2696

NPE

#2716

Error IN CONSOLE

#2727

Use Potions

#2728

Lord's Crown

#2735

In the Olympics DA Panther cannot be attacked with standard attack (not tested against other summons)

#2775

NPE

#2780

Could not store char effect data

#2782

Missing Talisman Support.

#2784

Error could not store char skills

#2807

and another console-only error

#2809

incorrect working

#2834

Geodata!

#2839

Active effects data is not recovered when relogging between chars in same account

#2855

Changeset 2293 Cleanup.

#2888

Q items

#2892

way to drop cooldown for any skill.

#2899

quest items drop

#2905

evolved pets problems

#2908

Duplicate Entry - Character Quests

#2909

NPE mcshow.py

#2910

error

#2947

Bad RequestBypassToServer:the same mistake,than it for a previous man,and the datapakk up is! What may this be?

#2975

double entry Line 176 MySQLIntegrityConstraintViolationException

#2985

Mobs disappears when hit by a player and no respawn

#2996

Drop Item Protect.

#3005

error clan

#3015

RaidBoss error: 25373 - Malex Herald of Dagoniel

#3023

NPE

#3024

raid boss point

#3025

Lord's Crown

#3034

NPE

#3041

Good work's reward quest problem with mob spawn...

#3049

unknown body slot:4194304

#3053

Olympiad class based

#3057

could not insert char quest: Duplicate entry '268494310-RiftQuest-<state>-0' for key 1

#3073

NPE RaidBossPointsManager

#3095

NPE

#3110

DimensionalRift quest clean error

#3118

NPE

#3141

NPE .PledgeReceiveSubPledgeCreated.getLeaderName

#3176

Error!!!!

#3185

Subclass Level 80 100% no SP

#3186

NPE

#3201

Dagger Skill Sound

#3219

NPE

#3227

NPE (same as #3225 ?)

#3239

Console only NPE

#3260

Class Cast Exception

#3265

Vanguard/Inquisitor

#3275

NPE

#3276

NPE

#3279

Erorr log

#3342

Please fix that error: L2GuardInstance cannot be cast to L2PcInstance

#3345

Alliance of Splemdor Monster

#3347

Lord's Crown

#3350

Buff resist Bug

#3361

Drain skills

#3376

more dealocks ...

#3387

Error in console latest revision (2nd)

#3406

Augment is fake.

#3411

Could not insert item

#3416

2 errors by server start

#3422

Tank - no reuse shooting after getting vanguard

#3426

MySql error for Dimensionnal Rift

#3434

Clanhall bidding bugged

#3441

NPE

#3445

Mobs using self buff fall down layer

#3456

Mass mage bane - warrior

#3461

Quest Items and duplicate items...

#3479

error

#3485

server starting errors in todays nightly

#3503

skill reuse exploit

#3507

server crash and java error

#3523

Boat circles or stops at 1st waypoint

#3526

java error log...

#3528

Baium no attack

#3538

walker_routes- npc walker

#3541

tax problem re-post

#3556

Char shouldn't sit immediately after pressing "Sit" shortcut when running to point

#3561

Transformation: Death Blader

#3574

TradeController error on server shutdown

#3587

walk npc

#3592

[During the Fortress Siege at Dragonspine] Exception: java.lang.NullPointerException

#3593

[During Siege Fortress Dragonspine] Failed executing HitTask.

#3594

L2NpcWalker is not working.

#3595

Game sever error

#3601

[Narsell Fortress] neither able to put the flag nor own the fortress.

#3603

[During Siege Fortress Dragonspine] Still not able to dispaly the flag

#3608

Problem with handlers compilation

#3618

Overenchanting

#3620

Error console gameserver

#3623

Problem

#3627

multisell enchant bug

#3637

still having probs with java but diff...

#3638

still having probs with java but diff...

#3660

DEADLOCK ?

#3675

manor manager - cannot buy seeds

#3678

Sell for npc

#3700

walk npc bug again

#3719

java.lang.ClassCastException

#3741

S84 Weapons Soul and Spiritshot Effect

#3751

attribute system

#3766

Devs test pls Bottle of Souls

#3781

a few bugs

#3811

players falling through floor's

#3849

Fortress Siege Errors !

#3877

Provoke not working

#3896

Login Server Warning.

#3908

Grand olympiad\party bug

#3927

FastList Party

#3933

Warning in L2LoginServer.java

#3935

No exp /sp for one hit mobs

#3941

L2AttackableAIScript.java

#3965

Destroyers are bugged

#3969

Augumentation from mid grade ls with skill

#3980

I guess CRITICAL this on ANT QUEEN

#3983

Sub Class flood protection

#3986

gs error

#3994

Snoop Cancel does not work

#4008

Rsk. Haste SA

#4048

L2Character callskill

#4070

Cant sit while in Vanguard/Inquisitor stance

#4071

Quest sytsem crashes

#4075

FORT/CASTLE doors

#4091

Cant buy more then 1 stackable items of the same object from Private store buy

#4137

Community Forum Warning.

#4142

Fate's Whisper Quest

#4187

chance haste

#4206

A summon can't attack in a Duell.

#4213

Lure effects

#4234

A small error (I think)

#4239

fix broadcast packet

#4295

Sorting WH

#4329

AOE/Mass skills can kill not flagged

#4331

Mob Attack Mobs

#4358

Skill: Shield Deflect Magic

#4359

Bug with debuff

#4360

Gracia epilogue ??... Are we there yet!

#4361

skill enchancement

#4375

Shaman's buffs @ Newbie Guide

#4376

Shaman's buffs @ Newbie Guide

#4385

Magic Attacks to Castle Doors

#4387

Last Rev From SVN bug p.atk and m.atk

#4408

No Status for Weapon

#4411

Bug with ThreadPoolManager

#4422

Reflects reduce damage

#4428

spirit shot in retail

#4434

Check it please the soonest possible

#4456

quest Pursuit of Clan Ambition! (clan 5lv)

#4466

Skill + Teleport = Stuck at spawn

#4467

Skill + Teleport = Stuck at spawn

#4470

NPE after 3988

#4490

Raid Cancel

#4493

clan-name display

#4522

PvP/Pk Colos & Castre Lord announcement .

#4535

Agression and Debuffs problem

#4568

Problem Dc (Critical Error) When teleport -soe - To Village)

#4576

wear price

#4582

http://www.l2jserver.com/trac/ticket/4577

#4591

Unclosed connection! Trace: SevenSignsFestival.saveFestivalData

#4619

Sacrifice

#4622

Snow wolf\fenrir bug

#4637

Corpse Burst ID: 1155

#4655

NPE@L2AttackableAI.movementDisable() 1783

#4658

SQL Problem

#4673

NPE@L2AttackableAI.movementDisable() Line 1666

#4744

NPE@L2AttackableAI.skillTargetReconsider() Line 2023

#4761

NPE@L2AttackableAI.movementDisable() 1777

#4765

NPE@L2AttackableAI.skillTargetReconsider() Line 2023

#4778

Auto Soulshot behavior.

#4780

Please , arena manager

#4787

NPE

#4799

L2PlayerAI.onEvtReadyToAct() Line 108

#4803

ZoneManager.getOlympiadStadi

#4805

NPE@L2AttackableAI.movementDisable) 1777

#4814

IllegalArgumentException

#4837

Exception in thread "Thread-95" java.lang.NullPointerException

#4841

Summons/Guards HP

#4845

Possibly Bug In Spoil Skill

#4848

pet names not showing to other players

#4857

NPE@L2AttackableAI.skillTargetReconsider() Line 2023

#4913

Stuck Stats

#4925

at com.l2jserver.gameserver.model.actor.stat.PetStat.getExpForLevel(PetStat.java:92)

#4943

miss some code

#4972

com.l2jserver.gameserver.model.actor.instance.L2OlympiadManagerInstance cannot be cast to

#5229

Account Verification

#5246

PlayerTeleportProtection

#5254

sent bad RequestBypassToServer: "admin_mammon_respawn"

#5256

Several problems, bugs, posible bugs, etc. / Geodata

#5313

Final Frenzy and Final Fortress

#5337

Could not reset Recommendations System

#5344

GS Flood

#5347

download da revisao

#5355

critical error

#5356

critical error

#5357

critical error

#5366

summon's name (hardcoded)

#5380

Steal Divinity

#5415

Skill ID 1411

#5420

Critical Error in Rune, Heine or Giran Harbor

#5432

cant stop casting pet

#5435

please fixed crash

#5436

Wolf Can Use Player Sets!!!

#5450

Please look at that verry inportant.

#5463

Last REV. Please Fix the chat.

#5467

Buff does not end

#5468

look for this error

#5480

NPE@SummonEffectsTable.java:45

#5482

NPE@SummonEffectsTable.java:45

#5491

Beta: Sonic and Force Mastery

#5498

Chant of Elemetns wrong ?

#5503

XML Certification

#5505

Summon exploit.

#5509

Golem Punch / Dark detonation = endless stun

#5513

summon effect error

#5515

fix 4682

#5535

Quest for Strider

#5551

Servitor Share

#5561

possible error when trying to compile

#5583

RegisterDialog

#5605

Offline Traders Feature

#5631

Shield stun is missing attribute when enchanted reposted

#5642

error in gs

#5663

Can't attack fortress door by magic skills.

#5738

Bug Subclass Fortune Seeker Main Class

#5772

Mount doesn't work

#5774

Problem at EnterWorld.

#5791

Mounts Dismount related problems

#5798

Error in gameserver console Summon

#5803

Mount Dismount BUG

#5805

Pet skills not work

#5843

Major Heal

#5856

Mount/dismout problem

#5927

Can't mount Pet — DisarmWeapon fix

#5932

Servitor Share

#5988

Summon Str Modifier fix

Just like the query: wiki links, the parameter of this macro expects a query string formatted according to the rules of the simple ticket query language.

A more compact representation without the ticket summaries is also available:

[[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]

This is displayed as:

#11, #12, #13, #15, #18, #23, #35, #71, #89, #109, #113, #116, #118, #123, #158, #159, #163, #193, #210, #216, #218, #236, #241, #264, #265, #275, #283, #328, #341, #344, #346, #353, #393, #414, #415, #416, #421, #425, #429, #430, #438, #456, #502, #505, #528, #534, #541, #545, #547, #548, #560, #561, #572, #652, #697, #719, #740, #747, #782, #791, #805, #811, #817, #835, #864, #899, #913, #914, #916, #921, #952, #954, #959, #974, #992, #994, #1008, #1028, #1031, #1056, #1087, #1088, #1094, #1113, #1122, #1133, #1141, #1172, #1175, #1176, #1193, #1224, #1240, #1272, #1278, #1290, #1297, #1309, #1311, #1314, #1327, #1332, #1334, #1336, #1339, #1340, #1362, #1369, #1399, #1400, #1411, #1419, #1421, #1433, #1445, #1452, #1459, #1460, #1478, #1493, #1498, #1500, #1508, #1513, #1541, #1542, #1561, #1572, #1574, #1602, #1608, #1609, #1614, #1617, #1671, #1686, #1713, #1715, #1722, #1723, #1724, #1734, #1743, #1748, #1762, #1785, #1819, #1821, #1866, #1883, #1920, #1924, #1925, #1936, #1963, #1971, #1975, #1976, #1980, #1994, #1996, #2008, #2028, #2031, #2051, #2070, #2074, #2076, #2091, #2138, #2181, #2186, #2207, #2230, #2242, #2245, #2247, #2287, #2290, #2294, #2323, #2324, #2325, #2351, #2354, #2375, #2386, #2389, #2406, #2410, #2411, #2427, #2428, #2430, #2431, #2432, #2442, #2448, #2453, #2455, #2461, #2483, #2489, #2491, #2507, #2512, #2528, #2530, #2534, #2571, #2592, #2595, #2599, #2603, #2610, #2620, #2640, #2696, #2716, #2727, #2728, #2735, #2775, #2780, #2782, #2784, #2807, #2809, #2834, #2839, #2855, #2888, #2892, #2899, #2905, #2908, #2909, #2910, #2947, #2975, #2985, #2996, #3005, #3015, #3023, #3024, #3025, #3034, #3041, #3049, #3053, #3057, #3073, #3095, #3110, #3118, #3141, #3176, #3185, #3186, #3201, #3219, #3227, #3239, #3260, #3265, #3275, #3276, #3279, #3342, #3345, #3347, #3350, #3361, #3376, #3387, #3406, #3411, #3416, #3422, #3426, #3434, #3441, #3445, #3456, #3461, #3479, #3485, #3503, #3507, #3523, #3526, #3528, #3538, #3541, #3556, #3561, #3574, #3587, #3592, #3593, #3594, #3595, #3601, #3603, #3608, #3618, #3620, #3623, #3627, #3637, #3638, #3660, #3675, #3678, #3700, #3719, #3741, #3751, #3766, #3781, #3811, #3849, #3877, #3896, #3908, #3927, #3933, #3935, #3941, #3965, #3969, #3980, #3983, #3986, #3994, #4008, #4048, #4070, #4071, #4075, #4091, #4137, #4142, #4187, #4206, #4213, #4234, #4239, #4295, #4329, #4331, #4358, #4359, #4360, #4361, #4375, #4376, #4385, #4387, #4408, #4411, #4422, #4428, #4434, #4456, #4466, #4467, #4470, #4490, #4493, #4522, #4535, #4568, #4576, #4582, #4591, #4619, #4622, #4637, #4655, #4658, #4673, #4744, #4761, #4765, #4778, #4780, #4787, #4799, #4803, #4805, #4814, #4837, #4841, #4845, #4848, #4857, #4913, #4925, #4943, #4972, #5229, #5246, #5254, #5256, #5313, #5337, #5344, #5347, #5355, #5356, #5357, #5366, #5380, #5415, #5420, #5432, #5435, #5436, #5450, #5463, #5467, #5468, #5480, #5482, #5491, #5498, #5503, #5505, #5509, #5513, #5515, #5535, #5551, #5561, #5583, #5605, #5631, #5642, #5663, #5738, #5772, #5774, #5791, #5798, #5803, #5805, #5843, #5856, #5927, #5932, #5988

Finally, if you wish to receive only the number of defects that match the query, use the count parameter.

[[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]

This is displayed as:

453

Customizing the table format

You can also customize the columns displayed in the table format (format=table) by using col=<field> - you can specify multiple fields and what order they are displayed by placing pipes (|) between the columns like below:

[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter)]]

This is displayed as:

Results (1 - 3 of 5753)

1 2 3 4 5 6 7 8 9 10 11 →

Ticket	Resolution	Summary	Owner	Reporter
#6196	invalid	I cant see the name and title of the custom npcs.		NeoDark
#6195	invalid	spam	< default >	PEPExceenetuP
#6194	wontfix	you should		anonymous

1 2 3 4 5 6 7 8 9 10 11 →

Full rows

In table format you can also have full rows by using rows=<field> like below:

[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter,rows=description)]]

This is displayed as:

Results (1 - 3 of 5753)

1 2 3 4 5 6 7 8 9 10 11 →

Ticket	Resolution	Summary	Owner	Reporter
#6196	invalid	I cant see the name and title of the custom npcs.		NeoDark
Reported by NeoDark, 12 hours ago.
Description	I cant see the names and the titles in my high five server i dont know why that happen when i create custom npcs.
#6195	invalid	spam	< default >	PEPExceenetuP
Reported by PEPExceenetuP, 13 hours ago.
Description	Another important gain of online gold trading above forex buying and selling will be the tiny supervision required. Gold charges do not modify drastically as observed when buying and selling currencies. What this means is you don't require a lot of time for you to keep track of the method. Really you simply need to dedicate a number of minutes every day to verify the system. For foreign currency trading, you need to be updated each time as being the prices changes significantly. A number of folks trading currencies keep an eye on the technique every moment. This can be widespread with day investing routines. ​http://gett.tk/8 . Then when you've got located a fx brokerage, you need to make a decision which forex trading agent is true to suit your needs, variables to determine on are controlled forex trading brokers or unregulated foreign exchange brokers. Offering you've done your because of diligence then you can certainly.t go far incorrect with either. Several American/USA forex traders choose offshore since it is really a far better approach to control their trading earnings, although most European forex investors go for either FSA or CySec? regulated brokers. Do not trade defensively; defensive Fx trading will only bring about failure. Trading Forex defensively, links in with the psychology of Forex trading. In case you trade currencies defensively, you'll make bad and irrational selections. Take a step back, serene down and relax; you have to have the ability to generate rational choices, if you would like for being profitable. Absolutely everyone helps make losses in the industry for currencies - losses are inescapable and each experienced Fx trader and trader has seasoned a losing streak just before. Continue to persevere and make certain that you are environment reasonable goals. ​http://l.believe.vg/g . If you're searching to hitch the various Fx investors investing in overseas forex, you must get a unique technique than almost all of them. The critical factors to perform are to speculate oneself, lower your losses and commit to the extended haul. Use these 3 ideas and you will turn out to be a worthwhile trader shortly. I've a method that I exploit to trade everyday. No, it truly is not in my previous article, "Forex Investing Income - A Handbook Buying and selling Strategy That works," I'd never ever give away my trade secret, though that technique does give me handsome returns also. The approach I use depends upon 5 indicators that give me three sure-shot indicators on a daily basis. ​http://tiny1.ca/3d . Currency trading over the internet is selecting up quick speed in present-day entire world. The world-wide web has created a world village where individuals from all aspects of the globe can arrive jointly and fulfill in one spot. Investors can discuss new tips with one another. Potential customers and vendors can effortlessly get linked to the buying and selling indexes scattered all across the planet. This permits them to obtain first-hand expertise in the charges of commodities too since the values in the currencies which can be currently being traded. Special on the web forex community forums supply beneficial markers, this sort of as graphical plotting and charts, which can demonstrate for being quite valuable for foreign-currency investors. However, not all fx message boards current on the world-wide internet can offer their clients with sensible and reliable providers. The internet is flooded with on-line cons, which target consumers for his or her very own functions. These ripoffs are neither legal, nor are they genuine. Their only function would be to misguide the person into investing his hard-earned funds on the mistaken spot, which may show to become disastrous. The investors can drop their income inside a issue of seconds. Another requirements that need to be looked into includes the commission, minimum deposit and greatest leverage. There isn't any position in choosing a broker who demands a high commission in the event you are new on the market place and just commencing out. In this scenario, you need a agent who's more experienced and may train you the nuances of the game but requires only a tiny amount as deposit and commission. While you gain encounter, you'll be able to choose the bigger broking firms which may demand large commission expenses but are huge gamers in the foreign exchange market. ​http://tinyurl.com/d4xx6fx . Much like the ones mentioned above, there are lots of other overseas trade strategies that work. Another successful foreign exchange approach is swing trading, through which a trade is held for approximately a few days. In swing investing, the currency alternatives are offered or bought when they are in the stop or near the upward or the downward swing within the marketplace. Thus, to produce income from this or for that issue, some other foreign exchange method, a trader really should stick to an suitable entry and exit policy.
#6194	wontfix	you should		anonymous
Reported by anonymous, 5 days ago.
Description	you should replace in build.xml file: this: <delete dir="${build.bin}" quiet="true" /> with this: <delete dir="${build}" quiet="true" />

1 2 3 4 5 6 7 8 9 10 11 →

Query Language

query: TracLinks and the [[TicketQuery]] macro both use a mini “query language” for specifying query filters. Basically, the filters are separated by ampersands (&). Each filter then consists of the ticket field name, an operator, and one or more values. More than one value are separated by a pipe (|), meaning that the filter matches any of the values. To include a literal & or | in a value, escape the character with a backslash (\).

The available operators are:

=	the field content exactly matches one of the values
~=	the field content contains one or more of the values
^=	the field content starts with one of the values
$=	the field content ends with one of the values

All of these operators can also be negated:

!=	the field content matches none of the values
!~=	the field content does not contain any of the values
!^=	the field content does not start with any of the values
!$=	the field content does not end with any of the values

The date fields created and modified can be constrained by using the = operator and specifying a value containing two dates separated by two dots (..). Either end of the date range can be left empty, meaning that the corresponding end of the range is open. The date parser understands a few natural date specifications like "3 weeks ago", "last month" and "now", as well as Bugzilla-style date specifications like "1d", "2w", "3m" or "4y" for 1 day, 2 weeks, 3 months and 4 years, respectively. Spaces in date specifications can be left out to avoid having to quote the query string.

created=2007-01-01..2008-01-01	query tickets created in 2007
created=lastmonth..thismonth	query tickets created during the previous month
modified=1weekago..	query tickets that have been modified in the last week
modified=..30daysago	query tickets that have been inactive for the last 30 days

---

See also: TracTickets, TracReports, TracGuide