Skip to main content
Solved

Extract more recent rows in Postgis

  • October 14, 2018
  • 1 reply
  • 11 views
mr_fme
Enthusiast
Forum|alt.badge.img+9

Hi,

I´m record data from DWG files, but there is some versions of the same file...for example: V1, V2, V3...

What the best way for extract the more recent version by file? I need to create one field called last_date? How I can to extract the last date for example?

Thank´s

Best answer by takashi

Hi @mr_fme, if you can consider the records having the latest "last_date" as the recent version ones, you can extract them by setting "WHERE Clause" parameter in the PostGIS reader feature type. For example:

last_date = (select max(last_date) from my_table)

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

takashi
Celebrity
  • takashiCelebrity
  • Best Answer
  • October 14, 2018

Hi @mr_fme, if you can consider the records having the latest "last_date" as the recent version ones, you can extract them by setting "WHERE Clause" parameter in the PostGIS reader feature type. For example:

last_date = (select max(last_date) from my_table)

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.