Jump to content

how to filter on _updateStamp


 Share

Recommended Posts

Hi all!

_updateStamp is the only field I want to filter on and oddly one of only two that doesn't seem to work

I need to be able to get the records that have changed since a given date and time.

{
  xtremX3Purchasing {
    purchaseOrderQuantityLine {
      query(filter: "{_updateStamp: {_gte: '2022-01-24T08:14:09.000Z' }}", first: 1) {
        edges {
          cursor
          node {
            _id,
            _updateStamp
          }
        }
      }
    }
  }
}

Returns

{
  "errors": [
    {
      "message": "An error has occurred. Please contact your administrator.",
      "locations": [
        {
          "line": 5,
          "column": 9
        }
      ],
      "path": [
        "xtremX3Purchasing",
        "purchaseOrderQuantityLine",
        "query",
        "edges"
      ],
      "extensions": {
        "code": "system-error"
      }
    }
  ],
  "data": {
    "xtremX3Purchasing": {
      "purchaseOrderQuantityLine": {
        "query": {
          "edges": null
        }
      }
    }
  },
  "extensions": {
    "restrictedFilters": [],
    "diagnoses": []
  }

The same query but for OrderDate seems to work fine but its _updateStamp I need to filter on.

I'd be deeply grateful for any help.

Thank you,

Link to comment
Share on other sites

  • 2 weeks later...

Hi Becky,

I'm looking into this for you now.  Looking at the return from a query to the node, it appears that the _updateStamp is just returning the current date and time so it may be an issue in the sandbox.  

I'll post back here as soon as I have an update for you

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share

×
×
  • Create New...