问:
Problems with saving image with OpenCV?
So, this is what I want. I have a camera frame where a circle is drawn using OpenCV. Now, I have a button which allows a user to capture an image frame and then save the image in internal storage. But then here is the problem.  I don't want the circle in the image frame to be in the saved image. How do i eliminate the circle before saving it and then once the image is saved, the circle is back on the screen?</p>

答:
Have you tried

```<code>#create a clone (circle) of original (mrgba)
BufferedImage circle = new BufferedImage(widthOfImage, heightOfImage,
BufferedImage.TYPE_INT_RGB);
Graphics g =circle.createGraphics();
g.drawImage(mrgba, 0, 0, null);

Imgproc.circle(circle,new Point(centerx,centery),200,new Scalar(255,0,0),10);  #put circle on circle

cv2.imshow("Image", circle) //show circle
cv2.imwrite(/path/to/file/name, mrgba) //save original
</code>```

something along those lines.

Title: Problems with saving image with OpenCV?

Body:
Have you tried

#create a clone (circle) of original (mrgba)
BufferedImage circle = new BufferedImage(widthOfImage, heightOfImage,
BufferedImage.TYPE_INT_RGB);
Graphics g =circle.createGraphics();
g.drawImage(mrgba, 0, 0, null);

Imgproc.circle(circle,new Point(centerx,centery),200,new Scalar(255,0,0),10);  #put circle on circle

cv2.imshow("Image", circle) //show circle
cv2.imwrite(/path/to/file/name, mrgba) //save original

something along those lines.


来源: stackexchange

问:
Calculating product's quantity with nested EF Query
I want to calculate the quantity of every product. I want to use these tables for this.

I want take result like this.

StockId | StockName | Sum(ProductNumber) [actually product quantity]

I tried this code for can take right result but It is returning null value even though it is the condition that satisfies the conditions.

```<code>CimriContext context = new CimriContext();
    public ICollection<StockDto.StockHeader> FillDataGrid(int userCompanyId)
    {
        ICollection<StockDto.StockHeader> Stocks = context.Stocks.Where(c => c.UserCompanyId==userCompanyId).
             Select(c => new StockDto.StockHeader()
             {
                 StockId = c.StockId,
                 StockName = c.StockName,
                 Piece=0
             }).ToList();

        ICollection<StockDto.StockHeader> ProductHeader = new List<StockDto.StockHeader>();
        foreach (var products in Stocks)
        {
            products.Piece = context.ProductTransactions.Where(p => p.StockId==products.StockId).Sum(s => s.ProductNumber);
            ProductHeader.Add(products);
        }

        return ProductHeader.ToList();
    }
</code>```

答:
You want to retrieve ProductCount for per stock record. You can perform it by joining two tables and grouping StockId and StockNumber like this;

```<code>        var query = from stocks in context.Stocks
                    join products in context.ProductTransactions ON stocks.StockId equals products.StockId
                    where stocks.UserCompanyId = userCompanyId
                    group stocks by new
                    {
                        stocks.StockId,
                        stocks.StockName
                    } into gcs
                    select new
                    {
                        StockId = gcs.Key.StockId,
                        StockName = gcs.Key.StockName,
                        ProductCounts = gcs.Count()
                    };
</code>```

ContentLicense: CC BY-SA 3.0

Body:
I want to calculate the quantity of every product. I want to use these tables for this.

I want take result like this.

StockId | StockName | Sum(ProductNumber) [actually product quantity]

I tried this code for can take right result but It is returning null value even though it is the condition that satisfies the conditions.

CimriContext context = new CimriContext();
    public ICollection<StockDto.StockHeader> FillDataGrid(int userCompanyId)
    {
        ICollection<StockDto.StockHeader> Stocks = context.Stocks.Where(c => c.UserCompanyId==userCompanyId).
             Select(c => new StockDto.StockHeader()
             {
                 StockId = c.StockId,
                 StockName = c.StockName,
                 Piece=0
             }).ToList();

        ICollection<StockDto.StockHeader> ProductHeader = new List<StockDto.StockHeader>();
        foreach (var products in Stocks)
        {
            products.Piece = context.ProductTransactions.Where(p => p.StockId==products.StockId).Sum(s => s.ProductNumber);
            ProductHeader.Add(products);
        }

        return ProductHeader.ToList();
    }

Body:
You want to retrieve ProductCount for per stock record. You can perform it by joining two tables and grouping StockId and StockNumber like this;

        var query = from stocks in context.Stocks
                    join products in context.ProductTransactions ON stocks.StockId equals products.StockId
                    where stocks.UserCompanyId = userCompanyId
                    group stocks by new
                    {
                        stocks.StockId,
                        stocks.StockName
                    } into gcs
                    select new
                    {
                        StockId = gcs.Key.StockId,
                        StockName = gcs.Key.StockName,
                        ProductCounts = gcs.Count()
                    };


问:
php cannot find Class when using namespace
I'm trying to make a object of a class from another file. Both file is located in the same folder & I used 'namespace App' in the both files. In the login files I'm trying to get the class object but it couldn't find the class. Codes are given below.

Database Class : 'Database.php'

```<code><?php
    namespace App;

    require_once 'config.php';

class Database{

    private $db;

    public function __construct(){

        $this->db =  new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);

    }

    public function getConnection(){

        return $this->db;

    }
</code>```

login.php file :

```<code><?php

    namespace App;

    use App\Database;

    require_once 'config.php';

    $DB = new Database();

    $con = $DB->getConnection;
</code>```

When I execute login.php , it says Fatal error: Uncaught Error: Class 'App\Database' not found in login.php on line 10

答:
If you are in the root namespace:

use \App\Database; You want to tell PHP to search for App namespace in the namespace root, if that's where it is.

If you are in the App namespace:

use Database; You want to tell PHP to search for Database in the current namespace, if that's where it is.

If you are in another namespace:

If you're in another namespace (such as \Blob) then reference from the root, \App\Database, as above.

```<code>namespace App;

use App\Database;
</code>```

This is currently looking for \App\App\Database and so is telling you that App\Database is not found in the \App namespace.

Body:
I'm trying to make a object of a class from another file. Both file is located in the same folder & I used 'namespace App' in the both files. In the login files I'm trying to get the class object but it couldn't find the class. Codes are given below.

Database Class : 'Database.php'

<?php
    namespace App;

    require_once 'config.php';

class Database{

    private $db;

    public function __construct(){

        $this->db =  new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);

    }

    public function getConnection(){

        return $this->db;

    }

login.php file :

<?php

    namespace App;

    use App\Database;

    require_once 'config.php';

    $DB = new Database();

    $con = $DB->getConnection;

When I execute login.php , it says Fatal error: Uncaught Error: Class 'App\Database' not found in login.php on line 10

Body:
If you are in the root namespace:

use \App\Database; You want to tell PHP to search for App namespace in the namespace root, if that's where it is.

If you are in the App namespace:

use Database; You want to tell PHP to search for Database in the current namespace, if that's where it is.

If you are in another namespace:

If you're in another namespace (such as \Blob) then reference from the root, \App\Database, as above.

namespace App;

use App\Database;

This is currently looking for \App\App\Database and so is telling you that App\Database is not found in the \App namespace.


问:
How to refer to a checkbox in access navigation form through vba (Detail_Format) in report
I am trying to hide details section in a report if checkbox in navigation form is not checked.

It's not working somehow, please tell me what am I doing wrong.

```<code>Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Forms!DASHBOARD!NavigationSubform.Form!rptMain.chkWaBox.Value = True Then
Detail.Visible = True
End If
End Sub
</code>```

Thanks for the help in advance.

答:
Is your details section set to visible in design view? If it is, your code will not hide it. Your code only makes it visible if it's hidden.

When using boolean values like this, I like to make the assignment directly, so it doesn't matter what the state of the object is in design, it always gets handled correctly at runtime:

```<code>Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Detail.Visible = Forms!DASHBOARD!NavigationSubform.Form!rptMain.chkWaBox.Value
End Sub
</code>```

Body:
I am trying to hide details section in a report if checkbox in navigation form is not checked.

It's not working somehow, please tell me what am I doing wrong.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Forms!DASHBOARD!NavigationSubform.Form!rptMain.chkWaBox.Value = True Then
Detail.Visible = True
End If
End Sub

Thanks for the help in advance.

Body:
Is your details section set to visible in design view? If it is, your code will not hide it. Your code only makes it visible if it's hidden.

When using boolean values like this, I like to make the assignment directly, so it doesn't matter what the state of the object is in design, it always gets handled correctly at runtime:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Detail.Visible = Forms!DASHBOARD!NavigationSubform.Form!rptMain.chkWaBox.Value
End Sub


