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!

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

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.

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

Stephan

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.

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

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

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.

How can I call the fields? In the selection formula? how?

Regards

Stephan Hofmann

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.

Sorry, I don't get your idea.


Regards


Stephan Hofmann

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.

Wow It works!!

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

What had I done without you.


Regards


Stephan Hofmann

Glad to be of help, Stephan.

Pascal.