ODATA request to fetch latest UD105 rows

Epicor ERP 10
21

UD is being used as queue: yes.

Iot module sounds interesting. But we do DOD work. Air-gapped assembly in SCIF. So we use ODATA and PWA type web applications. So no iot module for us with this project.

22

Not sure of your requirements, but Azure IoT does do DOD work. I was impressed that they can secure communications either with TPM in hardware or X.509 certs that are also embedded in hardware. Maybe for a future project.

23

So we are saying omitting that value as a key, storing it in a normal field, then indexing it is an unacceptable answer? Sorry, late to the party.

24

Not exactly, I think that is the best approach. The open question is how to do an odata filtered search on a DB field of type long. Should be possible, right?

25

Query it with a BAQ from REST?

26

Got the solution from EpicCare:

Use an 'L" after the digits for seind a long.

let reply = await Comm.get(MoveURL, 'UD105s', { $filter:LastModified_c gt ${nowish}L }) // uses long value

So the final answer is:

  • Put the timestamp in a custom field (as a long int)
  • Use SQL Server to index that field
  • Make sure comparisons are done in the filter with a L after the digits.

Thank you all who helped.

27

Or UL if you want it unsigned.

1 Like