Solved

Displaying SubCategories in a categories field

Posted on 2002-04-19
12
250 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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
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…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

758 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