search Questions - FogBugz Knowledge Exchange

Why can't I refine a search the way I can a filter?

2011-09-04T18:00:22Z

When I use filter to select some cases in my FogBugz (for example cases that active and assigned to me) I get ordered list of all cases that matches the filter. I also can easily change the filter (e.g. instead of all cases assigned to me, select all cases assigned to John Smith)

But if I want do the same via search, I can't refine the results (even if my selection was a filter - see example)

status:"active" assignedto:"Slava [    ]" type:"cases" orderby:"Priority"

Result:

As you can see in the second example I can't refine the filter, but I expect that the result should be the same. (because I use the meta-language as status, assignedto, etc...) Why I can translate the search string to filter representation?

Thanks, Slava

Feature Request: Advanced search form

2011-09-30T15:41:39Z

Possible Duplicate:
Feature Request: Fast, comprehensive, powerful search

FogBugz search is quite powerful, but it has a bajillion axes I have to memorize. Auto-complete would be helpful, but I still need to know the axis names. An advanced search form that let the user fill in all of the available axis values would be a simple way to get more people embracing the awesome power of search.

Why is a search 3x faster than an saved search which is 2x faster than an equivalent filter?

2011-12-05T19:40:25Z

I was setting up a new filter for handling certain cases and I eventually discovered that just using search parameters was about 4x faster than doing the equivalent filter with one search field.

Namely, a saved filter searching for "project:Beta openedby:beta title:SpecialUpload" runs much faster than a filter on project Beta opened by Beta, searching the title for "SpecialUpload."

Edit for more information:

It's actually even more wierd than that. A non-saved search is about 3x than the same search saved as a filter, and a filter exactly equivalent to the saved search is about 2x slower than the saved search.

Here's a little background information: we have a special FogBugz virtual user that gets assigned emails for our beta@ account. We added a large-file-uploader to our web-page that sends notifications to the same account. I wanted to create a filter for those uploads. Here are some sizes for search results: project:beta returns 165, project:Beta openedby:beta returns 101, project:Beta openedby:beta title:SpecialUpload returns 6.

If I do a (non-saved) search for: project:"Beta" openedby:"beta" title:"SendThisFile", a ctrl-F5 finishes consistently in 2-3 seconds. I've saved that exact search as a filter, and a ctrl-F5 on that consistently finishes in 8-10 seconds. If I build a filter for project:beta, openedByUser:beta (selecting the exact match for both), with a search for title:"SendThisFile", a ctrl-F5 finishes consistently in 22-24 seconds.

Update (FIXED):

I have verified that after upgrading from 8.6.5 to 8.7.58, the raw search is much faster than 2-3 seconds, and the saved search seems to run at the same speed as the raw search.

FogBugz search in Google Chrome?

2012-01-21T06:29:16Z

Hello.

We are using FogBugz OnDemand. Some years ago it had a great add-on: we could search in our FogBugz from the Google Chrome's address bar. But now there is no such feature in FogBugz. I have been waiting for a quite long time hoping that Fogcreek will fix it/implement it again. But there is still no FogBugz search in Chrome.

Why did you remove it? Are you going to switch it back again?

Thank you.

Search for cases not containing a tag

2012-01-09T16:52:16Z

Is it possible to perform a search for cases that do not contain a specific tag?

For example, I have tag "postponed" and would like to find all cases in my current filter that do not have this tag.

Thanks

Feature Request: Community User Case Search

2011-02-07T11:05:57Z

When logged in as a community user the search only seems to include the Wiki and Discussions; the user's cases are not searched. Is there any way to include cases in the standard community user search?

Case FC2012672

Why do spaces matter in a comma-delimited list of IDs?

2011-12-23T18:57:57Z

Using the fogbugz search control, if I type:

1,2,3,4

And search, I'll get those 4 reports.

If spaces appear like this:

1, 2, 3, 4

I'll get a failed search.

As you can understand, this makes no sense and causes consternation on our team.

Please fix this.

Show cases subscribed by another user?

2011-12-19T21:48:54Z

We have a user leaving in a few days. I'd like to scoop up all the cases he's subscribed to. How do I do that? I saw "show:subscribed" as a search term but that seems to only show cases I'm subscribed to.

Thanks,

Search By Case Number's Greater Than X

2011-12-14T15:17:31Z

Is it possible to limit a list by Case Numbers that are greater than [x]? If so, how?

Is there a way to search for All active status values without having to key in each value

2010-09-24T14:16:13Z

