You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: