tag:blogger.com,1999:blog-4804315647803552547.post5451625049839601293..comments2023-04-06T02:26:25.642-07:00Comments on iFreeTools Blogs: Custom Views now support Template Criteria for User References and Date/DateTime fieldsUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4804315647803552547.post-44002879330574595032014-04-17T03:47:39.885-07:002014-04-17T03:47:39.885-07:00Hi,
There are some limitations in enabling such a...Hi,<br /><br />There are some limitations in enabling such a filtering in the default Google App Engine's datastore and hence we do not yet support this filtering. But, you can still enable the required filtering by using a Boolean (yes/no) formula field, may be called "Upcoming", with the formula as <br /><br /><i>val("Your Date Field") >= today()</i><br /><br />Once this formula field is configured, you create views based on this field with criteria as <i>Upcoming : No</i> and another one for <i>Upcoming : Yes</i>.<br /><br />Thus we have now converted a greater-than / less-than query ("in-equality" query) to a == query ("equality" query), with which Google App Engine's default datastore has no issues/limitations.<br /><br />You will have to re-index the records from ${yesterday}, so that this formula field maintains the correct value. This can be done either :<br /><br />(i) manually, by re-indexing records within a custom view listing records from ${yesterday} (only option in the free version), or<br /><br />(ii) automated using scheduled workflows (possible in paid versions).<br /><br />We are also planning to support Google Cloud SQL (does not have free quotas, like Google App Engine), which will not have such limitations in queries.<br /><br />Feel free to get in touch in case you have any further queries or if you need assistance.<br /><br />Thanks & Regards,<br />RajRajkumarhttps://www.blogger.com/profile/00461535061120744975noreply@blogger.comtag:blogger.com,1999:blog-4804315647803552547.post-86866678888690463672014-04-15T07:18:38.620-07:002014-04-15T07:18:38.620-07:00How to obtain this?
date < ${today}
date >= ...How to obtain this?<br />date < ${today}<br />date >= ${today}Aldo Benettihttps://www.blogger.com/profile/14629019217964764107noreply@blogger.com