We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 3866 ☆ A M B ☆
    • 350 Posts
    I have set the default for published in my schema as "0" for published field but when creating a new entry on my migxdb it automatically shows as Published.

    Below is the schema

    <?xml version="1.0" encoding="UTF-8"?>
    <model package="lettings" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1">
        <object class="Lettings" table="property" extends="xPDOSimpleObject">
            <field key="property_name" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
            <field key="street" dbtype="text" phptype="string" null="false" default=""/>
            <field key="town" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
            <field key="county" dbtype="varchar" precision="255" phptype="string" null="false" default=""		
    
    <field key="slide" dbtype="varchar" precision="10" phptype="string" null="false" default=""/>  	
    <field key="feature" dbtype="varchar" precision="10" phptype="string" null="false" default=""/>  	
            <field key="createdon" dbtype="datetime" phptype="datetime" null="true"/>
            <field key="createdby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" />
            <field key="editedon" dbtype="datetime" phptype="datetime" null="true"/>
            <field key="editedby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" />
    		<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
            <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />  
     
            <aggregate alias="CreatedBy" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign"/>
            <aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign"/>
        </object>
     
    </model>


    This has been parsed and shows that published is '0' but in the grid the new entry is shown as published on clicking Done.

    How do I change this? Thank you

    This question has been answered by Bruno17. See the first response.

      Helen Warner
      Number one pixel!
      Proud to be linked with MODX at Crimson Pixel
    • discuss.answer
      • 4172
      • 5,888 Posts
      you can add a hidden field 'published' to your form with default-value of 0

      or

      you can create a custom update.php - processor in your package-folder under yourpackage/processors/mgr/default/update.php, which doesn't set published to 1 by default.

      https://github.com/Bruno17/MIGX/blob/master/core/components/migx/processors/mgr/default/update.php#L171
        -------------------------------

        you can buy me a beer, if you like MIGX

        http://webcmsolutions.de/migx.html

        Thanks!
        • 3866 ☆ A M B ☆
        • 350 Posts
        Thanks Bruno, created the hidden field and that works fine.

        See answer from Bruno.
          Helen Warner
          Number one pixel!
          Proud to be linked with MODX at Crimson Pixel