The source contains no data rows

datatable
selector
studio
error

#1

Hi !
I’m making this select -

[Net Revenue]>'0' and [Customer] NOT LIKE '' and [WBS Element] NOT LIKE '%40PO%' and [Profit Center] NOT LIKE '%P403542%' and [Profit Center] NOT LIKE '%P403541%' and [Profit Center] NOT LIKE '%P403468%' and [Profit Center] NOT LIKE '%P403469%' and [Profit Center] NOT LIKE '%P403148%' and [Profit Center] NOT LIKE '%P403470%'

And this works. But when I use this select -

[Net Revenue]>'0' and [Customer] NOT LIKE '' and [WBS Element] NOT LIKE '' and [Profit Center] LIKE '%P403542%' and [Profit Center] LIKE '%P403541%' and [Profit Center] LIKE '%P403468%' and [Profit Center] LIKE '%P403469%' and [Profit Center] LIKE '%P403148%' and [Profit Center] LIKE '%P403470%'

I get this error (img):
frm

Does this even make sense?? Why am I gettin this error??


#2

Is there any data present in that datatable with the select query you are using.

Regards,
I$


#3

Yes it is. I’ve already tryed to apply the filters my self by hand and it has data.


#5

Hi. I’ve been workin’ on a workaround and I’ve already conquered the solution. I’ve tryed the opposite using ‘NOT LIKE’ for the values I don’t want to appear. instead of ‘LIKE’ for the values I want to appear. It worked. Thank y’all and sorry for wasting your time!