问:
WPF checkboxcolumn— on checkbox value changed, do something
What I want to do is enable a button when a checkbox in a DataGridCheckBoxColumn is checked.  I did some research and found this stackoverflow below.  I found that placing the UpdateSourceTrigger=PropertyChanged on the column should do the trick, but when I place a breakpoint on my property, it does not get called.

Checkbox event that fires AFTER the value has changed

Here is my XAML code that I have:

```<code><DataGrid Grid.Row="3" Grid.Column="1" AutoGenerateColumns="False" FontSize="18" ItemsSource="{Binding Path=MyProperty, NotifyOnSourceUpdated=True, UpdateSourceTrigger=PropertyChanged}">
    <DataGrid.Columns>
        <DataGridCheckBoxColumn Binding="{Binding Path=Status, UpdateSourceTrigger=PropertyChanged}" Header="Verify" Width="1*"/>
        <DataGridTextColumn Binding="{Binding Path=Id, UpdateSourceTrigger=PropertyChanged}" Header="PalletID" IsReadOnly="True" Width="2*"/>
    </DataGrid.Columns>
</DataGrid>
</code>```

In my view model, my property is this:

```<code>private ObservableCollection<Objects.MyClass> _myProperty;
public ObservableCollection<Objects.MyClass> MyProperty
{
    get { return _myProperty; }
    set
    {
        _myProperty= value;
        this.RaisePropertyChanged();
    }
}
</code>```

where MyClass is a simple class containing three properties:

```<code>public string Id { get; set; }
public bool Verified { get; set; }
public bool Status { get; set; }

public MyClass(string id, bool currentStatus)
{
    Id = id;
    Verified = currentStatus;
    Status = false;//Set to false initially to deselect checkbox.
}
</code>```

Is there something that I am missing?  From what I gathered online, the UpdateSourceTrigger=PropertyChanged on the checkbox column is what should allow me to view when the checkbox value changes.  Any help would be great.

答:
Your code is working mate. Just add the button and bind the Status property to the button's IsEnabled property.</p>

```<code><DataGrid Grid.Row="3" Grid.Column="1" AutoGenerateColumns="False" FontSize="18" ItemsSource="{Binding Path=MyProperty, NotifyOnSourceUpdated=True, UpdateSourceTrigger=PropertyChanged}">
            <DataGrid.Columns>
                <DataGridCheckBoxColumn Binding="{Binding Path=Status, UpdateSourceTrigger=PropertyChanged}" Header="Verify" Width="1*"/>
                <DataGridTextColumn Binding="{Binding Path=Id, UpdateSourceTrigger=PropertyChanged}" Header="PalletID" IsReadOnly="True" Width="2*"/>
                <DataGridTemplateColumn>
                    <DataGridTemplateColumn.CellTemplate>
                        <DataTemplate>
                            <Button IsEnabled="{Binding Status}">I am a button</Button>
                        </DataTemplate>
                    </DataGridTemplateColumn.CellTemplate>
                </DataGridTemplateColumn>
            </DataGrid.Columns>
        </DataGrid>
</code>```

Body:
What I want to do is enable a button when a checkbox in a DataGridCheckBoxColumn is checked.  I did some research and found this stackoverflow below.  I found that placing the UpdateSourceTrigger=PropertyChanged on the column should do the trick, but when I place a breakpoint on my property, it does not get called.

Checkbox event that fires AFTER the value has changed

Here is my XAML code that I have:

<DataGrid Grid.Row="3" Grid.Column="1" AutoGenerateColumns="False" FontSize="18" ItemsSource="{Binding Path=MyProperty, NotifyOnSourceUpdated=True, UpdateSourceTrigger=PropertyChanged}">
    <DataGrid.Columns>
        <DataGridCheckBoxColumn Binding="{Binding Path=Status, UpdateSourceTrigger=PropertyChanged}" Header="Verify" Width="1*"/>
        <DataGridTextColumn Binding="{Binding Path=Id, UpdateSourceTrigger=PropertyChanged}" Header="PalletID" IsReadOnly="True" Width="2*"/>
    </DataGrid.Columns>
</DataGrid>

In my view model, my property is this:

private ObservableCollection<Objects.MyClass> _myProperty;
public ObservableCollection<Objects.MyClass> MyProperty
{
    get { return _myProperty; }
    set
    {
        _myProperty= value;
        this.RaisePropertyChanged();
    }
}

where MyClass is a simple class containing three properties:

public string Id { get; set; }
public bool Verified { get; set; }
public bool Status { get; set; }

public MyClass(string id, bool currentStatus)
{
    Id = id;
    Verified = currentStatus;
    Status = false;//Set to false initially to deselect checkbox.
}

Is there something that I am missing?  From what I gathered online, the UpdateSourceTrigger=PropertyChanged on the checkbox column is what should allow me to view when the checkbox value changes.  Any help would be great.

Body:
Your code is working mate. Just add the button and bind the Status property to the button's IsEnabled property.

<DataGrid Grid.Row="3" Grid.Column="1" AutoGenerateColumns="False" FontSize="18" ItemsSource="{Binding Path=MyProperty, NotifyOnSourceUpdated=True, UpdateSourceTrigger=PropertyChanged}">
            <DataGrid.Columns>
                <DataGridCheckBoxColumn Binding="{Binding Path=Status, UpdateSourceTrigger=PropertyChanged}" Header="Verify" Width="1*"/>
                <DataGridTextColumn Binding="{Binding Path=Id, UpdateSourceTrigger=PropertyChanged}" Header="PalletID" IsReadOnly="True" Width="2*"/>
                <DataGridTemplateColumn>
                    <DataGridTemplateColumn.CellTemplate>
                        <DataTemplate>
                            <Button IsEnabled="{Binding Status}">I am a button</Button>
                        </DataTemplate>
                    </DataGridTemplateColumn.CellTemplate>
                </DataGridTemplateColumn>
            </DataGrid.Columns>
        </DataGrid>


问:
Remove part of string but getting the deleted part as result
So, quick question (searched a lot in Google, but only found the answer which produces same response as below):

code:

```<code>var teste = '10/12/2017';
console.log(teste); //returns 10/12/2017
var teste_cut = teste.substr(6,2);
console.log(teste_cut); //returns only 20
</code>```

What I want is 10/12/17. I can't change how the string is created, so I need to change it after getting said string. Does a method for doing this exist, or should I work around with other functions? I'm feeling stupid right now, since it seens to be a fairly obvious answer, but I guess we all get our stupid moments :P

答:
One method to achieve this would be to cut the start and end portions of the string then join them back together, something like this:

var teste = bookend('10/12/2017', 6, 7);
console.log(teste);

function bookend(str, start, end) {
  return str.substr(0, start) + str.substr(end + 1);
}```
</div>
</div>
</p>

<p>An alternative would be to use a regular expression to match the parts of the date you want to keep and then join them back together:</p>

<p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-js lang-js prettyprint-override"><code>var teste = '10/12/2017'.replace(/(\d{2}\/\d{2}\/)(\d{2})(\d{2})/, '$1$3');
console.log(teste);</code>```

Body:
So, quick question (searched a lot in Google, but only found the answer which produces same response as below):

code:

var teste = '10/12/2017';
console.log(teste); //returns 10/12/2017
var teste_cut = teste.substr(6,2);
console.log(teste_cut); //returns only 20

What I want is 10/12/17. I can't change how the string is created, so I need to change it after getting said string. Does a method for doing this exist, or should I work around with other functions? I'm feeling stupid right now, since it seens to be a fairly obvious answer, but I guess we all get our stupid moments :P

Body:
One method to achieve this would be to cut the start and end portions of the string then join them back together, something like this:

var teste = bookend('10/12/2017', 6, 7);
console.log(teste);

function bookend(str, start, end) {
  return str.substr(0, start) + str.substr(end + 1);
}

An alternative would be to use a regular expression to match the parts of the date you want to keep and then join them back together:

var teste = '10/12/2017'.replace(/(\d{2}\/\d{2}\/)(\d{2})(\d{2})/, '$1$3');
console.log(teste);


问:
alternate row value minus SQL
Hi Guys I have a data set from my query that looks like this:

```<code>Date   |  Count   | Activity
10 Nov |    10    |    A
11 Nov |    11    |    A
10 Nov |    12    |    B
11 Nov |    13    |    B
</code>```

I am trying to achieve this result. Basically the logic is the 2nd row will minus the 1st row, 4th row minus the 3rd row.

```<code>Date   |  Count   | Activity  | Diff
10 Nov |    10    |    A      |  0
11 Nov |    11    |    A      |  1
10 Nov |    12    |    B      |  0
11 Nov |    13    |    B      |  1
</code>```

My current query looks like this:

