10
Views
3
Comments
Solved
Aggregate not returning result but search value input exist in db
Question
Application Type
Reactive
Service Studio Version
11.8.11 (Build 31184)
Platform Version
11.5.0 (Build 280)

This is kinda funny but bordering insane situation.

I have a table with only 1 record with email="xxx@gmail.com" and say the filter I used is email="xxx@gmail.com".

I can see this record when I view the data but in an aggregate, using filter email="xxx@gmail.com", it's returning zero row! 

Note:

  • I tried switching the input parameter data type to text or to email but doesn't work. 
  • Tried Trim to see if spaces is the issue but doesn't work.
  • Testing it with manual SQL indeed confirm i can't find this record using that email key but I know it's there.

This is driving me nuts.

Rank: #23763
Solution

Hi Rui,

I'm really embarassed now. Minutes after i posted it, i found the problem. The record in the db is missing a character "xx" instead of "xxx" hence the zero results when I try to query with "xxx".

All good now. It was a PEBCAC issue ...

Rank: #94

Hello Wai,

Hope you're doing well.

Can you share your OML or create a new one with an example of this situation? :)


Kind regards,

Rui Barradas

Rank: #23763
Solution

Hi Rui,

I'm really embarassed now. Minutes after i posted it, i found the problem. The record in the db is missing a character "xx" instead of "xxx" hence the zero results when I try to query with "xxx".

All good now. It was a PEBCAC issue ...