Search/Filter Basics

[Darren Cope]

Hi all,

I'm struggling to make sense of the search and filter functionality (running the Nov 4 build of v3 on Windows XP). It's doing something but not always what I expect.  Can someone explain firstly the difference between Search and Filter, and when to use each? Also, in terms of syntax and field names; is there a list somewhere? An example question I have is "What is my average cadence for the entire season?" - I expect I would be able to go to "Home," select my Season from the "Date Range" list, and do a search "Where Cadence > 0" (to filter out rides on bikes with no cadence recording,) and then just look at the "Average Cadence" metric on the Home screen which I suspect would then show my answer. However, for the life of me, I can't figure out how to make this work. The next question would be, what is my average cadence before and then after X date, where I put on a compact crankset.

I'd be willing to write up a section for the user manual if someone could get me pointed in the right direction with some syntax examples, and list of field names!

Thanks!

[Mark Liversedge]

Search is free text search.

Filter is a query filter.

You toggle between the two by clicking the icon on the left of the search bar.

When you have applied a search or filter it will restrict the activities that are displayed or used in all the charts.

This is shown by changing the colour of the chart title to indicate it is showing filtered data.

There is also a flter box for home view charts to set specific filters for those charts only.

The filter queries need documenting, but use pretty simple syntax;

"Duration < 3600" - show activities under an hour

"Data contains "P"" - show activities containing Power

You can drag and drop fields from the field chooser so you don't have to remember the field names.

There are two functions too;

best(series, duration) - returns the best value for a series for the given duration in seconds

e.g. "best(NP, 3600) > 270" - show activities here my 1hr NP is over 270 watts

tiz(series, zone) - returns how many seconds you spent in a particular zone

e.g. "tiz(power,4) > 3600" - show activities where I spent more than an hour at L4 

I keep meaning to document it .. 

Mark

[Darren Cope]

Thanks Mark,

The "Column Chooser" answered a lot of my questions re: field naming - I didn't know that existed. Is it a bug that the little dropdown menu showing the option for "Add to Favorites" and "Column Chooser" is hidden until there is some text in the search/find box? (I'm on Windows XP, running the Nov 4 build.) It would be a lot easier to discover if it was there all the time :) I've been messing with Search/Filter quite a bit lately, and that is new to me!

I'll play with it a bit more and see if I can get comfortable enough to write up some documentation!

Darren Cope
http://darrencope.com
http://dmcope.freeshell.org

On Sat, Nov 16, 2013 at 1:44 PM, Mark Liversedge <liver...@gmail.com> wrote:

On 16/11/13 18:42, Darren Cope wrote:

Thanks Mark,

From your example, I see that "Power" is "P" in the filter. I then guessed that Cadence is "C" and it seems to be provide appropriate results. However, this is a bit 'non-standard' and it would be nice to definitely document this somewhere, but also perhaps provide a list of all fields here in the meantime, if you have such a thing handy. I had tried everything, including "Cadence," "Cadence (rpm)." "Cadence_(rpm)" and any other combination I could think of, but would never have considered "C." On a similar note, perhaps a list of operators (I didn't try "Contains" either, thinking ">0" or "NOT null" would work) would be very useful for those not familiar with this particular syntax.

        if (result->areDataPresent()->secs) flags += 'T'; // time
        if (result->areDataPresent()->km) flags += 'D'; // distance
        if (result->areDataPresent()->kph) flags += 'S'; // speed
        if (result->areDataPresent()->watts) flags += 'P'; // Power
        if (result->areDataPresent()->hr) flags += 'H'; // Heartrate
        if (result->areDataPresent()->cad) flags += 'C'; // cadence
        if (result->areDataPresent()->nm) flags += 'N'; // Torque
        if (result->areDataPresent()->alt) flags += 'A'; // Altitude
        if (result->areDataPresent()->lat ||
            result->areDataPresent()->lon ) flags += 'G'; // GPS
        if (result->areDataPresent()->headwind) flags += 'W'; // Windspeed
        if (result->areDataPresent()->temp) flags += 'E'; // Temperature
        if (result->areDataPresent()->lrbalance) flags += 'B'

Thats from the code :)

Mark

[Darren Cope]

Thanks again! I think I am getting the hang of the search/filtering.

I've posted a quick video on YouTube with some basics: https://www.youtube.com/watch?v=z15YiVaRQVI . I'll try to write something up for the user manual soon. Mark, what's the best way to get you the writeup?

On Monday, 25 November 2013 20:30:16 UTC-5, Darren Cope wrote:

Thanks Mark,

The "Column Chooser" answered a lot of my questions re: field naming - I didn't know that existed. Is it a bug that the little dropdown menu showing the option for "Add to Favorites" and "Column Chooser" is hidden until there is some text in the search/find box? (I'm on Windows XP, running the Nov 4 build.) It would be a lot easier to discover if it was there all the time :) I've been messing with Search/Filter quite a bit lately, and that is new to me!

I'll play with it a bit more and see if I can get comfortable enough to write up some documentation!

Darren Cope
http://darrencope.com
http://dmcope.freeshell.org

[Mark Liversedge]

Good job.

Just write something in word or notepad and we can sort the rest :)

Mark

[Darren Cope]

Hi Mark and GC Team,

Here's what I've put together so far (for search only, filter writeup to come). Open to suggestions/comments, etc.

Cheers!