```<code>select  DATE, count(distinct(ID)) as Count,
count(distinct(ID)) - LAG(count(distinct(ID)),1) over (order by count(distinct(ID))) as Eng_change
from (Select DATA.*,PRODUCT.MAPPING from DATA left join PRODUCT on DATA.Part_Number=PRODUCT.PRODUCT_NUMBER ) OVERALLFUNNEL
WHERE ACTIVITY_RANK>5
group by OVERALLFUNNEL.ACTIVITY,OVERALLFUNNEL.DATE
ORDER BY ACTIVITY_RANK ASC
</code>```

Using lag will give minus always the previous row but that's not what I want.

Any help or function?

regards

答:
If I understand your problem correctly, you want the difference within each activity.  If so:

```<code>select DATE, activity,
       count(distinct ID) as Count,
       (count(distinct ID) -
        LAG(count(distinct ID), 1) over (partition by activity
                                         order by count(distinct ID)
                                        )
      ) as Eng_change
</code>```

This will give NULL for the first value.  If you want 0, use coalesce() or something similar.

Title: alternate row value minus SQL

Body:
Hi Guys I have a data set from my query that looks like this:

Date   |  Count   | Activity
10 Nov |    10    |    A
11 Nov |    11    |    A
10 Nov |    12    |    B
11 Nov |    13    |    B

I am trying to achieve this result. Basically the logic is the 2nd row will minus the 1st row, 4th row minus the 3rd row.

Date   |  Count   | Activity  | Diff
10 Nov |    10    |    A      |  0
11 Nov |    11    |    A      |  1
10 Nov |    12    |    B      |  0
11 Nov |    13    |    B      |  1

My current query looks like this:

select  DATE, count(distinct(ID)) as Count,
count(distinct(ID)) - LAG(count(distinct(ID)),1) over (order by count(distinct(ID))) as Eng_change
from (Select DATA.*,PRODUCT.MAPPING from DATA left join PRODUCT on DATA.Part_Number=PRODUCT.PRODUCT_NUMBER ) OVERALLFUNNEL
WHERE ACTIVITY_RANK>5
group by OVERALLFUNNEL.ACTIVITY,OVERALLFUNNEL.DATE
ORDER BY ACTIVITY_RANK ASC

Using lag will give minus always the previous row but that's not what I want.

Any help or function?

regards

Body:
If I understand your problem correctly, you want the difference within each activity.  If so:

select DATE, activity,
       count(distinct ID) as Count,
       (count(distinct ID) -
        LAG(count(distinct ID), 1) over (partition by activity
                                         order by count(distinct ID)
                                        )
      ) as Eng_change

This will give NULL for the first value.  If you want 0, use coalesce() or something similar.


问:
version control for adobe dreamweaver 6
It is 2017, everything I have found thus far is for older versions. So- I was wondering if there is any modern way to connect GITHUB desktop to Dreamweaver 6. Not Dreamweaver CC. I have Dreamweaver 6-adobe.

Or any reasonably modern method for version control associated with Dreamweaver 6. thanks.

答:
This link on stackoverflow references one specifically for adobe dreamweaver cs6:
SVN & Dreamweaver.
it is still uptodate...64bit machines. TortoiseSVN(Free)
the download site is: https://tortoisesvn.net/downloads.html. thankc</p>

Title: version control for adobe dreamweaver 6


问:
json Cannot access child value on Newtonsoft.Json.Linq.JValue
I'm new to json logic and i have a complicate json, that i must read from a url and to bind into a datagrid using c#.

My json file:

