Nathean Analytics can query it’s in-memory cached data tables using LINQ (Language Integrated Query: a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages). To query the in-memory data tables, create a new new Dataset and select the “default” Data Connector (if no “default” data connector exists, look for one with a database type of “LOGIXCACHE”).

You can then write a LINQ query against any pre-existing dataset using LINQ as described in Nathean Analytics Cache Query Syntax

For a quick start, if you navigate to the Cache tab of the Dataset that you wish to query, clicking the Generate Cache Query button will display the LINQ query that can be used to query the results of that Dataset:

This query can be copied and pasted into the Query definition of the new Dataset where it can be edited to return a subset (or all) of the fields in that dataset, perhaps appended with a .WHERE clause to parameterise the data returned. A typical use of this feature would be to combine it with User or IP Parameters to limit the data returned to that which the logged-in user is interested in without necessitating multiple executions of the SQL query against the underlying database as in the example below:

(Customer Invoices).Select(
@CUSTOMER_GROUP as CUSTOMER_GROUP, 
@CUSTOMER_NAME as CUSTOMER_NAME, 
@INVOICE_NO as INVOICE_NO, 
@AMOUNT as AMOUNT)
.WHERE(@ACCOUNT_MANAGER = :ACCOUNT_MANAGER)
Revision: 4
Last modified: Jul 01, 2019

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment