{"id":607,"date":"2012-06-08T09:48:06","date_gmt":"2012-06-08T08:48:06","guid":{"rendered":"http:\/\/blog.repsaj.nl\/?p=607"},"modified":"2012-06-14T09:49:27","modified_gmt":"2012-06-14T08:49:27","slug":"sp2010-problems-with-filtering-and-grouping-for-external-data-bcs-fields","status":"publish","type":"post","link":"http:\/\/blog.repsaj.nl\/index.php\/2012\/06\/sp2010-problems-with-filtering-and-grouping-for-external-data-bcs-fields\/","title":{"rendered":"SP2010: Problems with filtering and grouping for external data \/ BCS fields"},"content":{"rendered":"<p>Having one of the following two problems? <\/p>\n<p>1) Grouped views not working properly when you&#8217;ve selected a BCS \/ External data field as the group field<br \/>\n2) Column filtering not working properly for BCS \/ external data fields<\/p>\n<p>But these problems seem to be inconsistent, some records work and others don&#8217;t? Chances might be that you&#8217;ve selected a field for which the values contain newline characters. This consistenly brings problems with grouping and filtering. The best option you&#8217;ve got is just to eliminate newlines in your datasource. Using SQL? Then this will do: REPLACE([column], CHAR(10), &#8216; &#8216;).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Having one of the following two problems? 1) Grouped views not working properly when you&#8217;ve selected a BCS \/ External data field as the group field 2) Column filtering not working properly for BCS \/ external data fields But these problems seem to be inconsistent, some records work and others don&#8217;t? Chances might be that<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[34],"tags":[11,7,47],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p3KFR1-9N","_links":{"self":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts\/607"}],"collection":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/comments?post=607"}],"version-history":[{"count":0,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts\/607\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/media?parent=607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/categories?post=607"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/tags?post=607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}