``` {
"expand": "schema,names",
"startAt": 0,
"maxResults": 50,
"total": 6,
"issues": [{
    "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
    "id": "10502",
    "self": "https://pr.myproject.net/sd/rest/api/2/issue/10502",
    "key": "WO-60",
    "fields": {
        "customfield_10230": null,
        "fixVersions": [],
        "customfield_10231": null,
        "resolution": null,
        "customfield_10510": [],
        "customfield_10229": null,
        "lastViewed": null,
        "customfield_10220": null,
        "priority": null,
        "customfield_10100": null,
        "customfield_10101": null,
        "labels": [],
        "timeestimate": null,
        "versions": [],
        "customfield_10219": null,
        "issuelinks": [],
        "assignee": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=crewManagerTest",
            "name": "crewManagerTest",
            "key": "crewmanagertest",
            "emailAddress": "crewManagerTest@crewManagerTest.com",
            "avatarUrls": {
                "48x48": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=48",
                "24x24": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=24"
            },
            "displayName": "crewManagerTest",
            "active": true,
            "timeZone": "Europe"
        },
        "status": {
            "self": "https://pr.myproject.net/sd/rest/api/2/status/10000",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/images/icons/status_generic.gif",
            "name": "To Do",
            "id": "10000",
            "statusCategory": {
                "self": "https://pr.myproject.net/sd/rest/api/2/statuscategory/2",
                "id": 2,
                "key": "new",
                "colorName": "blue-gray",
                "name": "To Do"
            }
        },
        "components": [],
        "customfield_10296": "CF-38",
        "customfield_10603": "10502",
        "aggregatetimeestimate": null,
        "customfield_10604": "0",
        "customfield_10606": "",
        "creator": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10280": null,
        "subtasks": [],
        "reporter": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10285": null,
        "customfield_10286": null,
        "aggregateprogress": {
            "progress": 0,
            "total": 0
        },
        "progress": {
            "progress": 0,
            "total": 0
        },
        "votes": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-60/votes",
            "votes": 0,
            "hasVoted": false
        },
        "issuetype": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issuetype/10116",
            "id": "10116",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/secure/viewavatar?size=xsmall&avatarId=10300&avatarType=issuetype",
            "name": "Survey",
            "subtask": false,
            "avatarId": 10300
        },
        "customfield_10270": null,
        "timespent": null,
        "customfield_10271": null,
        "customfield_10272": null,
        "customfield_10273": null,
        "project": {
            "self": "https://pr.myproject.net/sd/rest/api/2/project/10103",
            "id": "10103",
            "key": "WO",
            "name": "Field Service",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/projectavatar?avatarId=10324",
                "24x24": "https://pr.myproject.net/sd/secure/projectavatar?size=small&avatarId=10324"
            }
        },
        "customfield_10275": null,
        "aggregatetimespent": null,
        "resolutiondate": null,
        "workratio": -1,
        "watches": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-60/watchers",
            "watchCount": 1,
            "isWatching": false
        },
        "created": "2017-11-27T15:44:49.000+0200",
        "updated": "2017-11-27T15:44:50.000+0200",
        "timeoriginalestimate": null,
        "description": null,
        "summary": "Mobile Test",
        "customfield_10240": null,
        "customfield_10241": null,
        "customfield_10000": "com",
        "environment": null,
        "customfield_10238": null,
        "customfield_10513": [],
        "customfield_10514": [],
        "customfield_10516": [],
        "duedate": null,
        "customfield_10519": null
    }
},
{
    "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
    "id": "10166",
    "self": "https://pr.myproject.net/sd/rest/api/2/issue/10166",
    "key": "WO-24",
    "fields": {
        "customfield_10230": null,
        "fixVersions": [],
        "customfield_10231": null,
        "resolution": {
            "self": "https://pr.myproject.net/sd/rest/api/2/resolution/10100",
            "id": "10100",
            "description": "This issue was not approved.",
            "name": "Declined"
        },
        "customfield_10510": [],
        "customfield_10503": [],
        "customfield_10229": null,
        "lastViewed": null,
        "customfield_10220": null,
        "priority": null,
        "customfield_10100": null,
        "customfield_10101": null,
        "labels": [],
        "timeestimate": null,
        "versions": [],
        "customfield_10219": null,
        "issuelinks": [],
        "assignee": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=crewManagerTest",
            "name": "crewManagerTest",
            "key": "crewmanagertest",
            "emailAddress": "crewManagerTest@crewManagerTest.com",
            "avatarUrls": {
                "48x48": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=48",
                "24x24": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=24"
            },
            "displayName": "crewManagerTest",
            "active": true,
            "timeZone": "Europe"
        },
        "status": {
            "self": "https://pr.myproject.net/sd/rest/api/2/status/10145",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/images/icons/statuses/generic.png",
            "name": "Rejected",
            "id": "10145",
            "statusCategory": {
                "self": "https://pr.myproject.net/sd/rest/api/2/statuscategory/3",
                "id": 3,
                "key": "done",
                "colorName": "green",
                "name": "Done"
            }
        },
        "components": [],
        "customfield_10296": "CF-41",
        "customfield_10603": null,
        "aggregatetimeestimate": null,
        "customfield_10604": "0",
        "customfield_10606": "",
        "creator": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10280": null,
        "subtasks": [],
        "reporter": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10285": null,
        "customfield_10286": null,
        "aggregateprogress": {
            "progress": 0,
            "total": 0
        },
        "progress": {
            "progress": 0,
            "total": 0
        },
        "votes": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-24/votes",
            "votes": 0,
            "hasVoted": false
        },
        "issuetype": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issuetype/10116",
            "id": "10116",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/secure/viewavatar?size=xsmall&avatarId=10300&avatarType=issuetype",
            "name": "Survey",
            "subtask": false,
            "avatarId": 10300
        },
        "customfield_10270": null,
        "timespent": null,
        "customfield_10271": null,
        "customfield_10272": null,
        "customfield_10273": null,
        "project": {
            "self": "https://pr.myproject.net/sd/rest/api/2/project/10103",
            "id": "10103",
            "key": "WO",
            "name": "Field Service",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/projectavatar?avatarId=10324",
                "24x24": "https://pr.myproject.net/sd/secure/projectavatar?size=small&avatarId=10324"
            }
        },
        "customfield_10275": null,
        "aggregatetimespent": null,
        "resolutiondate": "2017-07-02T15:05:20.000+0300",
        "workratio": -1,
        "watches": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-24/watchers",
            "watchCount": 1,
            "isWatching": false
        },
        "created": "2017-06-07T18:23:03.000+0300",
        "updated": "2017-07-02T15:05:20.000+0300",
        "timeoriginalestimate": null,
        "description": null,
        "summary": "Mobile Test 4",
        "customfield_10240": null,
        "customfield_10241": null,
        "customfield_10000": "com",
        "environment": null,
        "customfield_10238": null,
        "customfield_10513": [],
        "customfield_10514": [],
        "customfield_10516": [],
        "duedate": null,
        "customfield_10519": null
    }
},
{
    "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
    "id": "10164",
    "self": "https://pr.myproject.net/sd/rest/api/2/issue/10164",
    "key": "WO-23",
    "fields": {
        "customfield_10230": null,
        "fixVersions": [],
        "customfield_10231": null,
        "resolution": {
            "self": "https://pr.myproject.net/sd/rest/api/2/resolution/10100",
            "id": "10100",
            "description": "This issue was not approved.",
            "name": "Declined"
        },
        "customfield_10510": [],
        "customfield_10503": [],
        "customfield_10229": null,
        "lastViewed": null,
        "customfield_10220": null,
        "priority": null,
        "customfield_10100": null,
        "customfield_10101": null,
        "labels": [],
        "timeestimate": null,
        "versions": [],
        "customfield_10219": null,
        "issuelinks": [],
        "assignee": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=crewManagerTest",
            "name": "crewManagerTest",
            "key": "crewmanagertest",
            "emailAddress": "crewManagerTest@crewManagerTest.com",
            "avatarUrls": {
                "48x48": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=48",
                "24x24": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=24"
            },
            "displayName": "crewManagerTest",
            "active": true,
            "timeZone": "Europe"
        },
        "status": {
            "self": "https://pr.myproject.net/sd/rest/api/2/status/10145",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/images/icons/statuses/generic.png",
            "name": "Rejected",
            "id": "10145",
            "statusCategory": {
                "self": "https://pr.myproject.net/sd/rest/api/2/statuscategory/3",
                "id": 3,
                "key": "done",
                "colorName": "green",
                "name": "Done"
            }
        },
        "components": [],
        "customfield_10296": "CF-40",
        "customfield_10603": null,
        "aggregatetimeestimate": null,
        "customfield_10604": "0",
        "customfield_10606": "",
        "creator": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10280": null,
        "subtasks": [],
        "reporter": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10285": null,
        "customfield_10286": null,
        "aggregateprogress": {
            "progress": 0,
            "total": 0
        },
        "progress": {
            "progress": 0,
            "total": 0
        },
        "votes": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-23/votes",
            "votes": 0,
            "hasVoted": false
        },
        "issuetype": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issuetype/10116",
            "id": "10116",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/secure/viewavatar?size=xsmall&avatarId=10300&avatarType=issuetype",
            "name": "Survey",
            "subtask": false,
            "avatarId": 10300
        },
        "customfield_10270": null,
        "timespent": null,
        "customfield_10271": null,
        "customfield_10272": null,
        "customfield_10273": null,
        "project": {
            "self": "https://pr.myproject.net/sd/rest/api/2/project/10103",
            "id": "10103",
            "key": "WO",
            "name": "Field Service",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/projectavatar?avatarId=10324",
                "24x24": "https://pr.myproject.net/sd/secure/projectavatar?size=small&avatarId=10324"
            }
        },
        "customfield_10275": null,
        "aggregatetimespent": null,
        "resolutiondate": "2017-07-02T15:10:40.000+0300",
        "workratio": -1,
        "watches": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-23/watchers",
            "watchCount": 1,
            "isWatching": false
        },
        "created": "2017-06-07T18:21:24.000+0300",
        "updated": "2017-07-02T15:10:40.000+0300",
        "timeoriginalestimate": null,
        "description": null,
        "summary": "Mobile Test 3",
        "customfield_10240": null,
        "customfield_10241": null,
        "customfield_10000": "com",
        "environment": null,
        "customfield_10238": null,
        "customfield_10513": [],
        "customfield_10514": [],
        "customfield_10516": [],
        "duedate": null,
        "customfield_10519": null
    }
},
{
    "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
    "id": "10162",
    "self": "https://pr.myproject.net/sd/rest/api/2/issue/10162",
    "key": "WO-22",
    "fields": {
        "customfield_10230": null,
        "fixVersions": [],
        "customfield_10231": null,
        "resolution": null,
        "customfield_10510": [],
        "customfield_10503": [],
        "customfield_10229": null,
        "lastViewed": "2017-12-01T02:07:05.368+0200",
        "customfield_10220": null,
        "priority": null,
        "customfield_10100": null,
        "customfield_10101": null,
        "labels": [],
        "timeestimate": null,
        "versions": [],
        "customfield_10219": null,
        "issuelinks": [],
        "assignee": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=crewManagerTest",
            "name": "crewManagerTest",
            "key": "crewmanagertest",
            "emailAddress": "crewManagerTest@crewManagerTest.com",
            "avatarUrls": {
                "48x48": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=48",
                "24x24": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=24"
            },
            "displayName": "crewManagerTest",
            "active": true,
            "timeZone": "Europe"
        },
        "status": {
            "self": "https://pr.myproject.net/sd/rest/api/2/status/10000",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/images/icons/status_generic.gif",
            "name": "To Do",
            "id": "10000",
            "statusCategory": {
                "self": "https://pr.myproject.net/sd/rest/api/2/statuscategory/2",
                "id": 2,
                "key": "new",
                "colorName": "blue-gray",
                "name": "To Do"
            }
        },
        "components": [],
        "customfield_10296": "CF-39",
        "customfield_10603": null,
        "aggregatetimeestimate": null,
        "customfield_10604": "0",
        "customfield_10606": "",
        "creator": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10280": null,
        "subtasks": [],
        "reporter": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10285": null,
        "customfield_10286": null,
        "aggregateprogress": {
            "progress": 0,
            "total": 0
        },
        "progress": {
            "progress": 0,
            "total": 0
        },
        "votes": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-22/votes",
            "votes": 0,
            "hasVoted": false
        },
        "issuetype": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issuetype/10116",
            "id": "10116",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/secure/viewavatar?size=xsmall&avatarId=10300&avatarType=issuetype",
            "name": "Survey",
            "subtask": false,
            "avatarId": 10300
        },
        "customfield_10270": null,
        "timespent": null,
        "customfield_10271": null,
        "customfield_10272": null,
        "customfield_10273": null,
        "project": {
            "self": "https://pr.myproject.net/sd/rest/api/2/project/10103",
            "id": "10103",
            "key": "WO",
            "name": "Field Service",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/projectavatar?avatarId=10324",
                "24x24": "https://pr.myproject.net/sd/secure/projectavatar?size=small&avatarId=10324"
            }
        },
        "customfield_10275": null,
        "aggregatetimespent": null,
        "resolutiondate": null,
        "workratio": -1,
        "watches": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-22/watchers",
            "watchCount": 1,
            "isWatching": false
        },
        "created": "2017-06-07T18:19:36.000+0300",
        "updated": "2017-06-07T18:19:36.000+0300",
        "timeoriginalestimate": null,
        "description": null,
        "summary": "Mobile Test 2",
        "customfield_10240": null,
        "customfield_10241": null,
        "customfield_10000": "com",
        "environment": null,
        "customfield_10238": null,
        "customfield_10513": [],
        "customfield_10514": [],
        "customfield_10516": [],
        "duedate": null,
        "customfield_10519": null
    }
},
{
    "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
    "id": "10160",
    "self": "https://pr.myproject.net/sd/rest/api/2/issue/10160",
    "key": "WO-21",
    "fields": {
        "customfield_10230": null,
        "fixVersions": [],
        "customfield_10231": null,
        "resolution": {
            "self": "https://pr.myproject.net/sd/rest/api/2/resolution/10100",
            "id": "10100",
            "description": "This issue was not approved.",
            "name": "Declined"
        },
        "customfield_10510": [],
        "customfield_10503": [],
        "customfield_10229": null,
        "lastViewed": null,
        "customfield_10220": null,
        "priority": null,
        "customfield_10100": null,
        "customfield_10101": null,
        "labels": [],
        "timeestimate": null,
        "versions": [],
        "customfield_10219": null,
        "issuelinks": [],
        "assignee": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=crewManagerTest",
            "name": "crewManagerTest",
            "key": "crewmanagertest",
            "emailAddress": "crewManagerTest@crewManagerTest.com",
            "avatarUrls": {
                "48x48": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=48",
                "24x24": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=24"
            },
            "displayName": "crewManagerTest",
            "active": true,
            "timeZone": "Europe"
        },
        "status": {
            "self": "https://pr.myproject.net/sd/rest/api/2/status/10145",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/images/icons/statuses/generic.png",
            "name": "Rejected",
            "id": "10145",
            "statusCategory": {
                "self": "https://pr.myproject.net/sd/rest/api/2/statuscategory/3",
                "id": 3,
                "key": "done",
                "colorName": "green",
                "name": "Done"
            }
        },
        "components": [],
        "customfield_10296": "CF-38",
        "customfield_10603": null,
        "aggregatetimeestimate": null,
        "customfield_10604": "0",
        "customfield_10606": "",
        "creator": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10280": null,
        "subtasks": [],
        "reporter": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10285": null,
        "customfield_10286": null,
        "aggregateprogress": {
            "progress": 0,
            "total": 0
        },
        "progress": {
            "progress": 0,
            "total": 0
        },
        "votes": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-21/votes",
            "votes": 0,
            "hasVoted": false
        },
        "issuetype": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issuetype/10116",
            "id": "10116",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/secure/viewavatar?size=xsmall&avatarId=10300&avatarType=issuetype",
            "name": "Survey",
            "subtask": false,
            "avatarId": 10300
        },
        "customfield_10270": null,
        "timespent": null,
        "customfield_10271": null,
        "customfield_10272": null,
        "customfield_10273": null,
        "project": {
            "self": "https://pr.myproject.net/sd/rest/api/2/project/10103",
            "id": "10103",
            "key": "WO",
            "name": "Field Service",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/projectavatar?avatarId=10324",
                "24x24": "https://pr.myproject.net/sd/secure/projectavatar?size=small&avatarId=10324"
            }
        },
        "customfield_10275": null,
        "aggregatetimespent": null,
        "resolutiondate": "2017-11-27T15:43:43.000+0200",
        "workratio": -1,
        "watches": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-21/watchers",
            "watchCount": 1,
            "isWatching": false
        },
        "created": "2017-06-07T14:44:34.000+0300",
        "updated": "2017-11-27T15:43:43.000+0200",
        "timeoriginalestimate": null,
        "description": null,
        "summary": "Mobile Test",
        "customfield_10240": null,
        "customfield_10241": null,
        "customfield_10000": "com",
        "environment": null,
        "customfield_10238": null,
        "customfield_10513": [],
        "customfield_10514": [],
        "customfield_10516": [],
        "duedate": null,
        "customfield_10519": null
    }
},
{
    "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
    "id": "10158",
    "self": "https://pr.myproject.net/sd/rest/api/2/issue/10158",
    "key": "WO-20",
    "fields": {
        "customfield_10230": null,
        "fixVersions": [],
        "customfield_10231": null,
        "resolution": {
            "self": "https://pr.myproject.net/sd/rest/api/2/resolution/10000",
            "id": "10000",
            "description": "Work has been completed on this issue.",
            "name": "Done"
        },
        "customfield_10510": [],
        "customfield_10503": [],
        "customfield_10229": null,
        "lastViewed": null,
        "customfield_10220": null,
        "priority": null,
        "customfield_10100": null,
        "customfield_10101": null,
        "labels": [],
        "timeestimate": null,
        "versions": [],
        "customfield_10219": null,
        "issuelinks": [],
        "assignee": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=crewManagerTest",
            "name": "crewManagerTest",
            "key": "crewmanagertest",
            "emailAddress": "crewManagerTest@crewManagerTest.com",
            "avatarUrls": {
                "48x48": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=48",
                "24x24": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=24"
            },
            "displayName": "crewManagerTest",
            "active": true,
            "timeZone": "Europe"
        },
        "status": {
            "self": "https://pr.myproject.net/sd/rest/api/2/status/10001",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/images/icons/status_generic.gif",
            "name": "Done",
            "id": "10001",
            "statusCategory": {
                "self": "https://pr.myproject.net/sd/rest/api/2/statuscategory/3",
                "id": 3,
                "key": "done",
                "colorName": "green",
                "name": "Done"
            }
        },
        "components": [],
        "customfield_10296": "CF-37",
        "customfield_10603": null,
        "aggregatetimeestimate": null,
        "customfield_10604": "0",
        "customfield_10606": "",
        "creator": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10280": null,
        "subtasks": [],
        "reporter": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10285": null,
        "customfield_10286": null,
        "aggregateprogress": {
            "progress": 0,
            "total": 0
        },
        "progress": {
            "progress": 0,
            "total": 0
        },
        "votes": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-20/votes",
            "votes": 0,
            "hasVoted": false
        },
        "issuetype": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issuetype/10116",
            "id": "10116",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/secure/viewavatar?size=xsmall&avatarId=10300&avatarType=issuetype",
            "name": "Survey",
            "subtask": false,
            "avatarId": 10300
        },
        "customfield_10270": null,
        "timespent": null,
        "customfield_10271": null,
        "customfield_10272": null,
        "customfield_10273": null,
        "project": {
            "self": "https://pr.myproject.net/sd/rest/api/2/project/10103",
            "id": "10103",
            "key": "WO",
            "name": "Field Service",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/projectavatar?avatarId=10324",
                "24x24": "https://pr.myproject.net/sd/secure/projectavatar?size=small&avatarId=10324"
            }
        },
        "customfield_10275": null,
        "aggregatetimespent": null,
        "resolutiondate": "2017-06-07T14:29:33.000+0300",
        "workratio": -1,
        "watches": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-20/watchers",
            "watchCount": 1,
            "isWatching": false
        },
        "created": "2017-06-07T14:07:26.000+0300",
        "updated": "2017-06-07T14:56:58.000+0300",
        "timeoriginalestimate": null,
        "description": "Test Description",
        "summary": "Test Summary",
        "customfield_10240": null,
        "customfield_10241": null,
        "customfield_10000": "com",
        "environment": null,
        "customfield_10238": null,
        "customfield_10513": [],
        "customfield_10514": [],
        "customfield_10516": [],
        "duedate": null,
        "customfield_10519": null
    }
}]
```

