fix(payments_list): remove time range to filter payments attempts

[apoorvdixit88]

Type of Change

• [x] Bugfix
• [ ] New feature
• [ ] Enhancement
• [x] Refactoring
• [ ] Dependency updates
• [ ] Documentation
• [ ] CI/CD

Description

Currently created_at is not indexed in payment attempt table, when applying filtering with active attempt ids. We are adding extra overhead of checking time_range, though we need not to as we will be already getting filtered attempt ids from intent table.

Additional Changes

• [ ] This PR modifies the API contract
• [ ] This PR modifies the database schema
• [ ] This PR modifies application configuration/environment variables

Motivation and Context

Closes #6160

How did you test it?

We can hit test api

curl --location 'http://localhost:8080/payments/list' \
--header 'Content-Type: application/json' \
--header 'Accept: application/json' \

--header 'Authorization: Bearer JWT' \
--data '{

    "limit": 50,

}'

Checklist

• [x] I formatted the code cargo +nightly fmt --all
• [x] I addressed lints thrown by cargo clippy
• [x] I reviewed the submitted code
• [ ] I added unit tests for my changes where possible

[semanticdiff-com[bot]]

Review changes with SemanticDiff.

Analyzed 6 of 6 files.

	Filename	Status
:heavy_check_mark:	crates/storage_impl/src/payments/payment_attempt.rs	Analyzed
:heavy_check_mark:	crates/storage_impl/src/mock_db/payment_attempt.rs	Analyzed
:heavy_check_mark:	crates/router/src/db/kafka_store.rs	Analyzed
:heavy_check_mark:	crates/router/src/core/payments.rs	Analyzed
:heavy_check_mark:	crates/hyperswitch_domain_models/src/payments/payment_attempt.rs	Analyzed
:heavy_check_mark:	crates/diesel_models/src/query/payment_attempt.rs	Analyzed