Skip to main content
Question

Tester filter not working

  • Jul 20, 2023 12:52 PM UTC
  • 38 replies
  • 279 views

Show first post

38 replies

geomancer
Evangelist
Forum|alt.badge.img+71
  • Evangelist
  • Jul 27, 2023 6:43 AM UTC

Would it help to pass the results of the ChangeDetector to a StatisticsCalculator? Group by fme_db_operation, calculate the Total Count. Then you can see the number of INSERT and UNCHANGED (and DELETED) features, and proceed from there.


asadamjad
Participant
Forum|alt.badge.img+12
  • Author
  • Participant
  • Jul 27, 2023 6:52 AM UTC

I did but no success


geomancer
Evangelist
Forum|alt.badge.img+71
  • Evangelist
  • Jul 27, 2023 8:50 AM UTC

Unchanged features have value '<Missing>' in fme_db_operation.

image


asadamjad
Participant
Forum|alt.badge.img+12
  • Author
  • Participant
  • Jul 27, 2023 8:53 AM UTC

okay, what about when there is no insert and only unchanged? so when only unchanged then the script will not run only when insert or Insert and Unchanged


geomancer
Evangelist
Forum|alt.badge.img+71
  • Evangelist
  • Jul 27, 2023 11:38 AM UTC

Maybe you can do something with the NoFeaturesTester (from FME Hub).

image


asadamjad
Participant
Forum|alt.badge.img+12
  • Author
  • Participant
  • Jul 27, 2023 11:40 AM UTC

again this unchanged will trigger every time and truncate the table and add values each time when workspace run


asadamjad
Participant
Forum|alt.badge.img+12
  • Author
  • Participant
  • Jul 27, 2023 11:42 AM UTC

as you can see there is no insert value and now whenever this run its insert the values in database


redgeographics
VIP
Forum|alt.badge.img+63

Maybe I'm missing the point, but check your writer and make sure you're not dropping or truncating the table...


geomancer
Evangelist
Forum|alt.badge.img+71
  • Evangelist
  • Jul 27, 2023 2:15 PM UTC

Nowhere in this workspace do I truncate a database table or add values.

You wanted to know when there are only inserted featurers, or when there are only unchanged features, or when there is a combination of inserted features and unchanged features.

The four Junctions give you exactly that. Now you can add whatever logic you want after each of the four Junctions, or combinations of Junctions.


asadamjad
Participant
Forum|alt.badge.img+12
  • Author
  • Participant
  • Jul 27, 2023 2:16 PM UTC

which workspce


geomancer
Evangelist
Forum|alt.badge.img+71
  • Evangelist
  • Jul 27, 2023 2:17 PM UTC

The image of a workspace in my above post.


asadamjad
Participant
Forum|alt.badge.img+12
  • Author
  • Participant
  • Jul 27, 2023 2:18 PM UTC

can you share the workspce


geomancer
Evangelist
Forum|alt.badge.img+71
  • Evangelist
  • Jul 27, 2023 2:36 PM UTC

See the attached workspace.

I emulated the table data and the update in two Creators. You can change the values in the creator by right-clicking Data, choosing Edit Attribute, and editing Value.