admin管理员组

文章数量:1123182

I'm doing data export with a Sage X3 SOAP Webservice. I can add "I_TCRITERE" into my request and I'd like to export only recently updated rows, but I'm not able to find the right X3 syntax in order to export only something where updated time is greater than MM-DD-YYYY.

{ "GRP1": { "I_MODEXP": "YMYEXPORT", "I_CHRONO": "NO" }, "GRP2": [ { "I_TCRITERE": "[F:BPC]UPDDATTIM gt '2025-01-01T00:00:00'" } ], "GRP3": { "I_EXEC": "REALTIME", "I_RECORDSEP": "|" } }

I tried different syntax without success: I tried gt, >, =>, >= without sucess. I got error or all row. I tried too, date with YYYYMMDDHHMMSS format, without success too.

How can I get only updated row ?

Thanks.

本文标签: web servicesHow can I filter with a datetime a Sage X3 Soap Webservice exportStack Overflow