No NOT NULL option on FetchEntitiesStep?

Unknown

No NOT NULL option on FetchEntitiesStep?

Unknown

On a FetchEntitiesStep how do we make one of the criteria under inputs: and Fieldname NOT NULL?

There is only an option for NULL in the dropdown.

Unknown

Hi,

There should be a selection for IsNotNull when setting up the fetch entities step. You can find this option under Field1 Type field. If you do not see this option, please let me know what version you are on.

Thank you.

Unknown

Not sure if it’s because it’s a date field but these are our only options.

Unknown

Hi,
When you set up what fields you want to filter by, there should be a drop down underneath called Field Type. By default this is set to Equals. You can change this to IsNotNull.
Thank you.

Unknown

Hi,

You can use _CallableByDate twice in your case because one of your settings (IsNotNull) doesnt require an input. However, you would not be able to use two criteria for the same field that both require an input (such as greater than and less than). Im putting in a feature request to get this changed.

If you need to have more than five criteria there are a couple of options.
1) These easiest option is to create a new access pattern for your entity. You do this in the configuration folder. There is an option to define a new access pattern. You can select what fields you want as your criteria. The downside to this option is that option for how you search applies to all fields. For example you cannot specify Equals for one fields and Less Than for another. I am submitting a dev request for this as well.

2) You can write a custom query with as many parameters as you want. The downside to this option is that you will need to build a converter flow to convert between the query output and the entity type.

Regards.