is year_status defined in participation?
So you need to have your partial text match AND the year_Status must have the text: "current"?
PatternCount ( Participation2::TextField ; Searchfield ) AND
Paticipation2::year_status = "Current"
year_status is not currently defined in Participation but I will set that up.
What is the correct way (or best way)?
Should I set participation::year_status as a calc field - If (part_YEAR::year_status = "current" ; "" )
Should I set it up in the relationship between the TOs?
Participation2::year_id = part_YEAR::year_ID
Participation2::year_status = part_YEAR::year_status
My portal filter says the result must be boolean. Of the many AND combinations I've tried, most of them haven't worked or hidden ALL the portal records.
This is a novice question but I have to ask: Does participation2::year_status = "current" return a boolean result or a text result?
I have tried many more combinations based on participation2::year_status = "current" but the portal still isn't filtering those records.
I currently have participation2::year_status setup as Auto Enter Calc where that field equals part_YEAR::year_status.
Participation2::year_status is pulling the appropriate text 'status' but the filter isn't removing those records.
I think I am missing something very obvious but I'm being blinded by the endless combination of methods I've tried.
(this was supposed to be an quick & easy filter but I'm on day 3....)
Why does this filter expression cause no records to be visible in the portal?
Participation 2::year_status = "current" & IsEmpty ( Participation::gSearchText) or PatternCount ( part_CONTACT 2::name_alphabetical ; Participation::gSearchText )
Why does this filter expression not filter out those records whose year_status is any but "current"?
IsEmpty ( Participation::gSearchText) or PatternCount ( part_CONTACT 2::name_alphabetical ; Participation::gSearchText ) & Participation 2::year_status = "current"
You aren't using And in your calculation expression. You are using &--the concatentation operator.
Use the word AND to get a boolean And in your expression.
You should not need to add the calculation field to participation2 for this to work. Given the relationship, you should be able to refer to the field in the related table in your filter calculation.
But It's really not clear to me how you are using that addditional table, it seems an unecessary table from what little I understand about your solution from these posts.
Thank you for the responses. I am still at a loss on this. I changed '&' to 'AND' but no change in the result(s).
I'm attaching a few screen shots that will hopefully shed some more insight into my problem.
Just tried negating(bypassing) the entire Year Table altogether.
I set a simple text field, Participation::year, to represent a 4 digit year (ie, 2014).
Then I filtered portal by:
IsEmpty ( Participation::gSearchText) or PatternCount ( part_CONTACT 2::name_alphabetical ; Participation::gSearchText ) and Participation 2::year = "2014"
Records with participation2::year set to 2013 are still visible in the portal.
I am baffled.
I moved participation2::year to before the IsEmpty and its now working properly IF I bypass the Year Table.
Still working but may settle for this...