Filter in Lookup to only view items that are blank
Hi There,
I'm using a Lookup to reach out to a Data Entity. Works great, but when I add a Filter condition that says Column X = Blank, it's not pulling back any results. The inverse works: Column X != Blank, but I can't get this to work.
Typically just leaving the textbox empty would signify Blank, but I'm wondering if there's a different syntax that I need to use. Any help would be appreciated.
Thanks,
Casey
-
That's exactly what I mean. It won't work for me when I try to use that as a condition. I'm trying to pull back all values from my Data Entity into a data grid where Column X is empty, and again, the inverse works, but I can't find a syntax that allows me to check for blanks. I would have expected to either just leave the right side of the condition blank, or use '' or "" to get the job done but neither seems to work.
Thoughts? Loren Bratzler thank you
-
I have not done anything yet with AgilePoint Data Entities but I have done a lot of lookups against other SQL tables. When dealing with something like this in a SQL table, you need to know if the blank values in the column are actually blanks (spaces) or if the field is NULL. Maybe something like this might work:
select *
from Table_X
where Column_X is null OR Column_X <= ' ' -
Thanks Gwen! I really appreciate all the help. It's unfortunately not a dropdown, it's just a text field both in the Source and on the Form, so that didn't work either.
I have done a workaround where I just make sure that all of the data in the entity is filled out with a basic _ and it doesn't look too bad, and then my filter has a value to search against to avoid the blank.
It just seemed odd to me that the Quick Config options in a lookup don't have an "is blank" or "is null" or "is empty"
Also very much wish I could do the Advanced Config/Query for a data entity, but I can "fake" it with an On-Premises version and just use the actual SQL tables on the backend instead of using the Data Entity in the traditional sense, since the Data Entity is just another table in the SQL schema behind the scenes. More difficult to do in the Cloud versions, but yeah, I've got a workaround for now.
Thank you all for your inputs.
Please sign in to leave a comment.
Comments
9 comments