Joinup on official on OrgUnit / Official

[Florian Haase]

Hi,

I can't get the joinup from orgUnit8 working on the associate by official:

query {
useCompany(no: 4655191) {
orgUnit8(sortOrder: {createdDate: ASC _thenBy: {createdTime: ASC}})
{
items {
orgUnit8No orgUnit1 name official 
joinup_Associate_via_Official {
employeeNo
associateNo
name
shortName

}

}
}
}
}

Result:

"data": {
"useCompany": {
"orgUnit8": {
"items": [
{
"orgUnit8No": "A1000",
"orgUnit1": 1000,
"name": "Avdeling 2",
"official": 14179,
"joinup_Associate_via_Official": null
},

.....

Why is the official on OrgUnit8 14179 but the result of the joinup is null - we have checked the data consistency and all seems okay. Also the UI is working on that. 

Florian 

[Øyvind Årseth]

Hey @Anonymous 

Just to be clear: The official you expect returned, it is from orgUnit8 right? My test on the same query (except the filter) seems to work fine:

query ($cid: Int!){
useCompany(no: $cid) {
    orgUnit8(filter: {orgUnit8No: {_eq:"ABC"}}, 
    sortOrder: {createdDate: ASC _thenBy: {createdTime: ASC}})
        {
        items {
            orgUnit8No
            orgUnit1
            name 
            official 
            joinup_Associate_via_Official {
                employeeNo
                associateNo
                name
                shortName}
            }
        }
    }
}
{"data": {
        "useCompany": {
            "orgUnit8": {
                "items": [
                    {
                        "orgUnit8No": "ABC",
                        "orgUnit1": 11,
                        "name": "Alfa",
                        "official": 4,
                        "joinup_Associate_via_Official": {
                            "employeeNo": 4,
                            "associateNo": 322,
                            "name": "Ole Olsen",
                            "shortName": "Ole Olsen"
                        }
....

@Florian Haase wrote:

Hi,

I can't get the joinup from orgUnit8 working on the associate by official:

query {
useCompany(no: 4655191) {
orgUnit8(sortOrder: {createdDate: ASC _thenBy: {createdTime: ASC}})
{
items {
orgUnit8No orgUnit1 name official 
joinup_Associate_via_Official {
employeeNo
associateNo
name
shortName

}

}
}
}
}

Result:

"data": {
"useCompany": {
"orgUnit8": {
"items": [
{
"orgUnit8No": "A1000",
"orgUnit1": 1000,
"name": "Avdeling 2",
"official": 14179,
"joinup_Associate_via_Official": null
},

.....

Why is the official on OrgUnit8 14179 but the result of the joinup is null - we have checked the data consistency and all seems okay. Also the UI is working on that. 

Florian 

---