Hi Mesut,
This is what happened with this task. Here is the original Sales dynamic list query:
| Code |
|---|
SELECT
Sales.Number AS Number,
Sales.Date AS Date,
Sales.AmountPaid AS AmountPaid,
Sales.PaymentMethod AS PaymentMethod
FROM
Document.Sales AS Sales
|
You added a parameter in there, and this is what you got:
| Code |
|---|
SELECT
Sales.Date AS Date,
Sales.Number AS Number,
Sales.AmountPaid AS AmountPaid,
Sales.PaymentMethod AS PaymentMethod
FROM
Document.Sales AS Sales
WHERE
AmountPaid >= &Parameter
ORDER BY
AmountPaid DESC
|
The problem is that in your query Date and Number fields are swapped. Our auto-check algorithm is sensitive to the fields order, so it sees it as a different query. Please, restore the original order of this two fields (Number goes first, Date goes second) and everything should work.
We'll think of making the auto-check algorithm order-insensitive in the future.
Thank you,
Konstantin
Desktop version