Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

After clicking "Clear Parameters" to query the order, the query results are incorrect #612

Open
daiagou opened this issue Aug 25, 2023 · 0 comments

Comments

@daiagou
Copy link

daiagou commented Aug 25, 2023

The phenomenon is as follows:
On the FindOrder page, when we click on the FindOptions button and enter some order status for query, such as "OrderOpen, OrderPlaced", the query result is correct. We looked at the SQL: "select xxx from xxx where orderStatus in (OrderOpen, OrderPlaced)",
However, after clicking the "Clear Parameters" button, the order status "OrderOpen, OrderPlaced" was still entered, but no results were found. After checking the SQL, it was found that it had changed to "select xxx from xxx where orderStatus=(OrderOpen, OrderPlaced)",
'in' has changed to '='.
The reason for this is that at the beginning of loading the page, ''is effective. But when the "Clear Parameters" button is clicked, the default value (partStatusId_op) is cleared and will not be transmitted to the background, so the default "equals" is used.
The solution I suggest is to use the clear method not to clear the content of defaultParameters, at least 'xxx_op' cannot be cleared because there is no input value on the interface.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

1 participant