suponha que eu tenha uma altura de banco de dados de 1000; 1100; 1200 e largura da mesma forma, quando faço o orçamento coloco que a janela mede 1050 de altura; Largura 1050 
e na hora desse orçamento, conseguir encontrar a medida mais próxima a isso para buscar esse valor

suppose I have a database height of 1000; 1100; 1200 and width in the same way, when I make the budget I say that the window measures 1050 in height; Width 1050
and at the time of this budget, being able to find the measure closest to that to seek that value

In that case, you would create two calculated columns, one with the window height - database height, and one with windo width - database width (if you only want larger ones, filter on differences > 0, otherwise take the absolute value), sorting from least to most deviation, etc.

suppose I have a database height of 1000; 1100; 1200 and width in the same way, when I make the budget I say that the window measures 1050 in height; Width 1050
and at the time of this budget, being able to find the measure closest to that to seek that value

as it would be done within the outsystens from the largest to the smallest deviation

Hi Rafael,

If you would like to run the query to find the value between height and width, you can use SQL query as shown below by passing your entity and its attributes.

Thanks & Kind Regards,

Sachin

Hi Rafael,

You say "the closest", but wouldn't you want the first larger one? Because if you take 1000x1000 when you want 1050x1050, you'll lose money on the extra 102.5m2.

exact, I need the first major

So then it comes down to a query that selects all records where the width and height are equal to or greater than the required width and height, sorted from smallest to largest, and taking the first record (you can set the Max Records to 1).