You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Delete where column is NULL returning 0 rows

posted two days ago

I have an issue where auto complete rules are called the moment a form loads even when the user has not clicked the auto complete button. The rule allows empty values to be passed which end up populating an empty table row. No way to require a value in a rule.

So I created a second rule to delete these empty rows that way the table is accurate.

But it keeps returning 0 rows.

I know the value is null because the customer field is empty on load and I can open the table and use my mouse to highlight and make sure there is no space or characters in the field value.

Nothing highlights under the customer data when I do this confirming the value is empty.

0 0
replied one day ago Show version history

NULL != "". You could try leaving it blank instead of NULL, or accounting for both if that is possible since I'm not familiar with this interface.

0 0
replied one day ago Show version history

This might be true in SQL language, but not in Laserfiche language. In SQL language it is possible to have a value with no characters that is an empty string but not null. However in Laserfiche language it would be null as there is no such allowance for using empty strings in your queries.

For example is empty is not an option when defining LF Rules.

And they do not allow such an expression as = ""

In Laserfiche lookup rules, the concept of blank does not exist.

0 0
replied one day ago

Interesting. Is it possible to run the query as a stored procedure instead? If so, you can account for this in the SP.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.