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 wi...
APIs and custom code
reports and charts
Tables and fields
DavidHawe's avatar
DavidHawe
Qrew Trainee
9 years ago
Have you considered using the Date Modified field?
  • 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.