Solved

Displaying SubCategories in a categories field

Posted on 2002-04-19
12
251 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
 

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 10

Accepted Solution

by:
zvonko earned 100 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
LOtus Notes 6.5 low performance 13 36
VBA Lotus notes 2 195
Domino Server 11 65
Domino Website - Redirection 12 50
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now