CRM-12464 - Add campaign pseudoconstants

[civicrm-core.git] / xml / schema / Member / Membership.xml

diff --git a/xml/schema/Member/Membership.xml b/xml/schema/Member/Membership.xml
index d94e6adf957f8670fe2c9b43e7a53cd6dea337ee..37cc73000bd05b56a03099c20b990650d0761117 100644 (file)
--- a/xml/schema/Member/Membership.xml
+++ b/xml/schema/Member/Membership.xml
@@ -204,6 +204,12 @@
     <title>Campaign ID</title>
     <import>true</import>
     <comment>The campaign for which this membership is attached.</comment>
+    <pseudoconstant>
+      <table>civicrm_campaign</table>
+      <keyColumn>id</keyColumn>
+      <labelColumn>title</labelColumn>
+      <condition>(end_date IS NULL OR end_date > NOW())</condition>
+    </pseudoconstant>
     <add>3.4</add>
   </field>
   <foreignKey>