Invoice changedDateTime not showing seconds

[danielboylan]

Hi,

I need to get invoices for customers that are sent since my last run. But since changedDateTime doesnt use seconds, i will have some issues with either duplicates(using _gte comparison)  or not finding files(using _gt comparison) that are sent the same minute.

Since changedDateTime is using ISO-8601 standard, are you able to add the use of seconds?

Or is it a better way to do this?

Now i first get the associates with the EDI flag enabled for invoices, i then get a list of the invoices created after(_gt) changedDateTime and has the DoneInvoicesAndCreditNotes flag.

Invoice list query: 

query GetInvoiceList($cId: Int, $date: DateTime, $customerId: Int) {

  useCompany(no : $cId)

  {    

     orderDocument(filter: { _and: [

{changedDateTime: {_gt: $date}},

      {orderStatus1Flags: {_is_on: DoneInvoicesAndCreditNotes}},

    {customerNo: {_eq: $customerId}}

    ]})

    {

      totalCount

      items

      {

        invoiceNo

      }

    }

  }

}

[Marius Bancila · Accepted solution]

This has been released today. See https://docs.business.visma.net/docs/schema/datetime.

[danielboylan]

That's great, thanks!

[omelhus]

Awesome!

[Marius Bancila]

Thanks for reporting this. I have added it to our backlog.

[omelhus]

I second this. All tables where Chtmms (ChangeTimeInMs) is present should use that for millisecond precision on time, whilst the others can fall back to chtm (ChangedTime).