0

Bizarre Results from Filtered Records

Ok, this has never happened to me before and is only occurring with one field.  I have a simple choice field called 'Reason'.  However, when filtering results by choice ID #, it is not pulling the correct records.  Doing a simple formula in the console

select Leads where Reason=1

Is pulling records that have different reasons or no reasons at all.  I can't even begin to understand what is happening here.

3 replies

null
    • Fred
    • 1 mth ago
    • Reported - view

    can you upload a sample db?

      • Dave_Irving
      • 1 mth ago
      • Reported - view

      Can I throw you on as a collab real quick?

    • Fred
    • 1 mth ago
    • Reported - view

    Reason is a multi choice field, so try putting numbers() around Reason.

    I created a field that did your code and got back these two records, plus a whole lot more:

    4, 30,

    Record 4 does not seem to match the requirements. But if you put numbers() around Reason then 4 disappears.

    select Leads where numbers(Reason) = 1

    I'm not sure if you use Reason as a multi choice or not but if you do then you will have to use the contains() function to do a proper filter of results.

    On a side note, I noticed that your dashboard takes about 8 seconds to load. You may want to consider linking your Reports and Dashboard tables to your Leads or Chronos tables directly so you can stop doing all those selects.

Login to reply

Content aside

  • 1 mth agoLast active
  • 3Replies
  • 36Views
  • 2 Following