Searching - Revision history

Dave at 06:20, 24 February 2019

2019-02-24T06:20:54Z

← Older revision		Revision as of 06:20, 24 February 2019
Line 1:		Line 1:
	To search for a song in the current playlist, press ⌘-F (command-F mac, or control-F windows). To search for a song in the Library, press ⌘⇧-F. Searching will search every '''visible''' column, so to make search go faster, hide the columns you don't care about. You can search for multiple terms, and commas and spaces are ignored. For example [beat, love, me] (don't type the brackets) will find all beatles songs that have the words "love" and "me" (as well as any other song with ~~those~~ three terms).		To search for a song in the current playlist, press ⌘-F (command-F mac, or control-F windows). To search for a song in the Library, press ⌘⇧-F. Searching will search every '''visible''' column, so to make search go faster, hide the columns you don't care about. You can search for multiple terms, and commas and spaces are ignored, and adding search terms restricts the search further. For example [beat, love, me] (don't type the brackets) will find all beatles songs that have the words "love" and "me" (as well as any other song with all three terms).

	If you just want to find all songs with a comma in the name somewhere, search for [,], as that is a special case where the comma is NOT ignored.		If you just want to find all songs with a comma in the name somewhere, search for [,], as that is a special case where the comma is NOT ignored.
Line 10:		Line 10:

	==Targeted Searches==		==Targeted Searches==
	You can search only on a specific column by putting the name of the column first, followed by a colon, followed by your search term.		You can search only on a specific column by putting the name of the column first (case insensitive), followed by a colon, followed by your search term.

	Note this only works well if you've [[Reinterpret\|got your meta data interpreted]] so that each bit of data is in the proper column.		Note this only works well if you've [[Reinterpret\|got your meta data interpreted]] so that each bit of data is in the proper column.
Line 30:		Line 30:
	If you wish to find the exact string you type, not just part of it, prefix the string with '='. For example:		If you wish to find the exact string you type, not just part of it, prefix the string with '='. For example:

	"=Love", will only find songs where any visible sort column has exactly the word "Love" in it (not case sensitive). It will NOT find "Love is all there is".		"=Love", will only find songs where any visible sort column has exactly the word "Love" in it and nothing else (not case sensitive). It will NOT find "Love is all there is".

	You can combine this with Targeted Searches:<br>		You can combine this with Targeted Searches:<br>

Dave: /* Targeted Searches */

2017-09-14T22:46:20Z

Targeted Searches

← Older revision		Revision as of 22:46, 14 September 2017
Line 11:		Line 11:
	==Targeted Searches==		==Targeted Searches==
	You can search only on a specific column by putting the name of the column first, followed by a colon, followed by your search term.		You can search only on a specific column by putting the name of the column first, followed by a colon, followed by your search term.

			Note this only works well if you've [[Reinterpret\|got your meta data interpreted]] so that each bit of data is in the proper column.

	EG: if you search for "bb", you'll get all the songs that you marked as in the key of B flat, but you'll also get all "Abba" songs right? but if you type [key:bb], then you will ONLY search the "Key" column, and only get results in the key of B flat. Note this does not combine with numeric searching, since it is already rather targeted to search only on numeric fields.		EG: if you search for "bb", you'll get all the songs that you marked as in the key of B flat, but you'll also get all "Abba" songs right? but if you type [key:bb], then you will ONLY search the "Key" column, and only get results in the key of B flat. Note this does not combine with numeric searching, since it is already rather targeted to search only on numeric fields.
Line 24:		Line 26:

	There is also a shortcut you can use to avoid typing all that: Just type "s:" to search the "Song Name" column, or type "a:" to search the "Artist" column. These english roman letter shortcuts work regardless of the language that kJams is running in.		There is also a shortcut you can use to avoid typing all that: Just type "s:" to search the "Song Name" column, or type "a:" to search the "Artist" column. These english roman letter shortcuts work regardless of the language that kJams is running in.

	==Exact Searches==		==Exact Searches==
	If you wish to find the exact string you type, not just part of it, prefix the string with '='. For example:		If you wish to find the exact string you type, not just part of it, prefix the string with '='. For example:

Dave at 06:45, 20 December 2013

2013-12-20T06:45:04Z

