Skip to main content
Question

Hello, i'm trying to read a geopackage via the featurereader and performing a where clause to read only the necessary data - it's not working! is there a known problem with fme 2020 and the featurereader with geopackage?


roland
Forum|alt.badge.img+2
Hello, i'm trying to read a geopackage via the featurereader and performing a where clause to read only the necessary data - it's not working! is there a known problem with fme 2020 and the featurereader with geopackage?

3 replies

caracadrian
Contributor
Forum|alt.badge.img+23
  • Contributor
  • October 13, 2021

Can you give us more details?

Does the workspace give any information in the log about FeatureReader? What is the WHERE cluse, maybe you have written it wrong?


roland
Forum|alt.badge.img+2
  • Author
  • October 22, 2021

hi, it looks like if i enable "chaching" in the FeatureReader with a geopackage the where clause doesn't work, without chaching it works fine, maybe a bug?


danminneyatsaf
Safer
Forum|alt.badge.img+12

Hi @roland​,

 

I just tested this myself in FME 2020.0 and was able to read a Geopackage via the FeatureReader & performing a simple WHERE clause (id = "1"). I noticed in FME 2020.0, the column I'm performing the WHERE clause on disappears from the output, but the query was still performed successfully otherwise. I can confirm that this same issue does not exist in FME 2021.1, and the output is as expected.

 

As @caracadrian​ mentioned above, it would be useful to know what your WHERE clause is.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings