What were you trying to do that didn't work?

ca-cert-request-find does not producing expected output with option --status.
Failed in automated regression pipeline "https://idm-artifacts.psi.redhat.com/idm-ci/dogtag/Signoff-Tier2-shared/RHEL9.4/2024-02-05_10-01/tier-2-shared/topo-01-ca_certs/1/pki_cert_report.html?sort=result"

Please provide the package NVR for which bug is seen:

RHEL 9.4

idm-pki-server-11.5.0-0.1.alpha8.el9.noarch
idm-pki-ca-11.5.0-0.1.alpha8.el9.noarch
idm-pki-kra-11.5.0-0.1.alpha8.el9.noarch

How reproducible:

Always

Steps to reproduce

1. Install CA subsystem on RHEL 9.4 machine
2. Have some random cert request with different status in the CA
3. run ca-cert-request-find command with option --status pending

Expected results

Command should show certificate request with only status pending

Actual results

Command is producing certificate requests with all the statuses (pending, complete, cancelled)

Console output of the command : [root@pki1 ~]# pki -d /opt/pki/certdb/ -n 'PKI CA Administrator for Example.Org' -c SECret.123 -p 20443 ca-cert-request-find --status pending
WARNING: BAD_CERT_DOMAIN encountered on 'CN=pki1.example.com,OU=topology-02-CA,O=topology-02_Foobarmaster.org' indicates a common-name mismatch
------------------
91 entries matched
------------------
Request ID: 0x2f1b89cfcb9fe270f8aa96c70f81da3
Type: enrollment
Request Status: pending
Operation Result: success
Creation Time: Thu Feb 08 05:11:54 EST 2024
Modification Time: Thu Feb 08 05:11:54 EST 2024

Request ID: 0x5409a9adfeb275fc7c5b1b784aaa33f
Type: enrollment
Request Status: complete
Operation Result: success
Certificate ID: 0xeef8f0f038829fa855ef2d799522f748
Creation Time: Thu Feb 08 05:07:41 EST 2024
Modification Time: Thu Feb 08 05:07:43 EST 2024

Request ID: 0x65f355c27ef585d8768528575cf41e0
Type: enrollment
Request Status: pending
Operation Result: success
Creation Time: Thu Feb 08 05:11:51 EST 2024
Modification Time: Thu Feb 08 05:11:51 EST 2024

Request ID: 0x85755b8ae061873818dd749529ddd10
Type: enrollment
Request Status: complete
Operation Result: success
Certificate ID: 0xc62f34ca16a5e070ac148c9988336395
Creation Time: Thu Feb 08 05:08:08 EST 2024
Modification Time: Thu Feb 08 05:08:10 EST 2024

Request ID: 0x9860723f07efca3578cbfcdbc9459e0
Type: enrollment
Request Status: pending
Operation Result: success
Creation Time: Thu Feb 08 05:13:25 EST 2024
Modification Time: Thu Feb 08 05:13:25 EST 2024

Request ID: 0xbb79f595be67597f2cea1b6a42bbec5
Type: enrollment
Request Status: pending
Operation Result: success
Creation Time: Thu Feb 08 05:11:48 EST 2024
Modification Time: Thu Feb 08 05:11:48 EST 2024
...
.
.