<p>}
i'm trying to read with this code:</p>

```JObject oJson = JObject.Parse(json);
var issueList = (from colIssies in oJson["expand"]["issues"]
select colIssies).ToList();
```

but i get this error: System.InvalidOperationException: 'Cannot access child value on Newtonsoft.Json.Linq.JValue.'
Can anyone, help me?
Thank you in advance.

答:
There are many ways you can deserialize json to an object, it all boils down to what do you need to do with the data afterwards.
Let's imagine that you need only a subset of the data, therefore you can deserialize to an anonymous object with a given template (using json.net)

```<code>var definition = new
{
    expand = default(string),
    startAt = default(int),
    maxResults = default(int),
    total = default(int),
    issues = new []{
        new {
            expand = default(string),
            id = default(int),
            key = default(string),
            fields = new {
                created = default(DateTimeOffset),
                creator = new {
                    name = default(string),
                },
                assignee = new {
                    name = default(string),
                    key = default(string),
                    emailAddress = default(string),
                    displayName = default(string),
                    timeZone = default(string),
                },
                project = new {
                    name = default(string),
                },
                issuetype = new {
                    name = default(string),
                },
                status = new {
                    id = default(int),
                    name = default(string),
                },
            },
            etc= "..."
        }
    }
};
</code>```

and then you have the flexibility to project the extracted data to any given shape

```<code>var instance = JsonConvert.DeserializeAnonymousType(data, definition);

var projection = from issue in instance.issues
                 let date = issue.fields?.created
                 where date <= DateTime.Now
                 select new
                 {
                     id = issue.id,
                     key = issue.key,
                     type = issue.fields?.issuetype?.name,
                     created = issue.fields?.created,
                     project = issue.fields?.project?.name,
                     creator = issue.fields?.creator?.name,
                     assignee = issue.fields?.assignee?.name,
                     status = issue.fields?.status?.name,
                 };
</code>```

