D
D
Dmitry Krapivin2016-08-03 10:47:37
Java
Dmitry Krapivin, 2016-08-03 10:47:37

How to correctly write the data selection condition in the report?

Hello.
I describe the report, its attributes and the condition for selecting data from the program. I would like to describe the language more "approximate" (understandable) to the programmer. Below is a description. Is this description correct? and how to make it even better and clearer for the programmer?
The "Vehicles in need of repair" field should include those vehicles that:
1. The date of the planned repair period falls within the period:
Start date of the period:
check for an entry in the "Car Repair" section:
• if there is an entry, then the start date of the period will be the date from fields "Date of repair"
• if there is no record, then the start date of the period will be the date from the field "Date of commissioning"
The end date of the period will be the date from the field "Date of formation of the report"
2. There is no record with the type of repair and date in the field "date of exit from repair", which falls within the specified period.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
K
Konstantin Nagibovich, 2016-08-03
@kiru

Quite understandable.

A
Andrey, 2016-08-12
@Andrey052

"I would like to describe in a language more "approximate" (understandable) to the programmer"
Write him the text of the request 1s, I think it will be exactly understandable))))))

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question