I am using on demand at 8.0. I am able to construct a filter referencing the 'All Active' status settings. In my case I am constructing a search across a subset of all the projects I have. I want to build a search such as project:=1 or project:=2 or project:=3 status:All Active but that does not seem to work.

I have identified all the active status values using the API ... but would prefer to not have to key in all the entries (we have some workflow modifications).

Is there some shorthand way of identifying all active status values in the search?

Feature Request: index content of certain attachments (e.g. Word documents) in Wiki articles and cases

2011-02-22T23:50:34Z

We've been using FogBugz for tracking bugs and features for some time now, but are just getting started with wiki, and it's great!

One feature which would really help would be for searches (using the good ol' search box we use all the time) to also search within the content of attachments, particularly Word documents on Wiki articles.

The reason for this is that we want to start keeping our library of requirements documentation as wiki articles and they often get written as Word documents, plus we have a tonne of them already. Having them as searchable content without the need to copy & paste them into wiki articles would be really helpful.

Case FC2040151

Searching In Fogbugz: Syntax and the search axis

2010-09-07T18:10:00Z

Can you tell us all of the advanced features of FogBugz search and list every search axis and give examples of the search syntax?

How can I see what users are searching for?

2011-11-10T17:35:24Z

I would love to see what our users search for most often and how they phrase their searches. This would allow us to prioritize wiki-gardening efforts or fill in missing information which users want. Related: wiki-usage-view-statistics

Fogbugz Search: Using NOT (NOT AssignedTo:me)

2011-11-09T09:37:34Z

Hi,

Is it possible to use the NOT operator in FogBugz search?

I want to find all bugs, not assigned to a specific user ...

How do I dynamically filter cases by column value with API?

2011-11-07T19:52:54Z

Using the XML API, is it possible to retrieve a subset of all cases based on certain case properties?

For example, I would like to be able to retrieve only the cases assigned to one user that are in an active status. The user being queried can change based on a parameter from my application. I would like to be able to dynamically filter based on any column (e.g. Open Date, Project, Priority, etc).

It appears that there are 2 ways to do this.

Manually create a filter (through the Web UI) for each query combination, hard-coding the user information in the filter. Use the API to retrieve cases for the correct filter.
Create a filter that returns ALL CASES. Produce the correct subset of the cases using logic within my application.

Neither of these solutions are preferred, as #1 is too manual (and the API may cause unexpected Web UI behavior) and #2 is too slow (due to many cases being downloaded at once).

Are there any alternatives I have not inferred from the documenation?

Filter and search for cases assigned to any member of a group

2011-02-01T21:33:24Z

This is more specialized instance of the inability to filter on multiple values for an axis.

I would like to be able to filter and search for a group I have created in FogBugz 8 (see this post for the difference between groups in 7 and 8). In FogBugz 7, you could filter by group to find cases in projects which were set to a specified group. I would like to filter for cases assigned to users in a specified group.

Case FC2010689

Feature Request: Fast, comprehensive, powerful search

2011-02-08T20:49:56Z

FogBugz's search has been showing its age recently. When is it due for a real update?

Case FC2038219

How do I search for an exact match?

2009-12-17T23:00:22Z

Sometimes, putting the whole name into the search is not convenient because it's too long. Or sometimes, the whole name of one project is a substring of several others, (e.g., searching for area:"spam" returns cases in both the Spam and Not Spam area because they both contain the substring "Spam"). How do I search on an axis, e.g. Project: for an exact match? When I search for Project:"foo" I get results for a project called "foobar". Or less abstractly, Milestone:"Widget 1.0" returns cases with the milestone "Widget 1.0.5"

Case FC1228177

Make Deleted Projects Searchable for Normal Users

2011-10-03T20:09:22Z

In reference to question 6456, please make deleted projects searchable for normal users.

We have a legacy project structure that we have deleted, and we'd prefer to not make all of our Normal FogBugz user's administrators of the deleted projects.

Can I search and filter by Milestone completion date?

2010-10-05T21:03:52Z

This is related to this question. Is there a way to also search for a milestone completion date? (pseudo search : -milestone:undecided -milestoneCompletionDate:"now..12/21/2012")

This question is very handy, but I'm not sure I see what I'm looking for.

Case FC2037408

Feature Request - Search axis for group of users (i.e., assignedto:programmers)

2011-05-04T15:45:54Z

It'd be really nice if there was a way to define a group of users that can then be used in a search axis. For example, I would like to do:

assignedto:programmers status:active

Which would theoretically be equivalent to

(assignedto:programmer1 OR assignedto:programmer2 OR assignedto:programmer3) AND status:active

When we've somewhere defined "programmers" as consisting of "programmer1, programmer2, and programmer3".

I found this old post but don't see that it was implemented.

https://our.fogbugz.com/default.asp?fb7beta.12.81030.2

is it possible to use groups as a search? say I have a group 'programmers', can you search assignedto:programmers?

is this function there, or a plugin?
Collin Moore

Wednesday, July 15, 2009
Hi Collin,

Not yet, but that's a cool idea. We'll definitely consider it for a future release.
Daniel Wilson [Moderator] 

Thursday, July 16, 2009

In the interim I'm thinking of adding "(Programmer)" (or something shorter) to all the programmer's names (and same for Testers, Support, and HR), but it would expand all the names a bit.

Case FC2061983

Searching breaks Next case, is that by design?

2011-09-20T07:55:06Z

I read Rich's comment, that search shouldn't influence the current filter. The answer talked about the XML API, but I'm sure it should apply to interactive use as well.

Now I noticed that search does change the behavior of the current filter. Try this:

In tab 1, browse a filter showing plenty of cases
View one
In tab 2, search for something returning many cases
In tab 1, click the right arrow (Next case)

For me, that shows the result (cases list) of the search instead of the filter. List Cases does show the result of the filter. But I lost my 'current' position in the filter list.

Is this by design?

I'm having more and more trouble to intuitively follow 'the' global filter state...

(or is it a bug in our FogBugz version? we still use 8.4.92)

Boolean searches on custom fields

2011-07-21T09:05:28Z

I having trouble refining searches using the Boolean operators on custom fields. As an example, we have the a custom field with the title,"Area" setup on our project:

One
Two
Three
Four

Each case that we receive is automatically assigned the default value "One", however when necessary, this will be changed by the team to another value.

I would like to view the distribution of values across cases (and later display as a chart), but excluding all cases with the value "One" as it distorts the data.

For some reason I am not able to exclude the value using the following search string:

project:"MyProject" closed:"this week" -area:"one"

Can anyone help?

Can you exclude something from a search or filter?

2010-07-20T15:54:55Z

So right now it's inclusive, is there any way to exclude a field? Like for example, show we all open cases not on hold. Or show me all open cases not assigned to this user. I've done a search where I have to include every status but hold, its very tedious...

Thanks. Ross

Feature request: searching into attachment

2011-08-31T12:52:57Z

Possible Duplicate:
Feature Request: index content of certain attachments (e.g. Word documents) in Wiki articles

Hi, it should be possible to search text into attachment of type i.e. ".doc"?

Is there a parameter I can use in search that means "me" or "logged user"?

2011-08-11T10:47:34Z

I would like to use searches such as: "All cases that were opened by not me" And make them shared, so anyone can use them.

However, right now, I can only do it using:

-openedby:"Vitaly"

Which works only for me. Is there a placeholder that can do something like:

-openedby:"[Me]"

Thanks! Vitaly

Make the fulltext indexer use / (slash) as a delimiter for tokenizing

2010-10-26T20:55:57Z

I would like FogBugz to add text between slashes in a long string as tokens in the fulltext index. e.g. for a case with this event text:

the URL where I see the bug is

http://example.com/some/path/here

I would expect to be able to find the case if I search for "path"

Searching on case numbers with prefixes should find the case.

2011-07-22T15:10:17Z

I don't usually do this, but I ran across an unexpected behavior in FogBugz this morning.

When looking for a specific case, I typically just type the case number in the search box and it comes right up. Today, I copy/pasted it from an e-mail which happened to include the Case Number Prefix, for example "HD75117" where HD is the prefix for our Help Desk's FogBugz installation.

Expected Behavior: Return case 75117, but it came back with no results.
Actual Behavior: Returned no hits

If I change my syntax to be more specific like so..

case:"HD75117"

I get an error:

There was an error with your search string! Invalid case query 'HD75117'

Suggested Change: It would be nice if the search feature could recognize a case number formatted with the prefix and adjust my search accordingly to get the expected result.

"Pagination" of API search results when specifying max parameter

2011-07-21T19:01:07Z

Is it possible to retrieve a subset of the query? Similar to using the next and previous page links in the UI?

Feature Request: Searching for a number, if not a bug case, should search for number text

2011-07-11T23:00:44Z

I had a bug in my system about an HTTP 404 error. When trying to search for the bug I searched: '404' no quotes. It told me there was no bug in the system matching that search. I think it's great FogBugz will by default pull up a bug number matching the numeric search, but if it doesn't find one it would be nice if it fell back to a text search of the bugs.

There is a workaround where you can use double quotes, but novice users may not discover that!