Custom script not restricting records

[Ocean West]

Just upgraded to MS3 but I cannot get it on one table to respect the custom find request to only find a subset of records date +- today - I've got the custom f

 it's trying to sync 15k records...

 

If I do a constrain on this table it shows 209 records. 

[Ocean West]

Nothing I try will limit the records 

[Caleb360Works]

Did you set MS3 for JDBC-only or XML? If you're using JDBC only you'll need to use a custom SQL qualifier instead of the customization script.

[Ocean West]

thanks Caleb I figured that out the hard way on the positive side i also split the table to move the PDF attachment to its own table so that sync are even faster as pdfs are synced from spoke to hub and not pushed back out on initial sync.