View Selection formula

HCL Domino Domino Forum
1

Hi All

There is a View which having 2 Field :- City and Username(n number of user)

now there is another view named YourDocument in which these user can see there data.

now how i can use a selection formula that can shown all the docuement to those all person which having the same city.

eg :-

cityprofile view cantain :-

City Name userlist

Newyork abc,cde,xyz

London pqr,lmn,gft

now YourDocument View:-

    City Name

-,-,-, Newyork ,-,-,-,

-,-,-, Newyork ,-,-,-,

-,-,-, Newyork ,-,-,-,

Now these Document can be visible to abc,cde,xyz

users…

Plz Advice…

Waiting for your response.

Thanks

2

Subject: View Selection formula

Hi Yogesh,

If you know the correct number of Separators then you as use @word(“fieldname”,“-”,number) see syntax in help.

if you dont know the separetors then use @Contains( string ; substring ) .

Use according to the requirement

cheers

RAJ

3

Subject: RE: View Selection formula

i Solve that issue now i use following view Selection Formula

SELECT (Form=“Test”) & @IsMember(dlSite;@Explode(“abc”;“,”))

dlsite is the nale of the variable which cantain the site name. That variable can have more 2 site name with , seprator.

which can be solve by using @explode() formula.

Thanks to all of You.

4

Subject: View Selection formula

I think you should use an embedded view with show single category.

Have a look at the designer’s help.