×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Show Single Category

Show Single Category

Show Single Category

(OP)
Does anyone know how to only access a subcategorie?

e.g. I have theese categories:
Software
Software\Applications
Software\OS
Hardware

When I enter "Software" in the formula for SSC i see all documents that are in Software or in any subcategory of Software. thats great.

But what to enter to only see documents that are in Software\Applications and below?

because "Software\Applications" or something like this gives me the same result like "Software"

Regards

Stephan Hofmann

RE: Show Single Category

I think we might need some additional information here.

Are you trying to display the categories and sub categories in a listbox in a document or are you trying to filter a view using a selection formula?

If you can give us some additional information and some examples of formulas you are trying to get working it will help greatly in getting an understanding of what you are trying to do.

Cheers!

RE: Show Single Category

(OP)
Ok i want to build a documentDB with a tricky categorisation: it's like normal categorisation with one little difference when u are in top level of all categories you should see all documents and when you navigate in the categories the number of documents degreeses. do you got my point?

on S  you see all documents in any level under S
all documents under S\A are to bee seen too

on S\A you see all documents in any level under S\A

and that should work with multiple levels

I'm now on a point to say "It wouldn't work" because SSC only work with one level of categorization.....

so now I'm working on displaying it with a search...

Regards

Stephan Hofmann

RE: Show Single Category

You need another view with categoy grouping main and sub category (eg. key is SoftwareApplications).
That way, when you choose to view by main category, you get the first view, then when going down you switch to the new view and apply the more complex key.

Pascal.

RE: Show Single Category

(OP)
But this would mean when i have 4 levels of subcategories i need 4 fields, or did i get you wrong?

Stephan

RE: Show Single Category

You'll need 4 views, but not 4 fields. The formula in the field needs to know what subcategory level you are at.
That should not prove too difficult.

Pascal.

RE: Show Single Category

(OP)
Now I understand what you mean
the problem is that the specification sais that there is no limit on categorie level........

so i will search in an other direction

but thanks for your consultant

regards

Stephan Hofmann

RE: Show Single Category

(OP)
I wanted to give your proposal a try.
i craetat the views
in a form i wanted to embed the views.

so at "embedded view" --> "embedded selection"
i wanted to insert:

test:=Eingabe
@if(
!@contains(test;"\\");"Kat0";
!@contains(@ReplaceSubstring(test; @Left(test;"\\")+"\\";@Left(test;"\\"));"\\");"Kat1";
!@contains(@ReplaceSubstring(@ReplaceSubstring(test; @Left(test;"\\")+"\\";@Left(test;"\\")); @Left(@ReplaceSubstring(test; @Left(test;"\\")+"\\";@Left(test;"\\"));"\\")+"\\";@Left(@ReplaceSubstring(test; @Left(test;"\\")+"\\";@Left(test;"\\"));"\\"));"\\");"Kat2";
NULL)

Kat0 to Kat2 are the different views
test holds the value of the listbox above the embedded vie

the if close is:
is there no "\" then kat0
when i take one "\" away and ther is no more "\" then Kat1
and so on...
i littlebit tricky but it should work

but every time i refresh the object in the programmers panel f***** Domino Designer erases this formula

is it my fault?

or where should i decide which view to take

regards

Stephan Hofmann

RE: Show Single Category

I would use a field to calculate the name of the view and another to set the name of the category.
The embedded view should just call the two fields, and you're done.

RE: Show Single Category

(OP)
How can I call the fields? In the selection formula? how?

Regards

Stephan Hofmann

RE: Show Single Category

Yes, the selection formula will use the name of the field holding the view name, and the Show Single Category section will just need the name of the field holding the resulting subcategory you want to show.

RE: Show Single Category

(OP)
Sorry, I don't get your idea.


Regards


Stephan Hofmann

RE: Show Single Category

You have a field with a formula for determining the name of the view you need to use. Lets call that field EmbedViewName.
Another field should contain the formula defining the criteria to use for selecting the type of documents to be displayed in the view. Lets call that field DocCat.
Once you have inserted those fields, you just go to the Embedded View Properties and input EmbedViewName as name of view to use, and DocCat as Category.
In that manner, refreshing the field values should update the embedded view and the documents displayed.

Pascal.

RE: Show Single Category

(OP)
Wow It works!!

Thank you so much for your help and patience, Pascal.

What had I done without you.


Regards


Stephan Hofmann

RE: Show Single Category

Glad to be of help, Stephan.

Pascal.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close