Introduction:
Golden Cheetah has a multi-function Search and Filter box in the top right-hand corner. By default, Golden Cheetah starts with the Search function enabled. This is indicated by the word Search... in the query box, and the presence of a magnifying glass icon. To switch to Filter mode, simply click the icon, and it will change to a funnel icon, and the query box will change to read Filter.... Naturally, clicking the Filter Icon will then toggle you back to Search mode.

Search:

The Search tool allows you to do a 'free text' search. It will search for the term(s) that you enter in any text (but not number or date) field. Use Search to find a word or words that you have entered somewhere in an activity.

Examples:
 - To search for the word mountain anywhere, enter mountain

 - To search for the exact phrase "massive hill", enter "massive hill" (notice the surrounding double quotes)

 - To search for either the word massive OR the word hill, enter massive hill (notice the lack of quotes), or, alternatively, enter massive OR hill

 - To search for both of the words massive AND hill, but not necessarily as a phrase (e.g. the phrase massive hill climb would be a valid result), enter massive AND climb

 - To find the words cyclocross and cyclocosym (or anything else starting with cyclo,) use an asterisk as a wildcard by entering cyclo*

 - A single letter wildcard is also possible, using a question mark. For example, to search for Brazil or Brasil, enter Bra?il

Notes:
 - Searches are not case sensitive.

 - To escape special characters, use a \

Darren Cope
http://darrencope.com
http://dmcope.freeshell.org

--
--
_______________________________________________
Golden-Cheetah-Users mailing list
golden-che...@googlegroups.com
http://groups.google.com/group/golden-cheetah-users?hl=en
---
You received this message because you are subscribed to a topic in the Google Groups "golden-cheetah-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/golden-cheetah-users/vza5Y2L0Jqs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to golden-cheetah-u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Darren Cope]

I'm going to drag this thread up from the dead again...

I feel I have a pretty good handle on the "Search" portion of Search/Filter, and have sent you some documentation (did anything ever happen to that?) but I'm still scratching my head on Filter.  Today I was trying to do something simple: Find all activities where a custom column named Physical - End (or Physical_-_End when dragged in from column chooser) was equal to 5.  I would assume the syntax Physical_-_End = 5 would work, but it gives a "syntax error and malformed expression." error. A column without a dash (thinking that's the problem?) seems to work fine (e.g. Perceived_Exertion = 6).  However, if 'special characters' are not usable here (I tried escaping with a \ to no avail) then perhaps they should not be allowed when creating new fields?  Or am I missing something else obvious?

Darren Cope
http://darrencope.com
http://dmcope.freeshell.org

On Wed, Nov 27, 2013 at 10:48 AM, Mark Liversedge <liver...@gmail.com> wrote:

[Mark Liversedge]

What type of field did you add?

For example, I have a custom metadata shorttext field called Route and can run a filter 'Route contains "Loop"' to find all my loop rides or 'Route contains "Billingshurst Loop"' for my go to tempo ride.

I also have numeric fields for Perceived Exertion and Fatigue, with those i can filer 'Perceived_Exertion > 5' for hard rides.

May sure you are not trying to perform a numeric comparison on a text field.

Mark

To unsubscribe from this group and all its topics, send an email to golden-cheetah-users+unsub...@googlegroups.com.

[Darren Cope]

Thanks Mark,

It's a 'Double' field, same as the Perceived Exertion field which works fine with the same syntax, hence my confusion/suspicion that it may be the 'special character' of a dash.

Darren Cope
http://darrencope.com
http://dmcope.freeshell.org

To unsubscribe from this group and all its topics, send an email to golden-cheetah-u...@googlegroups.com.

[Mark Liversedge]

I just checked, coz I didn't think '-' was a special character (we don't yet support formulae) but of course it is used on negative numbers!

I'll fix the code to convert '-' to '_' when used in filters et al.

Mark

To unsubscribe from this group and all its topics, send an email to golden-cheetah-users+unsubscrib...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

[Darren Cope]

While you're poking at the code, I suspect there's a similar issue with the "TM" symbol beside BikeScore and perhaps check the ' beside W'?

Cheers, and thanks chief bug squasher!

Darren Cope
http://darrencope.com
http://dmcope.freeshell.org

To unsubscribe from this group and all its topics, send an email to golden-cheetah-u...@googlegroups.com.

[Jean Div]

Hey Darren and Mark

I've been Googling and trying unsuccessfully for a little while now.. if I want to look for Mountain Bike Races, I try to apply the following filter: Workout_Code="Race" AND Sport="Mountain Bike", but I'm having no luck.

Do you see a way for me to get this right?

Thanks,

Jean

To unsubscribe from this group and all its topics, send an email to golden-cheetah-users+unsub...@googlegroups.com.

[Mark Liversedge]

On Monday, 22 June 2015 19:38:51 UTC+1, Jean Div wrote:

Hey Darren and Mark

I've been Googling and trying unsuccessfully for a little while now.. if I want to look for Mountain Bike Races, I try to apply the following filter: Workout_Code="Race" AND Sport="Mountain Bike", but I'm having no luck.

Do you see a way for me to get this right?

Oh snap. I keep meaning to fix that its a parser error.

There is a workaround:

( Workout_Code = "Race ) and ( Sport = "Mountain Bike" )

Should do the trick.

Mark 

[Jean Div]

Perfect.. it works. Thanks Mark!