View Selection

HCL Domino Domino Forum
1

Hi

View selection query…i have a view, first column of this view is coming from a field which allows multiple values…i.e HR manager, IT manager, Services Manager…

I have a view that is set up to show only HR managers

I have second view that is set up to show all other managers…in this second view i want to exclude HR managers from this view…

Example one such manager is both HR manager and IT Manager…

in my second view i want a category for IT managers but want to exclude HR manager category

any suggestions greatly appreciated…

2

Subject: View Selection

Hi In the selection formula of second view you can add below formula :

@IsNotMember(fieldname;"HR manager)

I think this will work…

3

Subject: RE: View Selection

Hi Ashutosh

thanks for your response…yes i tried that formula @IsNotMember(fieldname;"HR manager)…but this does remove the HR manager from the view which is correct but it also removes those that are both IT managers and HR managers…

i want it to remove the HR manager category but to leave the IT Manager…

it is thrown out by those managers that are both IT manager and HR manager etc…

4

Subject: RE: View Selection

You’ll need to do two things.

1 - Exclude all records where the user is ONLY an HR Manager

2 - When they are a HR Manager and another role, you’ll need to remove the HR Manager information from the column

i.e.  @Trim( @Replace( fieldname; "HR manager"; "" ) )

Like wise, for the view you only want to see HR Managers…

1 - Exclude all records where the user is NOT an HR Manager

2 - When they are a HR Manager and another role, you’ll need to remove the other role information from the column

i.e.  

non_HR := @Replace( fieldname; "HR manager"; "" ) ;

@Trim(@Replace( fieldname; non_HR ; "" ))



The first line will create a list with the HR Manager role replaced with a "".

The second line will use that list to replace all non-HR values in the original list with a "", then remove them with Trim.
5

Subject: RE: View Selection

You need more than a view selection formula, then – you also need to use a formula for the category column in the view. Your view selection formula would look something like this:

SELECT Form=“FormName” & !(@Trim(@Replace(FieldName; “HR Manager”; “”)) = “”)

Your column formula would be

@Trim(@Replace(FieldName; “HR Manager”; “”))

6

Subject: RE: View Selection

thank you both for your help. works perfect

7

Subject: RE: View Selection

Joe, I have to ask…

Why did you go back to all your old threads and delete your content?

Someone in the future might have a similar problem as you and the attempted posted answers might be the right solution for them. Now the context is lost with your blank messages. Also, I was using it to try and understand why the previous answers we’re the right one for you.

Just a thought.