How to add a posted document to a request?

Question

1C

ГДЕ
    |	ЗаказКлиента.СуммаДокумента >= &СуммаДокумента
    |	И ЗаказКлиента.Дата МЕЖДУ &ДатаНач И &ДатаКон
    |	И ЗаказКлиента.Проведен = &Проведен";
  
  Запрос.УстановитьПараметр("ДатаКон", ДатаКон);
  Запрос.УстановитьПараметр("ДатаНач", ДатаНач);
  Запрос.УстановитьПараметр("Проведен", Проведен);

Where is the mistake?

Answer 1

What do you mean "carried out"? If you need to select only completed documents, then in the text of the request it is enough to write: "And Customer's Order.Performed" and you do not need to transfer any extra parameters.

Answer 2

It is necessary to read the error that is displayed on the screen when executing this code. If there are no errors, then most likely the variable Passed = Undefined or False (or any other value not equal to True).

Answer 3

WHERE
| Customer Order.DocumentAmount >= &DocumentAmount
| AND Customer Order.Date BETWEEN &DateStart And &DateEnd
| And Customer Order.Successed";
Query.SetParameter("DateEnd", DateEn);
Query.SetParameter("DateStart", DateStart);
or
WHERE
|CustomerOrder.DocumentAmount >= &DocumentAmount
| ANDCustomerOrder.Date BETWEEN &DateStart AND &DateEn
| ANDCustomerOrder. Posted = &Posted";
Query.SetParameter("DateCon", DateCon);
Query.SetParameter("StartDate", StartDate);
Request.SetParameter("Performed", True);