Hi all, I'm trying to create a query that displays the number of times that we have either texted or called someone. I created a QUERY MATCH FIELD with the value of 1, set as a numeric. I also created a calculation that follows this idea:
If ( PatternCount ( Lower ( Activity ) ; "baseline text" ) > 0; 1 ; 0 ), with the result being a numeric value.
However, anytime I restart the database all fo the summaryCount fields (in the log) that I'm depending on for this query relationship to work show the value of 0. I basically have to rebuild it and then it magically works, which isn't ideal at all.
Can anyone shed some light on what I'm doing wrong here or how I can make this work better? Thanks!