← Older revision		Revision as of 06:45, 20 December 2013
Line 24:		Line 24:

	There is also a shortcut you can use to avoid typing all that: Just type "s:" to search the "Song Name" column, or type "a:" to search the "Artist" column. These english roman letter shortcuts work regardless of the language that kJams is running in.		There is also a shortcut you can use to avoid typing all that: Just type "s:" to search the "Song Name" column, or type "a:" to search the "Artist" column. These english roman letter shortcuts work regardless of the language that kJams is running in.
			==Exact Searches==
			If you wish to find the exact string you type, not just part of it, prefix the string with '='. For example:

			"=Love", will only find songs where any visible sort column has exactly the word "Love" in it (not case sensitive). It will NOT find "Love is all there is".

			You can combine this with Targeted Searches:<br>
			"singer:=david", will find ONLY a singer who's name is exactly "david", it will NOT find "Jack Davidson"
	==Why is it slow?==		==Why is it slow?==
	See [[Slow Searching]].		See [[Slow Searching]].

Dave: /* Targeted Searches */

2013-07-14T15:59:45Z

Targeted Searches

← Older revision		Revision as of 15:59, 14 July 2013
Line 16:		Line 16:
	To search for something that actually has a colon in it, just put in two colons in a row.		To search for something that actually has a colon in it, just put in two colons in a row.

	To search "checkbox" columns (like "No Lyrics", "Purchased" etc), use a "1" to mean "checked" and a "0" to mean "un-checked". eg: to search for all purchased songs, type "purchased:1" in the search box!~~<br>~~		To search "checkbox" columns (like "No Lyrics", "Purchased" etc), use a "1" to mean "checked" and a "0" to mean "un-checked". eg: to search for all purchased songs, type "purchased:1" in the search box!
	~~<br>~~
	eg: [artist:,] will find all songs where the artist name is "last, first" style<br>		eg: [artist:,] will find all songs where the artist name is "last, first" style<br>
	eg: [artist:", the] will find all songs where the artist name is "<name of artist>, The"~~<br><br>~~		eg: [artist:", the] will find all songs where the artist name is "<name of artist>, The"
	~~<br>~~
	Note that you must enter the target name in the language in which you're running kJams (ie: match the language you see in the sort column header)~~<br>~~		Note that you must enter the target name in the language in which you're running kJams (ie: match the language you see in the sort column header)
	~~<br>~~
	There is also a shortcut you can use to avoid typing all that: Just type "s:" to search the "Song Name" column, or type "a:" to search the "Artist" column. These english roman letter shortcuts work regardless of the language that kJams is running in.		There is also a shortcut you can use to avoid typing all that: Just type "s:" to search the "Song Name" column, or type "a:" to search the "Artist" column. These english roman letter shortcuts work regardless of the language that kJams is running in.

	==Why is it slow?==		==Why is it slow?==
	See [[Slow Searching]].		See [[Slow Searching]].

Dave: /* Targeted Searches */

2013-07-14T15:59:13Z

Targeted Searches

← Older revision		Revision as of 15:59, 14 July 2013
Line 10:		Line 10:

	==Targeted Searches==		==Targeted Searches==
	You can search only on a specific column by putting the name of the column first, followed by a colon, followed by your search term. EG: if you search for "bb", you'll get all the songs that you marked as in the key of B flat, but you'll also get all "Abba" songs right? but if you type [key:bb], then you will ONLY search the "Key" column, and only get results in the key of B flat. Note this does not combine with numeric searching, since it is already rather targeted to search only on numeric fields. To search for something that actually has a colon in it, just put in two colons in a row. To search "checkbox" columns (like "No Lyrics", "Purchased" etc), use a "1" to mean "checked" and a "0" to mean "un-checked". eg: to search for all purchased songs, type "purchased:1" in the search box!<br>		You can search only on a specific column by putting the name of the column first, followed by a colon, followed by your search term.

			EG: if you search for "bb", you'll get all the songs that you marked as in the key of B flat, but you'll also get all "Abba" songs right? but if you type [key:bb], then you will ONLY search the "Key" column, and only get results in the key of B flat. Note this does not combine with numeric searching, since it is already rather targeted to search only on numeric fields.

			To search for something that actually has a colon in it, just put in two colons in a row.

			To search "checkbox" columns (like "No Lyrics", "Purchased" etc), use a "1" to mean "checked" and a "0" to mean "un-checked". eg: to search for all purchased songs, type "purchased:1" in the search box!<br>
	<br>		<br>
	eg: [artist:,] will find all songs where the artist name is "last, first" style<br>		eg: [artist:,] will find all songs where the artist name is "last, first" style<br>
	eg: [artist:",] the<br>		eg: [artist:", the] will find all songs where the artist name is "<name of artist>, The"<br><br>
	<br>		<br>
	Note that you must enter the target name in the language in which you're running kJams (ie: match the language you see in the sort column header)<br>		Note that you must enter the target name in the language in which you're running kJams (ie: match the language you see in the sort column header)<br>

