Skip to main content
Question

Filter Date columns in file geodatabase

  • July 17, 2022
  • 3 replies
  • 40 views
fme_can_do_it
Enthusiast
Forum|alt.badge.img+12

I am reading data from a file geodatabase in my workspace. The data is huge and takes time to process data. I have set up a query to only filter data that ends with .2022 but the workspaces are still slow.image 

Therefore, I intend to set up a query on a Date Modified column and a Create date column in the file geodatabase. This will filter only data modified and created within the last seven days. I can't figure out how to set up a query and filter data from the last seven days in FME.

 

Any help and advice would be greatly appreciated.

 

Thank you,

 

    3 replies

    ebygomm
    Influencer
    Forum|alt.badge.img+46
    • ebygommInfluencer
    • Influencer
    • July 19, 2022

    Are you asking how to use a date query in a gdb reader?

    fme_can_do_it
    Enthusiast
    Forum|alt.badge.img+12
    • fme_can_do_itEnthusiast
    • Author
    • Enthusiast
    • July 19, 2022

    Are you asking how to use a date query in a gdb reader?

    yes

    ebygomm
    Influencer
    Forum|alt.badge.img+46
    • ebygommInfluencer
    • Influencer
    • July 19, 2022

    So I'd probably do something like get FME to calculate the date 7 days ago, then use a featurereader to read the gdb and use something like this in the where clause

    FORMAT(DATEMODIFIED, 'yyyyMMdd') >= @Value(last_7_days)

     

     

    Community Stats

    32,154
    Posts
    122,043
    Replies
    39,812
    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.