Skip to Content
0

entries not reflecting in the table while filtering in multiple selection option.

Dec 20, 2016 at 01:13 PM

26

avatar image

Hello,

We have added the field ZZCT_ITEM_VDATE in the end of the structure CI_EKPODB but the structure is in the middle of the EKPO table Total number of entries in the table are 4733.

But when we place a filter on the field ZZCT_ITEM_VDATE with Not Equal blank, we could get number of entries as 5 which is correct

But when we place filter as Equal to blank it shows number of entries as 336

But it should be total number of entries in the table minus the 5 records for which the field value is not equal to blank.

can any one help on this clarification

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Raymond Giuseppi
Dec 20, 2016 at 01:29 PM
2

Look at table definition (EKPO) depending on your database, the value of the field for records existing before the append may be "null" and not "initial".

  • Open SQL - Null Values, Null values can still arise in database tables if the new columns are appended)
  • SELECT - WHERE, The logical expression sql_cond is either true, false, or unknown. The expression is unknown if one of the columns involved in the database contains a null value and is evaluated with another comparison as IS NULL. A row is only included in the results set if the logical expression is true.

Regards,
Raymond

Share
10 |10000 characters needed characters left characters exceeded