Dave: /* Targeted Searches */

2013-07-14T15:56:04Z

Targeted Searches

← Older revision		Revision as of 15:56, 14 July 2013
Line 10:		Line 10:

	==Targeted Searches==		==Targeted Searches==
	You can search only on a specific column by putting the name of the column first, followed by a colon, followed by your search term. EG: if you search for "bb", you'll get all the songs that you marked as in the key of B flat, but you'll also get all "Abba" songs right? but if you type [key:bb], then you will ONLY search the "Key" column, and only get results in the key of B flat. Note this does not combine with numeric searching, since it is already rather targeted to search only on numeric fields. To search for something that actually has a colon in it, just put in two colons in a row. To search "checkbox" columns (like "No Lyrics", "Purchased" etc), use a "1" to mean "checked" and a "0" to mean "un-checked". eg: to search for all purchased songs, type "purchased:1" in the search box!		You can search only on a specific column by putting the name of the column first, followed by a colon, followed by your search term. EG: if you search for "bb", you'll get all the songs that you marked as in the key of B flat, but you'll also get all "Abba" songs right? but if you type [key:bb], then you will ONLY search the "Key" column, and only get results in the key of B flat. Note this does not combine with numeric searching, since it is already rather targeted to search only on numeric fields. To search for something that actually has a colon in it, just put in two colons in a row. To search "checkbox" columns (like "No Lyrics", "Purchased" etc), use a "1" to mean "checked" and a "0" to mean "un-checked". eg: to search for all purchased songs, type "purchased:1" in the search box!<br>
			<br>
	eg: [artist:,] will find all songs where the artist name is "last, first" style		eg: [artist:,] will find all songs where the artist name is "last, first" style<br>
	eg: [artist:",] the		eg: [artist:",] the<br>
			<br>
			Note that you must enter the target name in the language in which you're running kJams (ie: match the language you see in the sort column header)<br>
			<br>
			There is also a shortcut you can use to avoid typing all that: Just type "s:" to search the "Song Name" column, or type "a:" to search the "Artist" column. These english roman letter shortcuts work regardless of the language that kJams is running in.

	==Why is it slow?==		==Why is it slow?==
	See [[Slow Searching]].		See [[Slow Searching]].

Dave at 06:54, 3 April 2013

2013-04-03T06:54:00Z

← Older revision		Revision as of 06:54, 3 April 2013
Line 3:		Line 3:
	If you just want to find all songs with a comma in the name somewhere, search for [,], as that is a special case where the comma is NOT ignored.		If you just want to find all songs with a comma in the name somewhere, search for [,], as that is a special case where the comma is NOT ignored.

			==Quoted Searches==
	You can also search for a quoted string if you want to include commas or spaces. For example: [", the"], (with the quotes), will find all the songs that have a comma, then a space, then the word "the". The closing quote is optional if the quoted string is the last one you enter.		You can also search for a quoted string if you want to include commas or spaces. For example: [", the"], (with the quotes), will find all the songs that have a comma, then a space, then the word "the". The closing quote is optional if the quoted string is the last one you enter.

Dave at 06:23, 27 March 2013

2013-03-27T06:23:13Z

← Older revision		Revision as of 06:23, 27 March 2013
Line 1:		Line 1:
	To search for a song in the current playlist, press ⌘-F (command-F mac, or control-F windows). To search for a song in the Library, press ⌘⇧-F. Searching will search every '''visible''' column, so to make search go faster, hide the columns you don't care about. You can search for multiple terms, and commas and spaces are ignored. For example "beat, love, me" will find all beatles songs that have the words "love" and "me" (as well as any other song with those three terms).		To search for a song in the current playlist, press ⌘-F (command-F mac, or control-F windows). To search for a song in the Library, press ⌘⇧-F. Searching will search every '''visible''' column, so to make search go faster, hide the columns you don't care about. You can search for multiple terms, and commas and spaces are ignored. For example [beat, love, me] (don't type the brackets) will find all beatles songs that have the words "love" and "me" (as well as any other song with those three terms).

	If you just want to find all songs with a comma in the name somewhere, search for ",~~" (no quotes)~~, as that is a special case where the comma is NOT ignored.		If you just want to find all songs with a comma in the name somewhere, search for [,], as that is a special case where the comma is NOT ignored.

	You can also search for a quoted string if you want to include commas or spaces. For example: ", the", ~~this time WITH~~ the quotes, will find all the songs that have a comma, then a space, then the word "the". The closing quote is optional if the quoted string is the last one you enter.		You can also search for a quoted string if you want to include commas or spaces. For example: [", the"], (with the quotes), will find all the songs that have a comma, then a space, then the word "the". The closing quote is optional if the quoted string is the last one you enter.

	==Numeric Searches==		==Numeric Searches==
	To search for a number like "Song ID", just type the number. If you only type digits into the search field, it will be interpreted as a number and NOT as a string, and it will search numeric fields only, automatically. eg: typing "52" will find "Song ID" 52, but will NOT find "The B-52s". To search for NON-numeric numbers, add a space to the end, eg, typing "52 " (note the space?), this will NOT find "Song ID" 52, but it WILL find "The B-52s". Note the Date column is NOT numeric.		To search for a number like "Song ID", just type the number. If you only type digits into the search field, it will be interpreted as a number and NOT as a string, and it will search numeric fields only, automatically. eg: typing [52] will find "Song ID" 52, but will NOT find "The B-52s". To search for NON-numeric numbers, add a space to the end, eg, typing [52 ] (note the space?), this will NOT find "Song ID" 52, but it WILL find "The B-52s". Note the Date column is NOT numeric.

	==Targeted Searches==		==Targeted Searches==

Dave: /* Targeted Searches */

2013-03-27T06:21:41Z

Targeted Searches

← Older revision		Revision as of 06:21, 27 March 2013
Line 9:		Line 9:

	==Targeted Searches==		==Targeted Searches==
	You can search only on a specific column by putting the name of the column first, followed by a colon, followed by your search term. EG: if you search for "bb", you'll get all the songs that you marked as in the key of B flat, but you'll also get all "Abba" songs right? but if you type "key:bb", then you will ONLY search the "Key" column, and only get results in the key of B flat. Note this does not combine with numeric searching, since it is already rather targeted to search only on numeric fields. To search for something that actually has a colon in it, just put in two colons in a row. To search "checkbox" columns (like "No Lyrics", "Purchased" etc), use a "1" to mean "checked" and a "0" to mean "un-checked". eg: to search for all purchased songs, type "purchased:1" in the search box!		You can search only on a specific column by putting the name of the column first, followed by a colon, followed by your search term. EG: if you search for "bb", you'll get all the songs that you marked as in the key of B flat, but you'll also get all "Abba" songs right? but if you type [key:bb], then you will ONLY search the "Key" column, and only get results in the key of B flat. Note this does not combine with numeric searching, since it is already rather targeted to search only on numeric fields. To search for something that actually has a colon in it, just put in two colons in a row. To search "checkbox" columns (like "No Lyrics", "Purchased" etc), use a "1" to mean "checked" and a "0" to mean "un-checked". eg: to search for all purchased songs, type "purchased:1" in the search box!

	eg: "artist:," will find all songs where the artist name is "last, first" style		eg: [artist:,] will find all songs where the artist name is "last, first" style
			eg: [artist:",] the

	==Why is it slow?==		==Why is it slow?==
	See [[Slow Searching]].		See [[Slow Searching]].

Dave at 06:19, 27 March 2013

2013-03-27T06:19:26Z

← Older revision		Revision as of 06:19, 27 March 2013
Line 3:		Line 3:
	If you just want to find all songs with a comma in the name somewhere, search for "," (no quotes), as that is a special case where the comma is NOT ignored.		If you just want to find all songs with a comma in the name somewhere, search for "," (no quotes), as that is a special case where the comma is NOT ignored.

	You can also search for a quoted string if you want to include commas or spaces. For example: ", the", this time WITH the quotes, will find all the songs that have a comma, then a space, then the word "the".		You can also search for a quoted string if you want to include commas or spaces. For example: ", the", this time WITH the quotes, will find all the songs that have a comma, then a space, then the word "the". The closing quote is optional if the quoted string is the last one you enter.

	==Numeric Searches==		==Numeric Searches==