Forum Discussion

ShelbyMelban1's avatar
ShelbyMelban1
Qrew Member
9 years ago

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.

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.
APIs and custom code
reports and charts
Tables and fields
    • ShelbyMelban1's avatar
      ShelbyMelban1
      Qrew Member
      7 years ago
      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.
    • AlexCertificati's avatar
      AlexCertificati
      Qrew Cadet
      7 years ago
      low tech solution would be to add your own last_update field to the table and include it in the CSV import.
  • ShelbyMelban1's avatar
    ShelbyMelban1
    Qrew Member
    9 years ago
    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.