logo

Relational Domino Example Database

As some of you have already noticed I published a new article yesterday. Well what kind of friend would I be if I didn't back it up with this demo application?

If you haven't already, I suggest you read the article to see what the demo is trying to achieve. Then create a new article. Give it a title and use the "Add Link..." button to add links to some related articles before you click Submit. Now edit the title of one of the article you linked to and return to your original. Notice the title has updated. Delete an article you linked to and see how it's no longer in your list of links. After deleting an article, put you original in edit mode and notice you are prompted to remove the ID of the article that no longer exists.

Note: You might have worked out that you've got edit and delete rights to this database. Please don't abuse this and go deleting everything. You just spoil it for the rest of us! Please don't write anything untoward either as I will have to delete it and I've got better things to do.

If this technique does nothing else it will no doubt create discussion. As some of you have pointed out there are other ways of achieving the same thing using "standard" Notes elements. I knew this. What I always try to do is show as many different approaches to problems as possible. We all know the normal ways. How about "thinking different" for a change?

Comments

  1. Jake -

    The way I would probably attack this issue is to categorize each article, then add an embedded, single category HTML view at the bottom of the form which displayed the related articles for the designated category. This is a simple solution that becomes more complex when you want to start assigning multiple keywords to an article, but it's a start!

    -- Mike

  2. Hate to be a pain... but the links on your blog return an error. It's appending the apps/db to the base href.

    Thought you'd like to know ;-)

    -Chris

    • avatar
    • Jake
    • Tue 27 Apr 2004 09:32

    Mike. That works but how do you know that somebody wants all article in a certain category to be deemed related. Surely it's better to have the ability to list any or all articles as needed.

    Thanks Chris. You're right, I do link to know. Fixed now.

  3. More is better! ;->

    Seriously, I think it can be done by utilizing categories and subcategories, especially by building in functionality that allows articles to span multiple categories/subcategories. As a developer, I would rather code more in the backend to eliminate the need of maintenance further down the road, whether it be design maintenance or the users of the app having to scrub the data.

    -- Mike

    • avatar
    • Charlie Farquarhart
    • Wed 28 Apr 2004 02:29

    Kake

    any plans to allow us to download the demo application? One would find this extremely useful. Thank you kind sir. Charles

    • avatar
    • Jake
    • Wed 28 Apr 2004 04:45

    The download will be attached to the next article that completes the "series". Probably some time within the next month.

    You shouldn't really need it though! You've got the @formula you need and all the JavaScript is available in the source HTML of the demo. Plug it all together and you've got the solution...

Your Comments

Name:
E-mail:
(optional)
Website:
(optional)
Comment:


About This Page

Written by Jake Howlett on Tue 27 Apr 2004

Share This Page

# ( ) '

Comments

The most recent comments added:

Skip to the comments or add your own.

You can subscribe to an individual RSS feed of comments on this entry.

Let's Get Social


About This Website

CodeStore is all about web development. Concentrating on Lotus Domino, ASP.NET, Flex, SharePoint and all things internet.

Your host is Jake Howlett who runs his own web development company called Rockall Design and is always on the lookout for new and interesting work to do.

You can find me on Twitter and on Linked In.

Read more about this site »

More Content