Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 20, 2016 at 01:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded