I'm trying to perform a GET where for a datetime field I shall pass only date and it should provide the necessary results. Below is the URL that I'm trying however it does not work
https://hostname/oslc/os/table?oslc.select=assetnum, location&oslc.where=assetstatus.code="ABC" and siteid="XXXX" and assetstatus.location="204345104" and assetstatus.changedate="2022-06-18"
The change date is stored in the database as 2022-06-18 08:00:01.0
however we would pass only date.
You can pass the parameters in Postman like this
&assetstatus.location=2022-06-18T08:00:01.0&assetstatus.changedate=2022-06-18T08:00:01.0