Hi,
I have a view where I am in the process of implementing 'filtering by column value', and using a vector based on 4 values.
The view has 30,000 documents.
Initial question:
Which would be more efficient - implementing this or doing a search in the view instead? I know that the search is typically inefficient, however am not sure how efficient the filtering by column value is.
Problem:
Using the filtering option, I have found that where I have a null value (depending on what I am selecting in the drop downs for filtering), it does not return most entries it should. So, for example, depending on the circumstances I want it to return all values in column 1, and then only the specific values in column 2.
To do this, I use:
var vtr:java.util.Vector = new java.util.Vector();
var t1 = sessionScope.Own;
var t2 = sessionScope.Module;
@If(sessionScope.Own=="None",vtr.addElement(""),vtr.addElement(t1));
vtr.addElement(t2);
return vtr;
The issue, I think, I am having is that the first value is not set as an empty search string. The reason I think this is I have a computed value with the same logic, and it does not start with a nothing (eg I should get ',Tanks', where I actually get 'Tanks'). If I do this in reverse then it is fine - however I need it to work in both directions. Is this is syntax issue?
And then... in case I am not asking too much already, I want to be ale to sort. That breaks the view?
Any words of wisdom?