Diary Display with Search for Work

The Data Model shown below will not appear when we go live.
Salesforce GAF demo for Work Diary

This first paragraph will not be included

You can look back at my Diary for 2007 and 2008

I am thinking of providing a Salesforce demo, following the table on the left-hand side ...

Diary Display with Search ,Diary Display with Search for Work (this page) ,Diary Search Results and Diary Data Entry

When the User clicks on the 2DoList button on the left, a separate window is displayed that shows the results of searching for the '2DoList' Topic Tag.

When the User clicks on the Customers button on the left, a separate window is displayed that shows a list of Customers stored in the Customers_Custom_Object.

This page shows that the Search box is simply added to the layout of the Diary Display Page.
SEARCH LOGIC
The SQL for the Search Logic would look something like this :-
SELECT *
FROM My_Diary
WHERE activity_text_area LIKE '%search terms entered by user%'
OR topic_tag_name LIKE '%search terms entered by user%'

Welcome, Barry

Activities and Links

DATE OF ENTRY	TOPIC TAG	ACTIVITY	LINKS
17th. Jan 8.00 am	e-Learning	I went to the e-Learning Exhibition yesterday and was amazed how crowded it was. Very worthwhile though, with interesting suppliers ranging from an expensive Microsoft product called Sharepoint to Moodle, a free Open Source Learning Management System, that the UK's Open University has funded to the extent of £3 nillion.	BETT Elicitus Authoring Tool Moodle Authoring Tool Open University
16th. Jan 8.00 am	Shopping	My wife's jacket has not arrived on 20th. from Frey, so she went to the Frey Web Site, found the phone number and called them.	Frey Web Site
15th Jan 6.00 pm	Amex	My wife gets the AmEx bill covering our trip to Switzerland and checks each item against the Receipts.	Receipt for Boat Trip
14th. Jan 9.00 pm	Web 2.0	Today's Guardian mentions an entertaining YouTube video on iPhones based on 'These Bones, These Bones' which says 'this is connected to that and that is connected to the other [and so on]'	Tour of Web 2.0
14th. Jan 9.00 pm	Salesforce, eLance	I posted my Online Diary Project on eLance with login Barry/m333 and email dba gm/m333 (or m3), with budget of $500 - $1,000. One of the Salesforce experts I found was Chad Collins who has an interesting Web Site.	Chad Collins eLance eLance - My Project
14th. Jan 9.00 am	Salesforce	Googling for "Salesforce freelance expertise" I found a good-looking Web Site called oDesk which makes it very easy to find and work with Freelance Contractors. Weight Wednesday 96.4 Kg	oDesk Salesforce - Alok Verma
14th. Jan 8.30 am	Selling	Here's a great slogan "Selling is Just a Conversation".	SIJAC
14th. Jan 7.00 am	Work	Think about Interim IT Management. In the meantime, Google for "Interim Management".	BIE Interim Mgt Executives Online
14th. Jan 6.30 am	Global Consulting	BT provides Global Services which genuinely have a presence in almost every country around the world, including Malaysia.	BT Global Services Mobile Services
11th. Jan 9.30 am	SQL Server	I joined PASS - the Professional Association for SQL Server as dba gmail / m333	PASS
11th. Jan 9.30 am	Wales	Castles and Historic Railways are an important part of the tourist attractions of Wales. You can take a train to the top of Snowdon,Festiniog has its own railway and a new 40-mile line is being built from Caernarfon across the mountains to Porthmadog.	Castles of Wales Great Little Trains of Wales Wales in Syle Wales in Style (Castles)
10th. Jan 11.00 pm	e-Learning	Here's a great Organisation called the Open University of Cataluna in Spain looking at how to use Web 2.0 and Mobile Applications for Education at the University level.	Internet Project UOC (English) UOC (Spanish)
10th. Jan 5.00 pm	2DoList	Talk to these people, including Larry Hunter at Spargo (Mobile 07774-646973) and (maybe) consider partnering with them.	Conchango (Egham) Spargo (Egham) Spargo (Larry Hunter's Email)
10th. Jan 4.30 pm	Restaurants	Had a great light lunch at Momo's in Staines (Malaysian-owned), with Miso Soup and Sushi	Momo's (London) Momo's (Staines)
10th. Jan 4.15 pm	NHS	Glucose Tolerance Test rescheduled to 9.15 am, Monday, January 12th. 2009, ask for Ludy or Nahid Weight Saturday 96.8 Kg
8th. Jan 4.00 pm	NHS	Contacts :- Dr. Catherine Lunken at Hotmail.com Prof. Bettridge Secretary - 0207-380-9336 Glucose Tolerance Test any time, Friday, January 9th. 2009, ask for Ludy. I was turned away because I fasted for over 14 hours. Hospital # 93024145 Clinic J Reception 0845-155-000, Ext. 73147 - Ann Groom. Weight Friday 97.4 Kg	UCL Hospital
7th. Jan 9.30 pm	Microsoft	Microsoft has created a new Web Site for IT Architects in the UK.	IT Architects (UK)
6th. Jan 2.00 pm	Salesforce	I added Salesforce to the MDM Layer Implementation in the Tutorial for Integrated Performance Reporting. Weight Tuesday 98.0 Kg	Search for: A Model-Driven Approach to Data Quality For Global Accountability.
3rd. Jan 8.00 am	Web 2.0	I found this definition by Komodo in Australai :- Globally, information and communication technology (ICT) is moving into a new networked era. It is characterised by the widespread uptake of high capacity broadband, many millions of users and powerful digital devices becoming connected around the globe, and the evolution of the internet as the key platform for communication and collaboration. This new era is often referred to as Web 2.0. It involves the advent of a range of new internet-based tools, such as wikis, blogs, social networking sites, image-based interfaces, video sharing sites, information mash-ups and virtual worlds. Web 2.0 also involves a range of new capabilities, such as user-generated content, collective intelligence, reusable and remixable data, and open access sharing and collaboration. Consistent with the impact of ICT over the past 20 years, effective use of this next generation of ICT has the potential to drive continued productivity and growth in a wide range of information intensive sectors of the Victorian economy.	Wikipedia on Web 2.0
3rd. Jan 5.30 pm	eLearning	Here are some useful Links :- Web CT is in use at the University of Alberta, Canada.	Blackboard eLearning of Australia Web CT University of Alberta, Canada.
3rd. Jan 7.30 am	eLearning	I will look into building 3-D Tutorials for Data Mdelling and my other Tutorials. I can find plenty of Developers to help me, such as FinPA in Australia, who specialise in eLearning and use VastPark. ZenworkZ is an Australian company specialising in "enhancing the performance of individuals, teams, executives and communities".	Fund for Innovation Fund Article eLearning of Australia FinPA My Microsoft Page Tutorial on Data Modelling Tutorial (Video - 26Mb) ZenworkZ (Aus)