0
votes

good day,

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

1
What have you already tried? Please add some more info. For info: here's the online help: publib.boulder.ibm.com/infocenter/domhelp/v8r0/…Per Henrik Lausten
all i tried, i get error and no value.LyodMichael

1 Answers

3
votes

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