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

Relationships_query.png

 

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!

Outcomes