A. What events are displayed?
When EK searches for events and the user has specified (on the URL or using the dropdown list) that they want to see "curKey1" events, a particular event (with its first keyword = "EvtKeyword1") will be displayed if ANY of the following conditions is true:
1. EvtKeyword1 is identical to curKey1 (this is the obvious one)
e.g. select "Storytime", show any events with keyword = "Storytime"
2. EvtKeyword1 begins with an asterisk
e.g. no matter what keyword is selected, show any events with keyword = "* Holidays"
3. EvtKeyword1 begins with a hyphen
e.g. no matter what keyword is selected, show any events with keyword = "- Holidays"
4. EvtKeyword1 contains a plus sign, space and curKey1, ie. "+ curKey1"
e.g. select "Movies", show any events with keyword something like "+ Movies + Plays"
5. EvtKeyword1 is identical to left brace, space, curKey1, i.e. "{ curKey1"
e.g. select "Songs", show any events with keyword = "{ Songs"
B. What is shown in the keyword dropdown list?
Some of items above don't make sense until we see how the drop down list of keywords is constructed. EventKeeper searches all the events and puts the keywords it finds into the dropdown list if ALL of the following conditions are met:
1. EvtKeyword1 is not blank
2. EvtKeyword1 does not start with a hyphen
e.g. You won't see a keyword of "- Staff" in the drop down list
3. EvtKeyword1 does not start with a caret
e.g. You won't see a keyword of "^ Test" in the drop down list
4. EvtKeyword1 does not start with a brace and a space
e.g. You won't see a keyword of "{ Goofy" in the drop down list
Common Examples:
1. Give Holidays a keyword of "* Holiday". Those events will show up no matter what keyword is selected and folks can select "* Holiday" from the keyword dropdown list to see all the holidays.
2. Give a crossover event a keyword of "+ Adults + Teens" (which we call a COMBO KEYWORD) and that event will be displayed if the user selects a keyword of either "Adult" or "Teen". Note, at this point, for the keyword "Adult" to show on the dropdown list, there has be at least one event with the keyword "Adult". That is, we don't build the individual keywords from a combined keyword, we assume that events with the single keywords already exist. Folks can add dummy events to force the keyword to show up if necessary.
3. And finally, the question that prompted all of this. To create a COMBO KEYWORD that isn't displayed, use the caret at the beginning, e.g. "^+ Adults + Teens".
Example from Wallingford:
http://www.eventkeeper.com/code/events.cfm?curOrg=WFORD&curKey1=Adult%20Programs,All%20Ages
Both of the keywords "adult programs" and "all ages" are in keyword 1. The link above will show a list of events that have the keyword of Adult programs OR all ages into one combined list.
And finally, for you SQL geeks out there, here are the relevant query snippets:
A. When selecting events
AND ((evtKeyword1 = '#curKey1#') OR (evtKeyword1 LIKE '*%') OR (evtKeyword1 LIKE '-%') OR (evtKeyword1 LIKE '%+ #curKey1#%') OR (evtKeyword1 = '{ #curKey1#'))
B. When building keyword drop down list:
AND EvtKeyword1 <> ' AND EvtKeyword1 NOT LIKE '-%' AND EvtKeyword1 NOT LIKE '^%' AND EvtKeyword1 NOT LIKE '{ %'
A. What events are displayed?
When EK searches for events and the user has specified (on the URL or using the dropdown list) that they want to see "curKey1" events, a particular event (with its first keyword = "EvtKeyword1") will be displayed if ANY of the following conditions is true:
1. EvtKeyword1 is identical to curKey1 (this is the obvious one)
e.g. select "Storytime", show any events with keyword = "Storytime"
2. EvtKeyword1 begins with an asterisk
e.g. no matter what keyword is selected, show any events with keyword = "* Holidays"
3. EvtKeyword1 begins with a hyphen
e.g. no matter what keyword is selected, show any events with keyword = "- Holidays"
4. EvtKeyword1 contains a plus sign, space and curKey1, ie. "+ curKey1"
e.g. select "Movies", show any events with keyword something like "+ Movies + Plays"
5. EvtKeyword1 is identical to left brace, space, curKey1, i.e. "{ curKey1"
e.g. select "Songs", show any events with keyword = "{ Songs"
B. What is shown in the keyword dropdown list?
Some of items above don't make sense until we see how the drop down list of keywords is constructed. EventKeeper searches all the events and puts the keywords it finds into the dropdown list if ALL of the following conditions are met:
1. EvtKeyword1 is not blank
2. EvtKeyword1 does not start with a hyphen
e.g. You won't see a keyword of "- Staff" in the drop down list
3. EvtKeyword1 does not start with a caret
e.g. You won't see a keyword of "^ Test" in the drop down list
4. EvtKeyword1 does not start with a brace and a space
e.g. You won't see a keyword of "{ Goofy" in the drop down list
Common Examples:
1. Give Holidays a keyword of "* Holiday". Those events will show up no matter what keyword is selected and folks can select "* Holiday" from the keyword dropdown list to see all the holidays.
2. Give a crossover event a keyword of "+ Adults + Teens" (which we call a COMBO KEYWORD) and that event will be displayed if the user selects a keyword of either "Adult" or "Teen". Note, at this point, for the keyword "Adult" to show on the dropdown list, there has be at least one event with the keyword "Adult". That is, we don't build the individual keywords from a combined keyword, we assume that events with the single keywords already exist. Folks can add dummy events to force the keyword to show up if necessary.
3. And finally, the question that prompted all of this. To create a COMBO KEYWORD that isn't displayed, use the caret at the beginning, e.g. "^+ Adults + Teens".
Example from Wallingford:
http://www.eventkeeper.com/code/events.cfm?curOrg=WFORD&curKey1=Adult%20Programs,All%20Ages
Both of the keywords "adult programs" and "all ages" are in keyword 1. The link above will show a list of events that have the keyword of Adult programs OR all ages into one combined list.
And finally, for you SQL geeks out there, here are the relevant query snippets:
A. When selecting events
AND ((evtKeyword1 = '#curKey1#') OR (evtKeyword1 LIKE '*%') OR (evtKeyword1 LIKE '-%') OR (evtKeyword1 LIKE '%+ #curKey1#%') OR (evtKeyword1 = '{ #curKey1#'))
B. When building keyword drop down list:
AND EvtKeyword1 <> ' AND EvtKeyword1 NOT LIKE '-%' AND EvtKeyword1 NOT LIKE '^%' AND EvtKeyword1 NOT LIKE '{ %'