Possible bug with Date/Time condition using NOW

  • 1
  • Problem
  • Updated 2 years ago
  • Solved
I'm on 9.5.3 and am getting the following error:



Here is the code to reproduce:
<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" useviewportmeta="true" showheader="true">
    <models>
        <model id="Contact" limit="20" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Contact">
            <fields>
                <field id="CreatedDate"/>
            </fields>
            <conditions>
                <condition type="fieldvalue" value="NOW" enclosevalueinquotes="false" field="CreatedDate" operator="lt"/>
            </conditions>
            <actions/>
        </model>
    </models>
    <components/>
    <resources>
        <labels/>
        <javascript/>
        <css/>
    </resources>
    <styles>
        <styleitem type="background" bgtype="none"/>
    </styles>
</skuidpage>
Photo of Andrew N

Andrew N

  • 1,178 Points 1k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Mark DeSimone

Mark DeSimone, Official Rep

  • 11,732 Points 10k badge 2x thumb
Hi Andrew,

I've looked into this, and although NOW is something you can use in formulas, it isn't something Salesforce recognizes in SOQL. Because your conditions are used when your Skuid page builds its SOQL queries, NOW actually should not be an option when setting up a condition on a datetime field. We will remove it in a future release, since it results in invalid queries to Salesforce. Instead, you can use TODAY to search for contact records whose created-date is older than today, and receive the same set of results. 
Photo of Mark DeSimone

Mark DeSimone, Official Rep

  • 11,732 Points 10k badge 2x thumb
Official Response
The issue with NOW being sent in the SOQL queries has been resolved in Brooklyn Update 1, Iteration 5 which is now available from the Skuid Releases page at http://www.skuid.com/skuidreleases. As a reminder, Salesforce does not allow reverting back to prior versions of managed packages. Skuid always recommends installing new versions in a non-business critical sandbox environment to test all mission critical functionality before installing into a production environment. We also recommend that you update out of date themes when you upgrade.