wiki:TracQuery

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.

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.

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:

No results

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:

No results

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:

0

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 132)

Ticket Resolution Summary Owner Reporter
#339 invalid Spread betting companies to be on the lookout for xi joellen.harder@…
#338 invalid Is Goraka the right fat loss burner for me? xi corneliusbecher@…
#337 invalid Estate planning lawyers in San Diego xi abdulmoye@…

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 132)

Ticket Resolution Summary Owner Reporter
#339 invalid Spread betting companies to be on the lookout for xi joellen.harder@…

Reported by joellen.harder@…, 10 days ago.

Description

To set it quite basically spread betting is gambling, you never really exchange plenty with anybody you just bet on a post from the agent (which isn't too different to some regular forex agents lol). Where as with regular forex trading some body has provide a counter transaction to yours for an actual trade to occur.

Pros as well as Cons, fine. Spreadbetting Pros: No slippage or  requotes as you don't have to truly have the offer met by still another party (great for scalping). Tax Free, since it's "gambling". Lower and/or fixed spreads (again as there's no  genuine trading taking place)

Spreadbetting Cons: Fairly open to broker exploitation (stop hunting, and so forth) as they're in control of the prices you bet against. If you liked this write-up and you would like to receive more facts pertaining to  financial spread betting kindly go to our web site. Very high leveraging, most places give you a really high influence which is not nearly as good as it seems.

Routine Forex Pros: Lower influence available, 10:1 or 50:1 is a great spot to begin. More reputable agents.

Routine Forex Disadvantages: Capital Gains taxAgain nonetheless open to cost exploitation, although it is less likley to happen on an individual degree having a respectable agent. Most brokers offer varying spreads, but this is not really a large minus, it depends on your trading style. Slippage and requotes, again-this may be a problem if you are scalping.

Basically this is precisely what I feel of spread-betting. Businesses offer very high influence underneath the attractiveness you could make batch of cash extremely readily (commerce with large boys sized spots with only GBP100, wuhpee right?). This however is a double-edged sword as huge wins additionally mean big losses. Spreadbetting businesses wish to margin contact you so they can wipe your position out within an instant, so actually to spreadbet successfully you need plenty of money to accomodate the substantial leverage and margins.

Scalping is a very good way for a newcomer to loose cash as they bet on a tiny time scale but whenever they take a loss they're likley to hold want to carry it until they make it happen cash back, in actuality though your magin is called and they've your money. Fundamentally spreadbetting firms work by  trusting there are enough poor fishes pulled by high leverage and risky scalping strategies to insure the losses they make to the decent dealers, whilst netting themselves a profitable profit.

#338 invalid Is Goraka the right fat loss burner for me? xi corneliusbecher@…

Reported by corneliusbecher@…, 10 days ago.

Description

Research worker have been  triggered by the expanding interest in Malabar Tamarind to investigate farther, to ensure consumer safety, and to challenge the benefits and drawbacks.

RPYA.org Research Worker Lisa King reviews:

This report is designed to explain the benefits of the nutritional supplement and to educate consumers about the kinds of nutritional supplement that are responsible for claims regarding malabar tamarind side effects.

"Click here to discover our researcher's most extremely recommended nutritional supplement."

Potential Dilemmas:

"There have been no studies demonstrating negative Garcinia Cambogia unwanted side effects,but the method it's mixed and fabricated can cause side effects," mentioned researcher Lisa King. "Here's how you can locate secure, powerful nutritional supplement."

Be discerning. Not all supplements-are created equal. "Some have far better formulations than others." Examine the price tag.  Garcinia Cambogia is an all-natural fruit. It makes sense the infusion from this shouldn't be too pricey. "If a single bottle costs over $60, you will be sure the producer has added some unneeded filler." Assess the purity. Supplements with additives, "like caffein and man-made binders, have become the cause of Garcinia Cambogia aspect effect issues." 60% HCA. It's improbable to work, if Your nutritional supplement has less than 60% HCA. "If the corporation does not even list the HCA percent inside their Goraka Extract, don't trouble."

Research and Information:

There has been a lot of investigation into Garcinia Cambogia extract in the past couple of years.

Here are the most important things consumers need to know, when it comes to efficacy and security.

"HCA, the weight loss compound seen in natural tropical fruits, is the key." Binders and artificial fillers are to blame for the promises of gamboge tree side effects. "As long as your nutritional supplement doesn't ruin the HCA with unneeded and dangerous additives, you're in the obvious."

Go here to see King's most advised pure Garcinia Cambogia supplement.

How Hydroxycitric Acid Functions:

Hydroxycitric Acid (HCA) is the energetic component in pure Garcinia Cambogia extract. Many research worker like Lisa King report that it could suppress desire "while blocking fat storage due to excess calories." Here's exactly what the study says:

Another landmark study at Georgetown College attested a 5.4% bodyweight reduction in only 8 weeks. This means an expected 15 pounds in just 2 months to get a 300-pound person.

Advice on Garcinia Cambogia Supplements:

"Itisn't my top priority to help individuals lose weight, but to assist them do it securely," states researcher Lisa King. "Here's how consumers can find a very good and safest Garcinia-Cambogia nutritional supplement."

Gamboge tree side effects have been reported with nutritional supplement not made in the USA, where  artificial fillers and binders are added. "Be sure to get your supplement from a certified lab in the united states." "These organic components are perfectly safe and healthy." As you already know, "60% HCA focus is recommended."

Lisa King is a customer research expert. "There are plenty of safe, effective HCA nutritional supplement out there. Finding one with 60% HCA with no food additives is vital."

#337 invalid Estate planning lawyers in San Diego xi abdulmoye@…

Reported by abdulmoye@…, 10 days ago.

Description

Looking for an attorney who will help you put together a great estate plan can seem like a daunting job. But with only a little help, you need to be able to locate several qualified lawyers to pick from. Here's a set of seven sources for finding an estate planning lawyer in your state.

Request fam, friends and business associates for a referral The biggest compliment that an estate planning lawyer can receive is a referral from a happy client. Talk with your family members, friends as well as acquaintances, or individuals you meet through your company, and inquire if they can recommend an estate planning lawyer. Even if the lawyer is not located in your immediate region, it's possible with modern technology for you to work long-distance and still get the same consequences as the individual who sent you.

Ask your financial advisor for a referral Your financial advisor should be a wonderful source of advice for you, including locating a qualified  estate planning attorney in your region. Many advisors view estate planning as an essential portion of their customers' overall financial goals, and so these advisors have one or more  estate lawyers that they will refer their customers to depending on each client's individual needs. , be sure to bring it up with your you if your advisor has not approached the matter of estate planning with consultant Additionally, go ahead and request your  adviser who did his or her own personal estate plan - the reply may be only who you are looking for.

Request your comptroller for a referral Many estate lawyers turn to cpas for help with income, trust and estate tax issues. Thus, opportunities are your financial controller can recommend one or more estate planning lawyers in your place to put together your estate strategy. Furthermore, many cpas seek out estate planning lawyers for their clients since comptrollers have direct access to their clients' financial tips and family situations which justify the need for an estate strategy. And go ahead and request your financial controller who did his or her own personal estate strategy - the answer may be only who you're looking for.

If you have any queries relating to exactly where and how to use  Unknown, you can get hold of us at our own web site. Request other attorneys you have worked with on other legal issues for a referral Chances are a lawyer you have worked with in setting up your company, buying your dwelling, or reviewing a contract will know one or more capable estate planning attorneys in your place. And attorneys are always quite satisfied to refer their customers to other lawyers who don't practice in their area of expertise because this will encourage referrals back the other method.

Contact your state or local bar association for a referralEach state has a bar association and lawyers located in a certain city or county may also have their own bar associations. Many of these associations maintain a list of their members and their practice areas, and some even offer certified referral services to the people. Check your local telephone directory or online for a referral service in your region.

Check ads in your local telephone directory or newspaper, or on the web, radio or video for a referral All states control attorney promotion, so only advertisements that pass the stringent inspection of the state bar association are permitted. This assures that the attorney is not making untrue claims or promising unattainable results.

Contact your local probate court for a referralThis may not work for you - particularly if you live in a big city - but in smaller communities which ones are simple to work with and the court clerks understand all of the local lawyers and which ones the judges enjoy. Since I practice in a small town and have a good working relationship with the court clerks and judges, I've received several referrals this way and contemplate it one of the greatest compliments.

This list is really just a starting point and doesn't even attempt to address the vast quantity of information you can locate about professionals, including estate lawyers, on the net. Occasionally, yet, TMI is only that, and so you need to stick with some basic methods. These seven should help.

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