Discussions

Expand all | Collapse all

I would like to know how I can query on update_id. I'm using the API and want to be able to asked for rows with a greater update_id than the highest I have on record.

  • 1.  I would like to know how I can query on update_id. I'm using the API and want to be able to asked for rows with a greater update_id than the highest I have on record.

    Posted 12-29-2016 21:23
    I want to know how to get updates to records. If I pull a query and I want to run the same query but only get the records that have been updated.  I thought I could use the update_id field returned with each recordID however I'm unsure how to query that field since my schema document does not include information on update_id.


  • 2.  RE: I would like to know how I can query on update_id. I'm using the API and want to be able to asked for rows with a greater update_id than the highest I have on record.

    Posted 12-29-2016 21:28
    Have you considered using the Date Modified field?


  • 3.  RE: I would like to know how I can query on update_id. I'm using the API and want to be able to asked for rows with a greater update_id than the highest I have on record.

    Posted 07-17-2018 05:51
    I'm using date modified now, however, it's not always updated. If I modify something in a grid report, it doesn't get the update.  If there is a simple solution for updating that last modified date for all updates it would help.

    I have an issue where data is going to be loaded/edited via CSV upload.  If update_id is the only solution I need to query on it also.


  • 4.  RE: I would like to know how I can query on update_id. I'm using the API and want to be able to asked for rows with a greater update_id than the highest I have on record.

    Posted 09-25-2018 23:19
    low tech solution would be to add your own last_update field to the table and include it in the CSV import.


  • 5.  RE: I would like to know how I can query on update_id. I'm using the API and want to be able to asked for rows with a greater update_id than the highest I have on record.

    Posted 12-30-2016 13:56
    There is not data coming back in my query for Date Modified. I'll recheck my query to make sure that field was included in the request.    I'm now researching how to onlynew flag works.