Hi   query { useCompany(no: 4655191) { companyChangeLog(filter: {_and :[ {logType :{_eq : 1}}, {tableNo :{_eq : 152}}, {columnNo :{_eq : 4084}}, { changedDateTime : {_gte: "2023-09-05T01:10:07"}} ]}, sortOrder: {createdDate: DESC _thenBy: {createdTime: DESC}}) { items { logType tableNo columnNo newValue previousValue changedDateTime primaryKey } } } }   results in: { "data": { "useCompany": { "companyChangeLog": { "items": [ { "logType": 2, "tableNo": 170, "columnNo": 5703, "newValue": "2031", "previousValue": "0", "changedDateTime": "2023-09-05T12:08:00", "primaryKey": "(Cap. asset no.) 12950" }, { "logType": 2, "tableNo": 170, "columnNo": 9575, "newValue": "21", "previousValue": "", "changedDateTime": "2023-09-05T12:08:00", "primaryKey": "(Cap. asset no.) 12950" } ] } } }, "extensions": { "vbnxt-trace-id": "0000000000000000e4efa4f3e7a6f641" } }  It seems like the changeddatetime-filter overrides the other filters. Is there something wrong with my query? When I remove the datetimefilter I get the right tableid and column but I also need the filtering on lastchanged...   Florian   ... View more

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    ... View more

Hi   we used to copy some of our predefined UI-windows between or to different customers in Business OnPrem. Doing this by GraphQL would give us some excellent possibilities to do that more efficient and get our standard-windows updated all the time across the customers.   But I can't find the right tables in the sys-database for that - it seems like Windows-elements, filters, connections and so on is not used in that way any more, but I don't find the correct tables in GraphQL either.  Do you have any tips?     Florian ... View more

Hi,   I get feedback here internally that the following mutation worked yesterday  but not today:   mutation {   useCompany(no: 3542724) {   associate_create(values: [{name: "Mark Ward", addressLine1: "Test Rd 1", shortName: "Mark", customerNo: null, supplierNo: null, employeeNo_suggest_interval: {   from: 500,   to: 1000 }}, {associateNo: 1203, name: "Ron Johnson", addressLine1: "Test Rd 1", shortName: "Ron", customerNo: null, supplierNo: null, employeeNo_suggest_interval: {   from: 500,   to: 1000 }}])   {     affectedRows     items {       associateNo, customerNo, supplierNo, employeeNo, name, shortName     }    }   } }   Results in following error-messages today:   {     "errors": [         {             "message": "Error: SQL command no. 2413 failed.Error: Database error.",             "path": [                 "useCompany",                 "associate_create",                 "values/0"             ],             "extensions": {                 "data": {                     "status": 0                 }             }         },         {             "message": "Error: SQL command no. 2413 failed.Error: Database error.",             "path": [                 "useCompany",                 "associate_create",                 "values/0"             ],             "extensions": {                 "data": {                     "status": 0                 }             }         },         {             "message": "Error: SQL command no. 2413 failed.Error: Database error.",             "path": [                 "useCompany",                 "associate_create",                 "values/0"             ],             "extensions": {                 "data": {                     "status": 0                 }             }         },         {             "message": "Error: With multiple account no series and use of account no series activated, use SuggestValueInInterval instead.",             "path": [                 "useCompany",                 "associate_create",                 "values/0"             ],             "extensions": {                 "data": {                     "status": 0                 }             }         },         {             "message": "Error: SQL command no. 2413 failed.Error: Database error.",             "path": [                 "useCompany",                 "associate_create",                 "values/0"             ],             "extensions": {                 "data": {                     "status": 0                 }             }         },         {             "message": "Error: SQL command no. 2413 failed.Error: Database error.",             "path": [                 "useCompany",                 "associate_create",                 "values/0"             ],             "extensions": {                 "data": {                     "status": 0                 }             }         },         {             "message": "A record with the same primary key already exists.",             "path": [                 "useCompany",                 "associate_create",                 "values/1"             ],             "extensions": {                 "data": {                     "status": 3                 }             }         }     ],     "data": {         "useCompany": {             "associate_create": {                 "affectedRows": 0,                 "items": null             }         }     },     "extensions": {         "vbnxt-trace-id": "00000000000000009f8bb9cc66e8e794"     } } ... View more

Hi,   does the joindown between the orgunits work in the API?   Example: query { useCompany(no: 4655191) { orgUnit8(sortOrder: {createdDate: ASC _thenBy: {createdTime: ASC}}) { items { orgUnit8No orgUnit1 name joindown_OrgUnit1_via_OrgUnit8{ items{ orgUnit1No name } } } } } }   Results in: .... { "orgUnit8No": "A1000AD", "orgUnit1": 1000, "name": "Christine XXXXXXX XXXXXXXXXX", "joindown_OrgUnit1_via_OrgUnit8": { "items": null } When orgUnit1 = 1000 then it also should be able to get the name from orgUnit1 in the joindown?   Florian   ... View more

Hi   we had in Business OnPrem modules for adjusting the accounting balance for used currencies by the actual currencyrate on given accounts and costunits. For that we need the Outgoing balance for a given period from the accountingtransactions.   That worked by something about that (not exactly):   SELECT SUM(Amount in Currency), CurrencyNo, AccountNo, CostUnits1-12 FROM GeneralLedgerTransaction GROUP BY CurrencyNo, AccountNo, CostUnit1-12No WHERE Period < YYYYMM   We try to do about the same in BNxt but I can't find a good way to do so:   1) We can get all transactions from the GeneralLedger first by filtering on Period<yyyymm - that can result in several millions of lines for distinct customers. But than we can group and summerize and all we want after that. Good solution? I don't think so   2) We can use the aggregate endpoint by setting filter on each combination of accountNumber, CostunitNumber and CurrencyNumber. (for 50 accounts, 10 currencies and 50 costUnits = 25000 API calls). Good solution?   Any better suggestions?   Florian   ... View more