ephilippon

Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Author
    Replies
  • in reply to: Filter on empty cells #93386
    ephilippon
    Participant

    Hi,

    Thanks for your reply.

    Actually, I don't have any more this problem for varchar. This is how I fixed it for varchar columns:

    – modify the database columns' default to '' instead of NULL (doesn't work on text type)

    alter table

    alter column set Default ''

    – modify all values of all columns that contain a NULL value, and set it to the new default's one

    update

    set = '' where IS NULL

    – insert a space in the filter's entry, and press enter to get the results.

    Now, the filter is ok for selectable values (I added a ; :Nothing in the values list), for text and for varchar values. I still can't perform this kind of search on dates (all cells that don't contain dates).

    ps1 :

    in reply to: Filter on empty cells #93297
    ephilippon
    Participant

    Hi,

    I found out how to do this with columns containing values in a selected list (by introducing a value ” : ” in the list), but I still can't figure out how to do this for editable fields. I've tried to do a search on all elements that contains a caracter (#column,#contain,%), and then to display all elements that don't match with this pattern, but I get all rows…

    Do you have any idea on how to perform this kind of search? Is it a bug in my implementation of the grid, or a grid problem?

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)

Stay connected with us in your favorite flavor!