Is there a way to set up a query entity to filter on fields that are an empty st

This may require applying a second filter on the FIELDNAME column of the retrieved datasubset to perform a length check. As to the issue where the db stores nulls as empty strings - this has been reported to Engineering (Reference no. AN-45612)

Hi jason!
If you run a null check by using isnull("") , it will run correctly. However for more functionality, you have to make a utility rule for cases where isnull might fail. You can make a rule named "CheckIsNull" with the following syntax:

if(ri!List ="",true(),if(isnull(ri!List),true(),if(length(ri!List) > 0,false(),true())))

where "List" is of Any type.

Abhi, how can I use a!queryFilter() to check length? I don't see any operators that work with length of a field.

I meant that this would be a two step process -

1. Store data from query into a local variable
2. Filter the datasubset

Here's an example -

load (
local!queryData: rule!getAllEmployees(),
a!formLayout(
label: "Null filter test",
firstColumnContents: {
a!textField(
label: "All data",
value: local!queryData,
readOnly: true()
),
a!textField(
label: "Filtered data",
value: index(local!queryData, where(len(local!queryData.name)>1), {}),
readOnly: true()
),
}
)
)

Jason, in cases like yours, we've resorted to having the database do the null check (or length check, as Abhi suggests) by creating a view. Then you can just add a filter on that new boolean column from the view.

The following seems to work in the query filter from what I can tell
operator: "not in",
value:{""}

Thanks for the tip, Jarrod.

hi jarrods229 ,

I should not display particular row in my grid column if the value is  empty/ null . I tried giving this value but still the empty cell is displayed  , Please suggest.

a!gridColumn(
label: text(date(year(today()), 1, 1), "mmm yyyy"),
value:if(a!isNotNullOrEmpty(fv!row.TeamMemberValue),rule!myrule_DisplayCell(
CellValue: fv!row.TeamMemberValue
),""),
showwhen: if( and(a!isNotNullOrEmpty(fv!row.TeamMemberValue),contains(local!Month,"1")),true,false),
),

Thanks,

Priyanka

Hey Priyanka -

There are a couple different issues with your response here...

1. this thread is over 7 years old, including the comment you're replying to
2. the comment you're replying to has nothing to do with the issue you're asking about - it probably would've been better to just create your own original post for this

Per your question: you're asking about the "showWhen" parameter on the a!gridColumn() component.  For a column, you can't use fv!row data to show/hide the column, because for any given column, it'll always be shown/hidden regardless of individual row data.  In fact, the fv!row data is not even accessible from the showWhen parameter, for this reason. 

In a grid, you can't have some rows "show" a certain column and other rows "hide" it - that wouldn't really even be a grid at that point.  The best you can do is show an empty value in that column for that row (which you already seem to be doing), or decide to hide the entire column based on some external factor that you use on-form logic to calculate in advance.