Filter Tool Gallery losing Records COMPARED to desktop run

Tommy_Alterax

Hi Guys,

I have been running a workflow on my desktop and testing on UAT Gallery - I have a column with a year in there.

When I use a simple filter tool (on the year column) where the year is set to be greater than or equal to 2025  I get about 14,000 records on my desktop - While the gallery it drops to 12,000 - I've no idea why 

Year is parsed out from a date by me - It is a double , I have changed to fixed integer and tried on the gallery also , no success - I ve tried converting year to a date - still same issue - What is going on and why is this happening

	Desktop	Server
True Anchor	14398	12444
False Anchor	159356	161314
	173754	173758

please note the input is an API and 4 records total difference is fine

KGT

My guess would be that it's going to be related to datatype somehow and by your comment it looks like that's your first suspicion as well.

When passing the data via API, is the year column possibly cast to a different data-type? 

My advice is to look at the difference in the records that change. Are they all 2025 for instance..