with full intellisense support of course

Body:
I'm new to json logic and i have a complicate json, that i must read from a url and to bind into a datagrid using c#.

My json file:

 {
"expand": "schema,names",
"startAt": 0,
"maxResults": 50,
"total": 6,
"issues": [{
    "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
    "id": "10502",
    "self": "https://pr.myproject.net/sd/rest/api/2/issue/10502",
    "key": "WO-60",
    "fields": {
        "customfield_10230": null,
        "fixVersions": [],
        "customfield_10231": null,
        "resolution": null,
        "customfield_10510": [],
        "customfield_10229": null,
        "lastViewed": null,
        "customfield_10220": null,
        "priority": null,
        "customfield_10100": null,
        "customfield_10101": null,
        "labels": [],
        "timeestimate": null,
        "versions": [],
        "customfield_10219": null,
        "issuelinks": [],
        "assignee": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=crewManagerTest",
            "name": "crewManagerTest",
            "key": "crewmanagertest",
            "emailAddress": "crewManagerTest@crewManagerTest.com",
            "avatarUrls": {
                "48x48": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=48",
                "24x24": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=24"
            },
            "displayName": "crewManagerTest",
            "active": true,
            "timeZone": "Europe"
        },
        "status": {
            "self": "https://pr.myproject.net/sd/rest/api/2/status/10000",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/images/icons/status_generic.gif",
            "name": "To Do",
            "id": "10000",
            "statusCategory": {
                "self": "https://pr.myproject.net/sd/rest/api/2/statuscategory/2",
                "id": 2,
                "key": "new",
                "colorName": "blue-gray",
                "name": "To Do"
            }
        },
        "components": [],
        "customfield_10296": "CF-38",
        "customfield_10603": "10502",
        "aggregatetimeestimate": null,
        "customfield_10604": "0",
        "customfield_10606": "",
        "creator": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10280": null,
        "subtasks": [],
        "reporter": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10285": null,
        "customfield_10286": null,
        "aggregateprogress": {
            "progress": 0,
            "total": 0
        },
        "progress": {
            "progress": 0,
            "total": 0
        },
        "votes": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-60/votes",
            "votes": 0,
            "hasVoted": false
        },
        "issuetype": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issuetype/10116",
            "id": "10116",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/secure/viewavatar?size=xsmall&avatarId=10300&avatarType=issuetype",
            "name": "Survey",
            "subtask": false,
            "avatarId": 10300
        },
        "customfield_10270": null,
        "timespent": null,
        "customfield_10271": null,
        "customfield_10272": null,
        "customfield_10273": null,
        "project": {
            "self": "https://pr.myproject.net/sd/rest/api/2/project/10103",
            "id": "10103",
            "key": "WO",
            "name": "Field Service",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/projectavatar?avatarId=10324",
                "24x24": "https://pr.myproject.net/sd/secure/projectavatar?size=small&avatarId=10324"
            }
        },
        "customfield_10275": null,
        "aggregatetimespent": null,
        "resolutiondate": null,
        "workratio": -1,
        "watches": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-60/watchers",
            "watchCount": 1,
            "isWatching": false
        },
        "created": "2017-11-27T15:44:49.000+0200",
        "updated": "2017-11-27T15:44:50.000+0200",
        "timeoriginalestimate": null,
        "description": null,
        "summary": "Mobile Test",
        "customfield_10240": null,
        "customfield_10241": null,
        "customfield_10000": "com",
        "environment": null,
        "customfield_10238": null,
        "customfield_10513": [],
        "customfield_10514": [],
        "customfield_10516": [],
        "duedate": null,
        "customfield_10519": null
    }
},
{
    "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
    "id": "10166",
    "self": "https://pr.myproject.net/sd/rest/api/2/issue/10166",
    "key": "WO-24",
    "fields": {
        "customfield_10230": null,
        "fixVersions": [],
        "customfield_10231": null,
        "resolution": {
            "self": "https://pr.myproject.net/sd/rest/api/2/resolution/10100",
            "id": "10100",
            "description": "This issue was not approved.",
            "name": "Declined"
        },
        "customfield_10510": [],
        "customfield_10503": [],
        "customfield_10229": null,
        "lastViewed": null,
        "customfield_10220": null,
        "priority": null,
        "customfield_10100": null,
        "customfield_10101": null,
        "labels": [],
        "timeestimate": null,
        "versions": [],
        "customfield_10219": null,
        "issuelinks": [],
        "assignee": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=crewManagerTest",
            "name": "crewManagerTest",
            "key": "crewmanagertest",
            "emailAddress": "crewManagerTest@crewManagerTest.com",
            "avatarUrls": {
                "48x48": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=48",
                "24x24": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=24"
            },
            "displayName": "crewManagerTest",
            "active": true,
            "timeZone": "Europe"
        },
        "status": {
            "self": "https://pr.myproject.net/sd/rest/api/2/status/10145",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/images/icons/statuses/generic.png",
            "name": "Rejected",
            "id": "10145",
            "statusCategory": {
                "self": "https://pr.myproject.net/sd/rest/api/2/statuscategory/3",
                "id": 3,
                "key": "done",
                "colorName": "green",
                "name": "Done"
            }
        },
        "components": [],
        "customfield_10296": "CF-41",
        "customfield_10603": null,
        "aggregatetimeestimate": null,
        "customfield_10604": "0",
        "customfield_10606": "",
        "creator": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10280": null,
        "subtasks": [],
        "reporter": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10285": null,
        "customfield_10286": null,
        "aggregateprogress": {
            "progress": 0,
            "total": 0
        },
        "progress": {
            "progress": 0,
            "total": 0
        },
        "votes": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-24/votes",
            "votes": 0,
            "hasVoted": false
        },
        "issuetype": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issuetype/10116",
            "id": "10116",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/secure/viewavatar?size=xsmall&avatarId=10300&avatarType=issuetype",
            "name": "Survey",
            "subtask": false,
            "avatarId": 10300
        },
        "customfield_10270": null,
        "timespent": null,
        "customfield_10271": null,
        "customfield_10272": null,
        "customfield_10273": null,
        "project": {
            "self": "https://pr.myproject.net/sd/rest/api/2/project/10103",
            "id": "10103",
            "key": "WO",
            "name": "Field Service",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/projectavatar?avatarId=10324",
                "24x24": "https://pr.myproject.net/sd/secure/projectavatar?size=small&avatarId=10324"
            }
        },
        "customfield_10275": null,
        "aggregatetimespent": null,
        "resolutiondate": "2017-07-02T15:05:20.000+0300",
        "workratio": -1,
        "watches": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-24/watchers",
            "watchCount": 1,
            "isWatching": false
        },
        "created": "2017-06-07T18:23:03.000+0300",
        "updated": "2017-07-02T15:05:20.000+0300",
        "timeoriginalestimate": null,
        "description": null,
        "summary": "Mobile Test 4",
        "customfield_10240": null,
        "customfield_10241": null,
        "customfield_10000": "com",
        "environment": null,
        "customfield_10238": null,
        "customfield_10513": [],
        "customfield_10514": [],
        "customfield_10516": [],
        "duedate": null,
        "customfield_10519": null
    }
},
{
    "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
    "id": "10164",
    "self": "https://pr.myproject.net/sd/rest/api/2/issue/10164",
    "key": "WO-23",
    "fields": {
        "customfield_10230": null,
        "fixVersions": [],
        "customfield_10231": null,
        "resolution": {
            "self": "https://pr.myproject.net/sd/rest/api/2/resolution/10100",
            "id": "10100",
            "description": "This issue was not approved.",
            "name": "Declined"
        },
        "customfield_10510": [],
        "customfield_10503": [],
        "customfield_10229": null,
        "lastViewed": null,
        "customfield_10220": null,
        "priority": null,
        "customfield_10100": null,
        "customfield_10101": null,
        "labels": [],
        "timeestimate": null,
        "versions": [],
        "customfield_10219": null,
        "issuelinks": [],
        "assignee": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=crewManagerTest",
            "name": "crewManagerTest",
            "key": "crewmanagertest",
            "emailAddress": "crewManagerTest@crewManagerTest.com",
            "avatarUrls": {
                "48x48": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=48",
                "24x24": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=24"
            },
            "displayName": "crewManagerTest",
            "active": true,
            "timeZone": "Europe"
        },
        "status": {
            "self": "https://pr.myproject.net/sd/rest/api/2/status/10145",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/images/icons/statuses/generic.png",
            "name": "Rejected",
            "id": "10145",
            "statusCategory": {
                "self": "https://pr.myproject.net/sd/rest/api/2/statuscategory/3",
                "id": 3,
                "key": "done",
                "colorName": "green",
                "name": "Done"
            }
        },
        "components": [],
        "customfield_10296": "CF-40",
        "customfield_10603": null,
        "aggregatetimeestimate": null,
        "customfield_10604": "0",
        "customfield_10606": "",
        "creator": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10280": null,
        "subtasks": [],
        "reporter": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10285": null,
        "customfield_10286": null,
        "aggregateprogress": {
            "progress": 0,
            "total": 0
        },
        "progress": {
            "progress": 0,
            "total": 0
        },
        "votes": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-23/votes",
            "votes": 0,
            "hasVoted": false
        },
        "issuetype": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issuetype/10116",
            "id": "10116",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/secure/viewavatar?size=xsmall&avatarId=10300&avatarType=issuetype",
            "name": "Survey",
            "subtask": false,
            "avatarId": 10300
        },
        "customfield_10270": null,
        "timespent": null,
        "customfield_10271": null,
        "customfield_10272": null,
        "customfield_10273": null,
        "project": {
            "self": "https://pr.myproject.net/sd/rest/api/2/project/10103",
            "id": "10103",
            "key": "WO",
            "name": "Field Service",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/projectavatar?avatarId=10324",
                "24x24": "https://pr.myproject.net/sd/secure/projectavatar?size=small&avatarId=10324"
            }
        },
        "customfield_10275": null,
        "aggregatetimespent": null,
        "resolutiondate": "2017-07-02T15:10:40.000+0300",
        "workratio": -1,
        "watches": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-23/watchers",
            "watchCount": 1,
            "isWatching": false
        },
        "created": "2017-06-07T18:21:24.000+0300",
        "updated": "2017-07-02T15:10:40.000+0300",
        "timeoriginalestimate": null,
        "description": null,
        "summary": "Mobile Test 3",
        "customfield_10240": null,
        "customfield_10241": null,
        "customfield_10000": "com",
        "environment": null,
        "customfield_10238": null,
        "customfield_10513": [],
        "customfield_10514": [],
        "customfield_10516": [],
        "duedate": null,
        "customfield_10519": null
    }
},
{
    "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
    "id": "10162",
    "self": "https://pr.myproject.net/sd/rest/api/2/issue/10162",
    "key": "WO-22",
    "fields": {
        "customfield_10230": null,
        "fixVersions": [],
        "customfield_10231": null,
        "resolution": null,
        "customfield_10510": [],
        "customfield_10503": [],
        "customfield_10229": null,
        "lastViewed": "2017-12-01T02:07:05.368+0200",
        "customfield_10220": null,
        "priority": null,
        "customfield_10100": null,
        "customfield_10101": null,
        "labels": [],
        "timeestimate": null,
        "versions": [],
        "customfield_10219": null,
        "issuelinks": [],
        "assignee": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=crewManagerTest",
            "name": "crewManagerTest",
            "key": "crewmanagertest",
            "emailAddress": "crewManagerTest@crewManagerTest.com",
            "avatarUrls": {
                "48x48": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=48",
                "24x24": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=24"
            },
            "displayName": "crewManagerTest",
            "active": true,
            "timeZone": "Europe"
        },
        "status": {
            "self": "https://pr.myproject.net/sd/rest/api/2/status/10000",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/images/icons/status_generic.gif",
            "name": "To Do",
            "id": "10000",
            "statusCategory": {
                "self": "https://pr.myproject.net/sd/rest/api/2/statuscategory/2",
                "id": 2,
                "key": "new",
                "colorName": "blue-gray",
                "name": "To Do"
            }
        },
        "components": [],
        "customfield_10296": "CF-39",
        "customfield_10603": null,
        "aggregatetimeestimate": null,
        "customfield_10604": "0",
        "customfield_10606": "",
        "creator": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10280": null,
        "subtasks": [],
        "reporter": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10285": null,
        "customfield_10286": null,
        "aggregateprogress": {
            "progress": 0,
            "total": 0
        },
        "progress": {
            "progress": 0,
            "total": 0
        },
        "votes": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-22/votes",
            "votes": 0,
            "hasVoted": false
        },
        "issuetype": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issuetype/10116",
            "id": "10116",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/secure/viewavatar?size=xsmall&avatarId=10300&avatarType=issuetype",
            "name": "Survey",
            "subtask": false,
            "avatarId": 10300
        },
        "customfield_10270": null,
        "timespent": null,
        "customfield_10271": null,
        "customfield_10272": null,
        "customfield_10273": null,
        "project": {
            "self": "https://pr.myproject.net/sd/rest/api/2/project/10103",
            "id": "10103",
            "key": "WO",
            "name": "Field Service",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/projectavatar?avatarId=10324",
                "24x24": "https://pr.myproject.net/sd/secure/projectavatar?size=small&avatarId=10324"
            }
        },
        "customfield_10275": null,
        "aggregatetimespent": null,
        "resolutiondate": null,
        "workratio": -1,
        "watches": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-22/watchers",
            "watchCount": 1,
            "isWatching": false
        },
        "created": "2017-06-07T18:19:36.000+0300",
        "updated": "2017-06-07T18:19:36.000+0300",
        "timeoriginalestimate": null,
        "description": null,
        "summary": "Mobile Test 2",
        "customfield_10240": null,
        "customfield_10241": null,
        "customfield_10000": "com",
        "environment": null,
        "customfield_10238": null,
        "customfield_10513": [],
        "customfield_10514": [],
        "customfield_10516": [],
        "duedate": null,
        "customfield_10519": null
    }
},
{
    "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
    "id": "10160",
    "self": "https://pr.myproject.net/sd/rest/api/2/issue/10160",
    "key": "WO-21",
    "fields": {
        "customfield_10230": null,
        "fixVersions": [],
        "customfield_10231": null,
        "resolution": {
            "self": "https://pr.myproject.net/sd/rest/api/2/resolution/10100",
            "id": "10100",
            "description": "This issue was not approved.",
            "name": "Declined"
        },
        "customfield_10510": [],
        "customfield_10503": [],
        "customfield_10229": null,
        "lastViewed": null,
        "customfield_10220": null,
        "priority": null,
        "customfield_10100": null,
        "customfield_10101": null,
        "labels": [],
        "timeestimate": null,
        "versions": [],
        "customfield_10219": null,
        "issuelinks": [],
        "assignee": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=crewManagerTest",
            "name": "crewManagerTest",
            "key": "crewmanagertest",
            "emailAddress": "crewManagerTest@crewManagerTest.com",
            "avatarUrls": {
                "48x48": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=48",
                "24x24": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=24"
            },
            "displayName": "crewManagerTest",
            "active": true,
            "timeZone": "Europe"
        },
        "status": {
            "self": "https://pr.myproject.net/sd/rest/api/2/status/10145",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/images/icons/statuses/generic.png",
            "name": "Rejected",
            "id": "10145",
            "statusCategory": {
                "self": "https://pr.myproject.net/sd/rest/api/2/statuscategory/3",
                "id": 3,
                "key": "done",
                "colorName": "green",
                "name": "Done"
            }
        },
        "components": [],
        "customfield_10296": "CF-38",
        "customfield_10603": null,
        "aggregatetimeestimate": null,
        "customfield_10604": "0",
        "customfield_10606": "",
        "creator": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10280": null,
        "subtasks": [],
        "reporter": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10285": null,
        "customfield_10286": null,
        "aggregateprogress": {
            "progress": 0,
            "total": 0
        },
        "progress": {
            "progress": 0,
            "total": 0
        },
        "votes": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-21/votes",
            "votes": 0,
            "hasVoted": false
        },
        "issuetype": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issuetype/10116",
            "id": "10116",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/secure/viewavatar?size=xsmall&avatarId=10300&avatarType=issuetype",
            "name": "Survey",
            "subtask": false,
            "avatarId": 10300
        },
        "customfield_10270": null,
        "timespent": null,
        "customfield_10271": null,
        "customfield_10272": null,
        "customfield_10273": null,
        "project": {
            "self": "https://pr.myproject.net/sd/rest/api/2/project/10103",
            "id": "10103",
            "key": "WO",
            "name": "Field Service",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/projectavatar?avatarId=10324",
                "24x24": "https://pr.myproject.net/sd/secure/projectavatar?size=small&avatarId=10324"
            }
        },
        "customfield_10275": null,
        "aggregatetimespent": null,
        "resolutiondate": "2017-11-27T15:43:43.000+0200",
        "workratio": -1,
        "watches": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-21/watchers",
            "watchCount": 1,
            "isWatching": false
        },
        "created": "2017-06-07T14:44:34.000+0300",
        "updated": "2017-11-27T15:43:43.000+0200",
        "timeoriginalestimate": null,
        "description": null,
        "summary": "Mobile Test",
        "customfield_10240": null,
        "customfield_10241": null,
        "customfield_10000": "com",
        "environment": null,
        "customfield_10238": null,
        "customfield_10513": [],
        "customfield_10514": [],
        "customfield_10516": [],
        "duedate": null,
        "customfield_10519": null
    }
},
{
    "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
    "id": "10158",
    "self": "https://pr.myproject.net/sd/rest/api/2/issue/10158",
    "key": "WO-20",
    "fields": {
        "customfield_10230": null,
        "fixVersions": [],
        "customfield_10231": null,
        "resolution": {
            "self": "https://pr.myproject.net/sd/rest/api/2/resolution/10000",
            "id": "10000",
            "description": "Work has been completed on this issue.",
            "name": "Done"
        },
        "customfield_10510": [],
        "customfield_10503": [],
        "customfield_10229": null,
        "lastViewed": null,
        "customfield_10220": null,
        "priority": null,
        "customfield_10100": null,
        "customfield_10101": null,
        "labels": [],
        "timeestimate": null,
        "versions": [],
        "customfield_10219": null,
        "issuelinks": [],
        "assignee": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=crewManagerTest",
            "name": "crewManagerTest",
            "key": "crewmanagertest",
            "emailAddress": "crewManagerTest@crewManagerTest.com",
            "avatarUrls": {
                "48x48": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=48",
                "24x24": "https://secure.myproject.com/avatar/208c23b0f1be06c82402c1548a463e3e?d=mm&s=24"
            },
            "displayName": "crewManagerTest",
            "active": true,
            "timeZone": "Europe"
        },
        "status": {
            "self": "https://pr.myproject.net/sd/rest/api/2/status/10001",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/images/icons/status_generic.gif",
            "name": "Done",
            "id": "10001",
            "statusCategory": {
                "self": "https://pr.myproject.net/sd/rest/api/2/statuscategory/3",
                "id": 3,
                "key": "done",
                "colorName": "green",
                "name": "Done"
            }
        },
        "components": [],
        "customfield_10296": "CF-37",
        "customfield_10603": null,
        "aggregatetimeestimate": null,
        "customfield_10604": "0",
        "customfield_10606": "",
        "creator": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10280": null,
        "subtasks": [],
        "reporter": {
            "self": "https://pr.myproject.net/sd/rest/api/2/user?username=atlas",
            "name": "atlas",
            "key": "atlas",
            "emailAddress": "me@myproject.com",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/useravatar?ownerId=atlas&avatarId=10609",
                "24x24": "https://pr.myproject.net/sd/secure/useravatar?size=small&ownerId=atlas&avatarId=10609"
            },
            "displayName": "JIRA user",
            "active": true,
            "timeZone": "Europe"
        },
        "customfield_10285": null,
        "customfield_10286": null,
        "aggregateprogress": {
            "progress": 0,
            "total": 0
        },
        "progress": {
            "progress": 0,
            "total": 0
        },
        "votes": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-20/votes",
            "votes": 0,
            "hasVoted": false
        },
        "issuetype": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issuetype/10116",
            "id": "10116",
            "description": "",
            "iconUrl": "https://pr.myproject.net/sd/secure/viewavatar?size=xsmall&avatarId=10300&avatarType=issuetype",
            "name": "Survey",
            "subtask": false,
            "avatarId": 10300
        },
        "customfield_10270": null,
        "timespent": null,
        "customfield_10271": null,
        "customfield_10272": null,
        "customfield_10273": null,
        "project": {
            "self": "https://pr.myproject.net/sd/rest/api/2/project/10103",
            "id": "10103",
            "key": "WO",
            "name": "Field Service",
            "avatarUrls": {
                "48x48": "https://pr.myproject.net/sd/secure/projectavatar?avatarId=10324",
                "24x24": "https://pr.myproject.net/sd/secure/projectavatar?size=small&avatarId=10324"
            }
        },
        "customfield_10275": null,
        "aggregatetimespent": null,
        "resolutiondate": "2017-06-07T14:29:33.000+0300",
        "workratio": -1,
        "watches": {
            "self": "https://pr.myproject.net/sd/rest/api/2/issue/WO-20/watchers",
            "watchCount": 1,
            "isWatching": false
        },
        "created": "2017-06-07T14:07:26.000+0300",
        "updated": "2017-06-07T14:56:58.000+0300",
        "timeoriginalestimate": null,
        "description": "Test Description",
        "summary": "Test Summary",
        "customfield_10240": null,
        "customfield_10241": null,
        "customfield_10000": "com",
        "environment": null,
        "customfield_10238": null,
        "customfield_10513": [],
        "customfield_10514": [],
        "customfield_10516": [],
        "duedate": null,
        "customfield_10519": null
    }
}]

}
i'm trying to read with this code:

