Show Single Category 1

• Sep 3, 2003

• #2

ABOzIT

IS-IT--Management

May 1, 2003

226

JP

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!

 

Upvote 0 Downvote

• Sep 3, 2003

• Thread starter
• #3

DerStephan

Programmer

Aug 19, 2003

54

DE

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

 

Upvote 0 Downvote

• Sep 4, 2003

1
• #4

pmonett

Programmer

Sep 5, 2002

2,636

FR

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.

 

Upvote 0 Downvote

• Sep 4, 2003

• Thread starter
• #5

DerStephan

Programmer

Aug 19, 2003

54

DE

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

Stephan

 

Upvote 0 Downvote

• Sep 4, 2003

• #6

pmonett

Programmer

Sep 5, 2002

2,636

FR

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.

 

Upvote 0 Downvote

• Sep 4, 2003

• Thread starter
• #7

DerStephan

Programmer

Aug 19, 2003

54

DE

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

 

Upvote 0 Downvote

• Sep 5, 2003

• Thread starter
• #8

DerStephan

Programmer

Aug 19, 2003

54

DE

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;"\\&quot+"\\";@Left(test;"\\&quot);"\\""Kat1";
!@contains(@ReplaceSubstring(@ReplaceSubstring(test; @Left(test;"\\&quot+"\\";@Left(test;"\\&quot); @Left(@ReplaceSubstring(test; @Left(test;"\\&quot+"\\";@Left(test;"\\&quot);"\\&quot+"\\";@Left(@ReplaceSubstring(test; @Left(test;"\\&quot+"\\";@Left(test;"\\&quot);"\\&quot);"\\""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

 

Upvote 0 Downvote

• Sep 5, 2003

• #9

pmonett

Programmer

Sep 5, 2002

2,636

FR

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.

 

Upvote 0 Downvote

• Sep 5, 2003

• Thread starter
• #10

DerStephan

Programmer

Aug 19, 2003

54

DE

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

Regards

Stephan Hofmann

 

Upvote 0 Downvote

• Sep 7, 2003

• #11

pmonett

Programmer

Sep 5, 2002

2,636

FR

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.

 

Upvote 0 Downvote

• Sep 17, 2003

• Thread starter
• #12

DerStephan

Programmer

Aug 19, 2003

54

DE

Sorry, I don't get your idea.


Regards


Stephan Hofmann

 

Upvote 0 Downvote

• Sep 17, 2003

• #13

pmonett

Programmer

Sep 5, 2002

2,636

FR

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.

 

Upvote 0 Downvote

• Sep 18, 2003

• Thread starter
• #14

DerStephan

Programmer

Aug 19, 2003

54

DE

Wow It works!!

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

What had I done without you.


Regards


Stephan Hofmann

 

Upvote 0 Downvote

• Sep 18, 2003

• #15

pmonett

Programmer

Sep 5, 2002

2,636

FR

Glad to be of help, Stephan.

Pascal.

 

Upvote 0 Downvote