I sorted out the issue by accessing to IRIS studio ,

1. Open the class  and change the datatype as you want and save 

2. go to build and compile .

it worked

Hey Robert ,

Thanks for the quick reply.

In near future do you  have any plan to create a core provider for IRIS anytime? we already have an application built on EF and would like to try it with IRIS Health


The mean is calculated by adding all the values in a data set, then dividing by the number of values in the set.

In SQL Server, this can easily be achieved by using the AVG function. (Note that NULL values are ignored by this function.)


SELECT SalesPersonID, AVG(Value) AS MeanValue
FROM Sales.OrdersBySalesperson AS OBSP
WHERE SalesPersonID IN (274, 275, 277, 278, 279, 282)
GROUP BY SalesPersonID ORDER BY SalesPersonID;


SQL Results


The median is calculated by arranging all values in the data set in order, then determining the middle number. If there are an even number of values, you’ll add the two in the middle and calculate the mean. In SQL Server, this isn’t as easy to achieve. However, with the addition of common table expressions (CTEs) and ranking functions, it has become easier.

First, we create a CTE that will order the sales value. The ROW_NUMBER function ranks the orders by value, looking at each salesperson separately. The COUNT function will tell us how many orders the salesperson has.

WITH OrdersBySP (SPID, Value, RowNum, CountOrders) AS 
     SELECT SalesPersonID, 
            ROW_NUMBER() OVER (PARTITION BY SalesPersonID ORDER BY Value), 
            COUNT(SalesOrderID) OVER (PARTITION BY SalesPersonID) 
FROM Sales.OrdersBySalesperson AS OBSP 
WHERE SalesPersonID IN (274, 275, 277, 278, 279, 282) 
SELECT SPID, Value, RowNum, CountOrders FROM OrdersBySP;

Here’s a sample of the results. As you can see, salesperson 275 has a total of 86 orders. Salesperson 277 has 97.

SQL Results

Reference : SQL Mean & Median


I am new to Docor, how can do automation for Windows Asp .Net application. I have configured with bit bucket and it’s getting triggered for each commit but it is getting failed .if it’s failing how can find the exact error

Thank you