Along with the regular search tools in the Song, Link and Notes browse windows and the Editor window, GSelector offers an Advanced Search tool in these windows. This allows the user to search across the entire Database, or to search within one or more Station libraries, combining ranges of criteria, building in multiple sorts. In the Song and Link Browse windows, Advanced searches can include Active and Inactive songs.
A modified version of this tool is available in the Interfaces Media Monitors window, used to search for matching Songs when importing Media Monitors data. See the notes in this topic, and the Find Songs Tool notes
TIP: In the Browse and Editor, the Advanced Search tool does not offer a default search, showing all Songs Links or Notes in the current Station: there is no data in the Filter Pane or the Results Pane. You search in this window by working in the blank Filter Pane, and adding one or more queries, before clicking the Search Button.
From the Library Browse window, click the Advanced Search button at the top left of the Filter pane. This opens the Advanced Search Pane in the Browse window, as shown below; it replaces the Filter Selection pane.
From the Linker Browse window, click the Advanced Search button at the top left of the Filter pane. This opens the Advanced Search Pane in the Links Browse window, replacing the Filter Selection pane.
From the Notes Browse window, click the Advanced Search button at the top left of the Filter pane. This opens the Advanced Search Pane in the Notes Browse window, replacing the Filter Selection pane.
From the Editor Toolbar, click the Advanced Search button. This opens a freestanding Advanced Search Pane, shown below.
In the Interfaces Media Monitors window, click the Search button at the right of any Song entry in the Map Songs pane to access the Find Songs version of the Advanced Search tool.
Click any area in the image for help.
Click any area in the image for help.
Advanced Search pane for Editor window
Find Songs Advanced Search tool
Results pane (Browse windows and Editor window)
Results Pane (Interfaces Media Monitors Find Songs tool)
You can apply any previously saved Filter, or display any saved List.
Click the selection arrow to access the list of saved Filters and Lists.
Where more Saved filters or lists exist than can be displayed, use the scroll bar to select.
Select or scroll down to the desired Filter or List, and click or enter to display Songs/ Links/Notes by the selected Filter, or the saved List in the Results pane.
For more information see the notes on working with Filters and Lists in the Filters and Lists Enter Name box topic.
This pane allows you to assemble a browse by specifying a query, and then, line by line, combining it with further queries. Every query, or element of your Browse request, is listed in the Search Summary pane. For full details on using the tools in this window, see the Building Search Request notes in this topic. The search criteria is automatically saved so the next time the Advanced search is used the previous search criteria is displayed. This saved criteria is persistent until GSelector is restarted.
Click any area in the image for help.
Click any area in the image for help.
Select a song or link in the editor then select the Advanced Search toolbar button to access the Advanced Search pane in the Editor, the default is to search for the asset type selected that are active for the current station. However, you can search for active or inactive songs/Links by setting the Search Type to True for active or False for inactive. Completing a search will close this pane and open the search results in the Editor Consideration pane. The search criteria is automatically saved so the next time the Advanced search is used for a similar asset type the previous search criteria is displayed. This saved criteria is persistent even after closing and restarting GSelector.
NOTE: GSelector does not allow for the Active criteria in an Advanced Search to be deleted. So you must do either an active or inactive search, not a mixed one. The Number of inactive songs displayed is limited to 1,000 inactive songs. If the results is more than 1,000, GSelector will prompt the user to narrow down the search. There are no Failure Details on an Inactive Advanced Search.
Click any area in the image for help.
Click any area in the image for help.
Click the Add Query button to open a Query. Each Query in the search occupies a separate line.
Click the Clear All button to delete all Queries in the current search. Note that you can clear an individual query directly from the query line.
This drop-down allows the user to search the current station or All Stations in the database. Click the Search drop-down to change from the default Station Specific: Current Station to Station Specific: All Station.
Click the Close Advanced Search X button or press the ESC key to exit Advanced Search mode and return to the main Browse window.
This version of the Advanced Search tool is used when importing data from Media Monitors. The window is used to match Song data in the GSelector and Media Monitors databases. It is opened for a specific Song from the Interfaces Media Monitors window, showing Artist and Title data Search Elements taken from the Media Monitors database, and in the Results Pane, possible matches in the GSelector database. The default Search Type in the Search Elements pane is Partial Text Match, which offers the best chance of matching the Media Monitors Song Title and Artist text to the GSelector Song Title and Artist names. Selecting a match closes this window and returns you to the Interfaces Media Monitors window.
If there is no satisfactory search result in the Results Pane, you can use the advanced search tools to locate the correct item. See the notes in this topic on working in the Advanced Search window.
Click any area in the image for help.
Click any area in the image for help.
The Find Songs Results pane shows all Songs active on your current station that are a partial text match for the search criteria in the Search Elements.
Click the Select button to match the selected item in the results pane with the Media Monitors Song entry.
See also the Building Search Request notes in this topic.
Each element of your search is added by clicking the Add Query button. When you add a query, it is added on a new line. In each line, you first select the Attribute by clicking the drop down arrow, and then the search type, which varies according to the Attribute, and finally a Search Text qualifier. In the Song Browse example here, we are looking for Active Songs (selected in the Attribute Column, and True in the Search Type column), in WRCS-FM Rock as specified in the Search Text and finally the Station. So this search element calls for Active Songs on WRCS-FM Rock.
Click any area in this image for help
This Boolean Operator field is used on the lines for second and subsequent queries. See the notes on Combining Queries in this topic for details.
Click the drop-down arrow to select any Attribute to use in the query. All Attributes, Additional Attributes and User-Defined Attributes and Song Media ID are included in this drop-down list. The Attribute you select will determine the available Search type and Search Text. So if you select the first Attribute in the list - Active - you can apply True or False. If you select a descriptive Attribute you can apply a range of Search Types. The full list of Search Types is listed below.
Note: Total Plays is not available as an Attribute selection at this time. If you only search on a research score, GSelector will match on the most recent score, which is consistent with what is displayed in the browse format and used for the research attribute. If you include research score date, then GSelector will include all of the scores. In this case, it may match on an older score that is not visible in the browse format.
The Search types available in this field are determined by the selected Attribute.
True/False: Two options only: the selected Attribute is either included or excluded.
Text Attribute fields: GSelector provides a range of options to match or exclude partial or complete parts of the text. You can select any one of these in a search line, or use a combination in different search lines. See the Text Search Type Options notes for more information,
Number, Date and Time Attribute fields: GSelector provides a range of options to specify a range or a greater or lesser value, sometimes qualifying the values using the Search Text.
The values in this field are determined by choices in the Attribute and Search Type fields. With Stations, you can select from a Station Database, All Stations or Any Station. With Text fields, you enter Text to match or avoid, and with Numeric or Time values you enter a number or number range to match or avoid.
To clear any query line, click the button at far right of the line.
The Fetch value determines the number of records that will be displayed in the Results Pane when the Search is executed. Clicking the More button will fetch another number of songs. If Fetch is set to 100, then the first Search will display 100 records. The More button will then fetch the next 100 records, and will continue to do so each time the button is clicked. This is particularly useful when reviewing a search across a large database covering multiple stations.
Click to initiate the search once you have defined your search.
All elements in the search are summarized in this pane. For query a new line is added which summarizes the element defined in the Advanced Search pane.
TIP: You can assign an Appearance to the Text in this pane. In the Appearances assignment window, select an Appearance for the Query Window under the Advanced Search heading. The Appearance will be applied in all stations in the main advanced search browse window and the editor advanced search window
Results Pane Toolbar
More and All buttons
See also the notes in this topic for the Find Songs Results Pane
This pane displays the results of your search. It works in exactly the same way as the results pane in the main Browse Window. However, there is one feature that is exclusive to this window, which is disabled in the main Browse window: The More and All buttons.
In the Toolbar, save any existing Filter setting or list, save a modified Filter or List as a new Filter or List, or delete the existing Filter or List.
The buttons at the right of these controls allow you to invert the Selection, reset the Filter, Show Dynamic Statistics for this browse and export to XML. The Toolbar for the Songs and Links results pane also allows you to apply a different browse format, Merge Duplicates and open the Browse List window. Toolbar buttons may vary in color based on the Appearance Style selected.
Save existing Filter or List as New button
Browse Format Selection button
Click this button to save changes to an existing Filter or Song List, or to Save a new Filter or Song List. If you are saving a new Filter or Song list, the Enter Name dialog box opens.
NOTE: When Saving a Song list, Unselected Songs are not saved, whether or not the Show unselected Songs box is checked.
To save a modified Filter or Song list , click the Save As New Filter or Song list button to open the Enter Name dialog box.
This dialog box is used in the Song, Link and Notes browse windows. It has a range of secondary functions, allowing, for example, with Songs and Links (but not Notes), the ability to merge a List with a previously saved list. To save a Filter or a Song list , click the appropriate radio button, enter a name and click OK. For full details on working in this dialog box, see the Filters and Lists - the Enter Name box topic.
To permanently delete any Filter or Song list, select that Filter or Song list and click the Delete button. The library browse pane returns to its unfiltered state, and the Filter or Song List is removed from the saved list.
Click this button to reverse the selections for all Songs in the Browse pane. If a Song is selected, it will become unselected; conversely, unselected Songs will be selected.
To clear a modified Filter or Song list from the browse without deleting the saved Filter or Song list, click the Reset Filter button. The library browse returns to its unfiltered state, but the Filter is retained in the saved Filter list.
TIP: When you have added or edited some attributes or participants, using the Multi-Song changer, click this button to refresh the attribute or participants lists.
Click this button to access the Dynamic Statistics window, which allows you to analyze and measure the contents of your browse in a number of ways.
Click this button to view and select formats, designed and specified in the Export XML window, for Song XML export types. Select a format and click to export a XML file of the currently browsed Songs details to the selected destination for that format. See the notes on Working with XML for more information.
/While formats can be permanently assigned to the Browse window in the Browse Formats Assignment window, this button allows you to temporarily select and apply any format that you have designed in the Browse Formats Design window. This feature is available for Active songs and links.
1. Click the arrow to the right of the button.
2. Select a format and double-click or press enter.
3. The new format is assigned to the browse window.
For more information on custom designing formats, see the Browse Formats Design and Browse Formats Assignment topics.
This Merge Duplicates button enables users to resolve the common problem of having duplicate songs or links in an enterprise database and the need to eliminate some or all of the duplicates after selecting one of the duplicate records to remain standing as the survivor. Schedule history and station-specific attributes will be moved over to the surviving record for each station of which the surviving Song or Link is to become active. See the Merge Duplicates topic for additional details.
Click the Browse List button to open the Browse List pane in the Song or Link Browse windows. From the Browse List pane the user can create lists of Songs or Links for scheduling special programming, such as holiday countdown shows, “A to Z” weekends and other forms of programming in which an arbitrary list of songs or links must be scheduled in sequence. Lists created using the Advanced Search window are available in the List drop-down of this pane and can be edited from this Browse List pane.
This pane, above the Song results pane, displays the total number of Songs in the browse, and the number of the selected Song.
Searches across a large enterprise database can turn up very large search results. With some computers, or if working across LAN or WAN networks, displaying all search results can put a strain on system resources. If this is the case, you can choose to view the search results bit by bit, each bit according to the number you have specified in the Fetch Number field. Click the More button to view the next batch of Songs. Click the All button to fetch all the Songs.
The basic Search Process described
Changing the Appearance of Searches
When you design a search, you enter a series of queries, adding them line by line. You should set these out in order of importance in the Filter Pane - that is, the most important query of the search should be the first line of your search. You can group elements by dragging and dropping.
When working with a text Attribute (such as Artist, Title, Participant, Album Title, Film Name, and so on), GSelector offers a very powerful range of search type options. You can, for example, search for a part of the name, or look for the beginning or the end of text information, exclude material, or even try fuzzy matches if you are not quite sure of the exact wording. This is a very powerful tool, and is particularly useful when searching in large databases. You could, for example, set up a combined search across multiple stations (or even the entire library, by specifying both active and inactive songs for the current station in successive lines), and then add a fuzzy match query for an artist. This should bring up all potential spellings (and mis-spellings) added to the selected stations or the global database for this artist.
When you add a second of further query to a search, the Operator field in this line offers you two options:
And: Add the criteria in this query line to the criteria in the previous line to provide a set of criteria, all of which must apply in the search.
Or: Apply the criteria in this query line to the criteria in the previous line to provide a set of criteria, any of which can apply in the search.
So in this image, you are looking for active Songs on either of two stations - WRCS-FM Rock and The Top 40 If you select the and operator, you would be looking for Songs which were active on both WRCS-FM Rock and The Top 40, you would select the and operator.
This feature allows you to combine two or more Queries together so that they are treated as one Query line in relation to other Queries. In this example, the search request is for a grouped search expression ('Male' vocal code or 'Group' vocal code songs), which have a runtime of between 2:30 and 4:14. This expressed in the summary pane with brackets around the first two, grouped, search expressions. Grouped Queries are shown in an expandable group, which can be closed or opened as required by clicking the group node.
To combine Query lines into one statement is a straightforward process. Select an Query and drag to another Query. Any Queries in between the selected Query and the target Query will be grouped together.
|
Select and click the clear button at right of the group header to delete the group. The Queries are not deleted, but simply ungrouped. See the notes here about clearing a single Query line.
When defining a search, you can also apply one or more Sorts.
Click any Header in the Browse Results pane to apply a single Sort order, ascending or descending. The results of your search are displayed in the Query Window.
To add another secondary Sort order, press the Shift Button and click a second header. This will add a second element to your Sort Request.
You can repeat adding further Sort orders, only limited by the number of fields in your Browse Format . For more information, see the Sort notes in the Working with Browses topic.
When activating a Song, the Song is first selected from the inactive list, and then activated in the Song window or the Library window. If you are activating a new Song that has never been activated before in any station, you will need to fully code the Song in the Song window according to your goal preferences. If you are re-activating a Song, its previous settings in this station are retained.
Working in the Appearances definition window, you can design a custom Appearance for the text in the Queries window. You can then assign this appearance in the Options: Appearances Assignment window.