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
-
can you upload a sample db?
-
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) = 1I'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.
Content aside
- 11 mths agoLast active
- 3Replies
- 38Views
-
2
Following