JObject oJson = JObject.Parse(json);
var issueList = (from colIssies in oJson["expand"]["issues"]
select colIssies).ToList();

but i get this error: System.InvalidOperationException: 'Cannot access child value on Newtonsoft.Json.Linq.JValue.'
Can anyone, help me?
Thank you in advance.

Body:
There are many ways you can deserialize json to an object, it all boils down to what do you need to do with the data afterwards.
Let's imagine that you need only a subset of the data, therefore you can deserialize to an anonymous object with a given template (using json.net)

var definition = new
{
    expand = default(string),
    startAt = default(int),
    maxResults = default(int),
    total = default(int),
    issues = new []{
        new {
            expand = default(string),
            id = default(int),
            key = default(string),
            fields = new {
                created = default(DateTimeOffset),
                creator = new {
                    name = default(string),
                },
                assignee = new {
                    name = default(string),
                    key = default(string),
                    emailAddress = default(string),
                    displayName = default(string),
                    timeZone = default(string),
                },
                project = new {
                    name = default(string),
                },
                issuetype = new {
                    name = default(string),
                },
                status = new {
                    id = default(int),
                    name = default(string),
                },
            },
            etc= "..."
        }
    }
};

and then you have the flexibility to project the extracted data to any given shape

var instance = JsonConvert.DeserializeAnonymousType(data, definition);

