I want to try to tie the search into a small corporate application:

in DB (mssql) data is stored in two tables

Tools(Id int, TypeId int, OrderCode nvarchar, VendorId int)

ToolParameterHistories(ToolId int, ToolParameterId int, BoolValue bit, DecimalValue decimal(18,2), IntValue int, StringValue string)

Tell me how to correctly add information from the database to elasticsearch , so that later you can search for a tool for a set of characteristics, i.e. Something like the following:

 SELECT t.* FROM Tools t JOIN (SELECT * FROM ToolParameterHistories tph WHERE tph.ToolParameterId = 4 AND (tph.DecimalValue >= 10 AND tph.DecimalValue <= 12)) D ON D.ToolId = t.Id JOIN (SELECT * FROM ToolParameterHistories tph WHERE tph.ToolParameterId = 5 AND (tph.DecimalValue >= 6 AND tph.DecimalValue <= 6)) r ON r.ToolId = t.Id

PS I still don’t really understand how best to implement this Wishlist , so I will be very grateful for the information how to do such things

PSS If elasticsearch is not designed for this, then do not hesitate to say

    0