CODEWITHSUNDEEP
lotus-noteslotus-dominolotuslotusscriptlotus-formula
LyodMichael
LyodMichael

Reputation: 85

Filtering view in lotus notes

good day,

I'm trying to filter date by year using @setviewinfo. can anyone tell me how?

Upvotes: 0

Views: 5291

Answers (1)

Dmytro Pastovenskyi
Dmytro Pastovenskyi

Reputation: 5419

Here is an example, put this formula on PostOpen event on view. It will filter all document by column with user name.

@SetViewInfo([SetViewFilter]; @UserName; "columnName"; 1; 1)

columnName - is a real name of column (you may set it in Column Property)

Remember to clean filter on QueryClose even on view, otherwise all view will use this filter.

example how u should remove filter

@SetTargetFrame("frameName");
@UpdateFormulaContext;
@Command([OpenView]; @Subset(@ViewTitle; -1));
@SetViewInfo([SetViewFilter]; ""; "columnName"; 1)

frameName is a frame that contains view, columnName is your categorized column. If you do not use frame - simply skip 1-st row

Upvotes: 3

Related Questions