AnsweredAssumed Answered

Relationships Graph Query Not working As Expected

Question asked by onepercenttheory on Feb 4, 2019
Latest reply on Feb 4, 2019 by onepercenttheory



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!