2 Replies Latest reply: Jun 28, 2011 1:22 AM by Ravi Achaliya RSS

    Count the record if a partial string match is found

    Yogalakshmi Narayanasamy

      Hi All,

       

      I have a Customer table with the list of Most valuable customers

      Table Customer:

      Mike Freeman,

      Ian king,

      Juan Sant

      ...

      and a call log table

      Table Call log:

      Customer Name          Notes                              Timereported    

      Mike Freeman pv_     Issue with the product     1/1/2011 1.23 AM

      Ian king                         Mike Freeman is the       1/1/2011 1.25 AM

                                            main account person .

                                             returing the product as               

                                          it was part of the main package   

      Juan Sant           Not happy with the product          1/1/2011 1:26 AM

       

      i want to create a chart that shows

      the customer name with the number of incidents reported and also the actual incident reported

       

      like

       

      Customer Name     No of incidents     Notes

      Mike Freeman     2          issue with the product

                                              mike freeman is the main account person

       

      Ian King               1          mike freeman is the main account

       

      Juan Sant          1          Not happy with the product

       

      Customer Name in the call table migh have some junk characters with the customer name also in the notes section the customer name might appear anywhere.

       

      I tried exists() but that doesnt seem working.