I have a view where the first column can have multiple values and are shown as multiple entries.
Let’s say the document has “June”, “July”, and “August” as a multi-value field (“June”: “July”: “August”). When the view shows the document it shows up as three entries, which I expect.
What I want to do in this view is only show entries with “June” and/or “July”, but not show “August”. I have tried, in the view selection formula, something like:
SELECT Column1 = “June” | Column1 = “July”
where “Column1” is the variable name given to column heading.
The problem is Column1 is still listed with all three values (June,July,August) so this returns nothing, instead of two entries.
Any ideas on how I would tackle this would be appreciated.
-Darren
Subject: Select Statement and Column formulas.
update your column formula to display the values you want,
What is the criteria you are using to decide what values will show
if a document is selected by the selection formula then the values of that field will display in the column unless you filter that.
Subject: Select Statement and Column formulas.
The principle to remember is that the selection formula either selects a document to be displayed in a view OR not displayed in a view. It is a binary choice - i.e. the document is included or NOT included. Since you obviously want this document to be included then the selection formula is NOT the place to look for the answer.
Instead, look at the categorised column for the answer. You would have to program it to exclude August. For example, you could have a formula that says:
@trim(@Replace(Fieldname; “June” : “July” : “”))
In other words, remove “August” from the list. Then the document won’t display under the August category.
Hope this helps.
Tom McCann
MIS Consulting
www.mis-consulting.co.uk
Subject: RE: Select Statement and Column formulas.
Thanks. This worked, although it was reverse. I needed to list all things I didn’t want to see, so it looked like:@Trim(@Replace; “August”; “”))
This would take the value of August and replace it with “”.
-Darren