Method Community

Method:CRM

 

Method Community » Method:Classic » Method:Classic General Q&A » Integration Tools Table Export Filter With Script

Integration Tools Table Export Filter With Script

Last post 05-31-2012 1:54 PM by Blake C. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 05-31-2012 12:50 PM

    Integration Tools Table Export Filter With Script

    Reply Contact

    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

    Blake C

  • 05-31-2012 1:26 PM In reply to

    Re: Integration Tools Table Export Filter With Script

    Answer
    Reply Contact

    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

  • 05-31-2012 1:54 PM In reply to

    Re: Integration Tools Table Export Filter With Script

    Reply Contact

    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!

    Blake C
Page 1 of 1 (3 items)