diff options
| author | Eric Poirier | 2017-10-10 18:11:33 +0000 |
|---|---|---|
| committer | Eric Poirier | 2017-10-10 18:11:54 +0000 |
| commit | 567b4a171441cc9a9d8297167e45e4395350746b (patch) | |
| tree | d8f33f90e053ea08e55809d03793acbce89b1042 | |
| parent | c35db9f7e9dd06b7b0ac5a5d8a1689443723b7f4 (diff) | |
| download | eclipse.org-common-567b4a171441cc9a9d8297167e45e4395350746b.tar.gz eclipse.org-common-567b4a171441cc9a9d8297167e45e4395350746b.tar.xz eclipse.org-common-567b4a171441cc9a9d8297167e45e4395350746b.zip | |
Bug 525821 - Get the member's correct MP listing version
Signed-off-by: Eric Poirier <eric.poirier@eclipse-foundation.org>
| -rw-r--r-- | classes/membership/membership.class.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/classes/membership/membership.class.php b/classes/membership/membership.class.php index 710980ca..d63e6b1c 100644 --- a/classes/membership/membership.class.php +++ b/classes/membership/membership.class.php @@ -229,7 +229,7 @@ class Membership { N.title, CTR.field_companyname_value as name, N.nid, - if(fv.field_version_value IS NULL ,'',MAX(fv.field_version_value)) as version, + CASE MAX(CAST(fv.field_version_value as INTEGER)) WHEN fv.field_version_value IS NULL THEN '' ELSE fv.field_version_value END as version, B.body_value as teaser FROM field_data_field_companyname as CTR INNER JOIN node as N on CTR.entity_id = N.nid |