Empty rows appear in List

405
2
04-13-2022 07:37 AM
PaulHallett1305
Occasional Contributor

Hi, I use a data expression to create the table I use in a list.  However, empty rows appear in the data.  The query is quite a long one, but, explicitly, the filter states it can not have empty rows.

Data is fine and formatted in all the other rows, but these empty ones keep appearing.

Any idea how to get rid of them?

Screenshot 2022-04-13 at 15.36.44.png

Tags (3)
0 Kudos
2 Replies
jcarlson
MVP Esteemed Contributor

Can you give an example of the data? Is the data filter acting against the same field that's being displayed in the list?

AB
1 
 5
2 

 

If I filter for "A is not null", but am displaying B in my list, it will look empty.

- Josh Carlson
Kendall County GIS
0 Kudos
PaulHallett1305
Occasional Contributor

Hi Josh

Basically, the filter is

Select * from table where cola = 1

or colb = 1

or colb = 3

or colc = 4

I would expect all 3 rows to return

 

1  
1 4
 3 


But with below, I would only exlect 1 row returned

   

1

  
   

 


But I get all 3

0 Kudos