Method:Classic General Q&A

Re: Integration Tools Table Export Filter With Script

Blake C — Thu, 31 May 2012 18:54:40 GMT

No way! How did I miss that? Very nice! I just sent in my beta request.

Also, thanks for the SQL clarification. Will keep it in mind...

Thanks again!

Re: Integration Tools Table Export Filter With Script

Method_Paul — Thu, 31 May 2012 18:26:31 GMT

SQL

So for a customer:

Name like '%Dave%'

Will give you anyone with "Dave" in their name.

FirstName = 'Dave'

Will give you all the Dave's, but not the Davea's.

Or for an Activity:

DueDateStart > '2012-05-31'

Would give you all activities after midnight (UTC time) of May 31st.

It's obviously on our todo list to make a user interface that allows non-SQL'rs to build the scripts visually.

BTW - did you get my tweet about the Gmail Gadget? We're accepting beta requests - you'll love it.

Paul

Integration Tools Table Export Filter With Script

Blake C — Thu, 31 May 2012 17:50:33 GMT

I see I have an option of 'filtering with script' when exporting tables to a file. What sort of script can I use? Is this SQL? Any particular syntax or ANSI version?

Thanks,

Blake C