Solved

Displaying SubCategories in a categories field

Posted on 2002-04-19
12
254 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
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…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

733 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