Use Moqui Framework to build enterprise applications based on Java. It includes tools for databases (relational, graph, document), local and web services, web and other UI with screens and forms, security, file/resource access, scripts, templates, l10n, caching, logging, search, rules, workflow, multi-instance, and integration.
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 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.