outbound option query rule .. sorting

Unanswered Question
Dec 19th, 2008

is it possible to sort before loading into a table?

when i use order by .. i dont get a syntax error .. but order by has no effect on the table..

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Edward Umansky Fri, 01/02/2009 - 11:05

Order by is not valid in a query rule definition yet the validation appears to allow it. If you look at baImport logs for an actual import however you will see that this causes an error. You need to sort lists in the desired order before importing them to ICM.

lohjintiam Wed, 12/22/2010 - 02:14

Is it possible to do sorting in the latest version? I want to contact records which is having the highest/lowest value 1st.

Thanks!

-JT-

Actions

This Discussion