Run tester on every date field in a table

There is a “Type Is” operator available in the test conditions. So you could use a Tester or TestFilter and  select an attribute to test if the values for that attribute are of a specific type like datetime.

You could try working with the AttributeExploder prior to the Tester/TestFilter with datetime filtering to find attributes that have datetime values.

The list of date fields can be determined fairly easily by a FeatureReader in “Schema Only” mode.   Each Schema Feature output (1 per table) will have a List of all Fields and their Data Type.  These can be filtered by ListExploder then Tester.

To test this list of derived date/time attributes for date values dynamically is quite a bit trickier.  I’ve trialled a few approaches, but one example approach is:

1. Use the results from the FeatureReader → ListExploder → Tester of Feature Type Names vs Date/Time Field Names to use for build Oracle SELECT SQL strings that only select these fields per Table
2. Use an AttributeCreator to add a pair of “” around each field name output by the Tester
3. Then use an Aggregator to to build a comma-delimited list of field names to SELECT (Aggregator Group By Parameter = Feature Type Name)
4. Then use SQLExecutor to “SELECT @Value(<Aggregator Comma-delimited Field List>) FROM @Value(<Feature Type Name>)”
5. Use the SQLExecutor results in AttributeExploder → Tester (or AttributeExploder→ StatisticsCalculator) to flag fields or rows that have values that are “out of bounds”