?
Solved

Displaying SubCategories in a categories field

Posted on 2002-04-19
12
Medium Priority
?
267 Views
Last Modified: 2013-12-18
I have created a categories field and I am able to create subcategories by using the '\'.  

I am using a formula to create the list of choices for a categories field.  This formula does a dbColumn lookup from a view called "By Category".  Here is my formula currently:  

@Unique(@DbColumn("":"nocache"; ""; "By Category"; 1))

This formula only returns a list of the highest level categories, but does not list the subcategories. Can I create a formula that will return the subcategories as well?

Thanks!



0
Comment
Question by:sauce12
  • 4
  • 4
  • 4
12 Comments
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 6954823
Create a view which lists both Cateogory and SubCategory fields... and then use dbcolumn.

or

use the column number where the subcategory is listed in second dbcolumn like this (assuming, subcategory is second col)
@Unique(@DbColumn("":"nocache"; ""; "By Category"; 1)):@Unique(@DbColumn("":"nocache"; ""; "By Category"; 2))


~Hemanth
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6954859
Sorry sauce12, but this can not be true.

If you request the first column, like:
@Unique(@DbColumn("":"nocache"; ""; "By Category"; 1))

than you get all values from all categories contained in this first column.
All categories from all levels in this first column are separate elements.

You have anywhere else an error.

0
 
LVL 10

Expert Comment

by:zvonko
ID: 6954863
Where do you see the result from this @DbColumn?

I suggest to you to make for this test in a form a computed for display field containing this @DbColumn as value formula. So you can compare the results.

0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:sauce12
ID: 6954868
Hemanth -

Can I create a view containing categories and Subcategories without spliting the those into 2 fields on my form?
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 6956058
In the first column, include formula like this

Category : SubCategory

and sort it and check show as seperate entries in view property.
0
 

Author Comment

by:sauce12
ID: 6956085
I want to make sure we are on the same page here.  As I understand, if I create a field named "categories".  It serves as sort of a keyword in notes.  That is, it allows you to create subcategories by entering something like this:  

MainCategory1/SubCategory1

Is this correct about how "categories" is some sort of keyword in notes?

And then when I create a view with the value of the first column as "categories" and check that it is a categorized field - it will display like this:

>MainCategory1
  >SubCategory1
    My document

That works fine for me.

What I want to be able to do is when I use a formula to generate a list of values for my "categories" field.  I would like for it display:
MainCategory1
MainCategory1/SubCategory1

Or something like that, as long as Subcategories are also shown.  I hope that clears things up.  Is this possible?

Zvonko -
 
This is how you think it should work, using the formula I am using now?  You are suggesting that I should get all categories and all subcategories returned to my list if I use that formula?

Thanks!
0
 
LVL 10

Accepted Solution

by:
zvonko earned 400 total points
ID: 6956796
Hello,

this your last comment does not match to the first line of your question. In this last comment you have not loose one word about the fact that this main and sub categories are all in the same (in the first) column.

And when you request the first column in your @DbColumn command then you get the first column. Full stop.

Now what do you like to get back?

If you like to get: "MainCategory1/SubCategory1"
then create a new view as Hemanth sugested where this first column is sorted (categorized is not important because of the @Unique function afterwards) and composed with this forward slashes.

If you like to get a list of all categories as single elements, then you have not to do anything. As I mentioned in my first comment: this is the default behavior.

If you simply disable the Categorized option for this first column and let it be Ascending sorted, then you will get: "MainCategory1\SubCategory1"
back as elements.

So, what is your need?



0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 6958209
If that is what you are looking then you have to alter your formula and build a hidden view without category on categories column

The formula goes like this
t := @Unique(@DbColumn("":"nocache"; ""; "By Category"; 1))
t : @Left(t;"\\")

0
 

Author Comment

by:sauce12
ID: 6958403
Thanks for the ideas.  I'll play around with it tomorrow morning.  Hemanth - do I need to declare t in the example above.  If so as what?  Thanks.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 6959858
It is just a temp variable in formula.
0
 

Author Comment

by:sauce12
ID: 6960484
Basically, I just needed sort the first column of my view alphabetically instead of making it categorized.  I didn't know that this affected the dbcolumn funtion.  Thanks!
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6961121
Thank you for the points :-)
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
Suggested Courses

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question