Issues When Filter is Left Blank

[calexander]

Hello, I have an issue where using the built-in filters toolbar for a grid with active paging, leaving the filter field empty and then pressing Apply can end up searching using the previously non-blank applied filter value. If you set up a filter program (the one that includes QCpyleSrc,vvNabFlt) and use GetFilterValue it will return the last applied value that was not blank rather than the expected blank. The filter can look like it worked fine at first, but if you click the refresh or next page button of the grid, it will then filter as if the value was not blank.

Tested with version 6.3.20250923.0

Data Source:

SELECT
  spooled_file_name,
  job_user,
  spooled_file_number,
  status,
  creation_timestamp,
  size,
  total_pages,
  qualified_job_name,
  form_type,
  output_queue_library,
  output_queue
FROM
  TABLE(
    qsys2.spooled_file_info(
      user_name => ifnull(
        nullif(vvin_virtual('fUser', '*ALL', 'char', 10), ''),
        '*ALL'
      )
    )
  )
WHERE
  (status <> 'DELETED')?

image.png?image.png?

[Johnny Major]

Thanks for the information. This will be fixed in the next 6.3 update.