Hi everyone,
We need to retrieve information from logger tables, stored in Elastic, filtering by a timestamp and a specific column value. We already have tested with the GetPartialTable SLNet message with no success, do you know if there is another option to achieve this? Take into account that we need to retrieve ALL information that matches with the filtering criteria, and this possibly will be more than 1000 rows.
Hi Sebastian,
To retrieve data from logger tables stored in Elastic, you must use Nest NuGet (based on Elastic) to execute Elastic Client queries and get the table. Take into account that you need the index to point the query and a filter (minimum one) to get only the data you need.
You should use the ConnectionSettings class to create the connection using the database URL (default Elastic port: 9200) and the default index for the query. With those settings, you can create a ElasticClient variable to get the client and start doing queries using the ElasticClient.Search() method.
Take into account that you can use the dev tool on Kibana to test the query (if you have access) and translate that into Nest NuGet methods.
Hi Sebastian,
Can you provide an example of GetPartialTable message that didn't work for you?