var projection = from issue in instance.issues
                 let date = issue.fields?.created
                 where date <= DateTime.Now
                 select new
                 {
                     id = issue.id,
                     key = issue.key,
                     type = issue.fields?.issuetype?.name,
                     created = issue.fields?.created,
                     project = issue.fields?.project?.name,
                     creator = issue.fields?.creator?.name,
                     assignee = issue.fields?.assignee?.name,
                     status = issue.fields?.status?.name,
                 };

with full intellisense support of course


问:
How can I loop over true values in Python
I have a boolean array in python and I want to do a calculation on the cells where the value is 'true'. Currently I am using a nested for loop to go trough all the cells to find the cells with the true values. However, running the program takes a lot of time. I was wondering wether there is a faster way to do this?

```<code>for i in range (0,latstep):
    for j in range (0,lonstep):
        if coastline[i,j] == True:
        ...
</code>```

Thanks for your help!

答:
You might consider using concurrent.map() or similar to process the array elements in parallel. Always assuming there aren't dependencies between
the elements.

Another possibility is maintaining a list of the 'true' values when you initially calculate them:

```<code>coastlineCache = []

c = foo()
coastline[i][j] = c

if (c):
    coastlineCache.append(c)

// later

for (c in coastlineCache):
    process_true_item(c)
</code>```

If, as you've alluded to above, you need the array indices, cache them as a tuple:

```<code>coastlineCache = []

c = foo()
coastline[i][j] = c
if (c):
    coastlineCache.append((i, j))

// later

for (c in coastlineCache):
    process_true_item(c[0], c[1]) # e.g. (i, j)
</code>```

Body:
I have a boolean array in python and I want to do a calculation on the cells where the value is 'true'. Currently I am using a nested for loop to go trough all the cells to find the cells with the true values. However, running the program takes a lot of time. I was wondering wether there is a faster way to do this?

for i in range (0,latstep):
    for j in range (0,lonstep):
        if coastline[i,j] == True:
        ...

Thanks for your help!

Body:
You might consider using concurrent.map() or similar to process the array elements in parallel. Always assuming there aren't dependencies between
the elements.

Another possibility is maintaining a list of the 'true' values when you initially calculate them:

coastlineCache = []

c = foo()
coastline[i][j] = c

if (c):
    coastlineCache.append(c)

// later

for (c in coastlineCache):
    process_true_item(c)

If, as you've alluded to above, you need the array indices, cache them as a tuple:

coastlineCache = []

c = foo()
coastline[i][j] = c
if (c):
    coastlineCache.append((i, j))

// later

for (c in coastlineCache):
    process_true_item(c[0], c[1]) # e.g. (i, j)