Thanks! now it works again! ... View more

Is this something that will be fixed quickly, or could it take time? And which method would you prefer us to use / has the least impact on the server? Filtering on the integer value changedDate or on the date field changedDateAsDate? ... View more

This is a very good solution!  by using the field,changedDate, you can also filter on deleted last x number of days filter:{_and: [{tableNo:{_eq:127}}, {logType: {_eq:4}}]} ... View more

yes, but I need to be able to get data from around 1000-2000 orders. So I need to be able to use your first query example:    query($cid :Int!) { useCompany(no: $cid) { order( first: 100 filter: {changedDate:{_gte: 20210101}}, unoptimized :true ) { totalCount items { ...   with pageinfo on order so that I can loop through this 2000 orders with ex 100 orders at the time:    query($cid :Int!) { useCompany(no: $cid) { order( first: 100 filter: {changedDate:{_gte: 20210101}}, unoptimized :true ) { "pageInfo": { "hasNextPage": false, "startCursor": "Mw==", "endCursor": "Ng==" } totalCount items { ...   The query and import script will be to time consuming if I must loop through the joinDown tables for each order table loop... Another solution would be to query each tables in separate queries, but I will still need to join them with the order table to track lastchanged date. ... View more

One "quick fix?" solution could be to add a extra "table" I can query that only gives me a list of all orderNo currently in the order table with no restrictions for number of records returned. (will never be to big or resource-intensive since it will only return integer values and no possibility to join it with other tables).   ... View more

It works! Thanks! ... View more

I did manage to use (unoptimized: true)  to get more than 1000 orderlines in one _joindown from order (with no pagination), but is it correct that It can't be used together with a cursor / after. If so, unoptimized can't be used if you want to download 1000 orders (500 at a time) that all have 5 orderlines each. Then I still got around(500 orders * 5 orderlines = 2500 orderlines. 2500 - 1000 (max) = 1500 orderlines. 1500 / 5 =  300 orders) with no orderlines for each batch? ... View more

did you see the part about same problem when using joindown productTransaction from order? order {items {orderNo joindown_ProductTransaction_via_Order(filter:{productNo:{_eq:"1"}}) {.... as well (in case different bugs) ... View more

Yes. If I run your query for my company i get:  "joindown_PriceAndDiscountMatrix_via_Product": {"totalCount": null,"items": null} if I remove (filter: {customerPriceGroup1:{_eq:1}}) @include(if:true)  I get 3-4 rows for each product (where customerPriceGroup1 = 1 is one of them) PS: I get the same problem when trying to filter on _joindown_productTransaction_via_Order:  ex:  query abs { useCompany(no: xxx) { order( filter:{_and:[{orderNo:{_eq:XXX}}, {orderDate:{_gte:20220101}}]} sortOrder:{orderDate:ASC} ) {items {orderNo joindown_ProductTransaction_via_Order(filter:{productNo:{_eq:"1"}}) { items { productNo description quantity }}}}}} If I remove (filter:{productNo:{_eq:"1"}}) I get one result. ... View more

yes, if I remove (filter: {customerPriceGroup1:{_eq:1}})  I got 3 joindown_PriceAndDiscountMatrix_via_Product lines pr product, where one (of each product) of them customerPriceGroup1 = 1 ... View more

So how would your solution be if the task is to get 500 or 1000 orders with all orderline, product transactions and customer transactions filtered by order last modified  = last two days? And each order could contain from 1 to 200 orderlines each? I could take 10-20 orders at the time (pagination) to be sure not to exeed 1000 orderlines for each loop, but that would take a very long time... and I would not know if I got all orderlines because i don't know if the orders I'm asking for contain more than 1000 orderlines all togheter...  Another solution for me would be to first download the order headers when the orderlines, products transaction and customer transactions in separate queries, but then I still had to use joinUp with order for each of the other queries to be sure to update all orderlines for all orders that had order last changed the last two days...    Ex. This query will not return all orderlines query data3 {   useCompany(no: XXXX) {     order(       first: 100       filter: {changedDate:{_gte: 20210101}}     )     {       totalCount       items {         orderNo         orderDate         changedDateTime         createdDateTime         joindown_CustomerTransaction_via_Order                 {           items {             orderNo             invoiceNo             customerNo             voucherNo             valueDateAsDate             amountDomestic             debitAmountDomestic             creditAmountDomestic             changedDateTime             createdDateTime           }         }         joindown_ProductTransaction_via_Order{           items {             orderNo             invoiceNo             productNo             quantity           }         }         joindown_OrderLine_via_Order                 {           items {             orderNo             lineNo             productNo           }         }       }           }   } }   I tried to use (unoptimized: true) but I still don’t get all _joindown lines. Im creating a dwh containing all orders from 2019 and forward. And I need to be able to update at least 1000 orders each  day.  ... View more