User Profile

vamshi9666

Guide

Joined 6 years ago

4 Posts1 Solution

View All Badges

User Widgets

Contributions

Re: Post Image as part of message using REST API V2
patils27 did you manage to solve this ?
5 years ago Place Developer Discussion
129Views
Sign in to react to this post
0Comments
Re: time constraint in v2 json query
I solved this by using converting time value into unix timestrap format by Date.now(). updated query looks like : <code> var currentDate = Date.now() var liql = "SELECT body, cover_image, subject,occasion_data.rsvp.user, occasion_data.location FROM messages where occasion_data.end_time >= " + currentDate var jsonQuery = [{ messages: { fields: ["occasion_data", "body", "cover_image", "subject", "occasion_data.rsvp"], constraints: [{ "occasion_data.end_time": { ">=": currentDate } }] } }] </code>
5 years ago Place Developer Discussion
452Views
Sign in to react to this post
0Comments
Re: How Can we get messages using date range using POST method.
First of all, 202007-12T04:06:53-07:00 is not a valid value. As it contains operations (+-) it will be considered as a expression. You need to make into a string for value. and however even if you use quotes to make into a string, khoros can't use it as time constraint. (this is issue with khoros) i created a similar post awaiting solution from community. follow it for update.
5 years ago Place Developer Discussion
126Views
Sign in to react to this post
0Comments
time constraint in v2 json query
i am trying to get occasions with ```end_time``` constraint using "GET" /search/2.0 query as follows: <code> var liql = "SELECT body, cover_image, subject,occasion_data.rsvp.user, occasion_data.location FROM messages where occasion_data.end_time >= " + currentDate $http({ url: '/api/2.0/search?q=' + liql, dataType: 'json', method: 'GET', contentType: "application/json", }).then(function(response) { </code> with this way, i am able to get data but nested queries can't be achieved. To do so , i tried json based query as follows : <code> var jsonQuery = [{ messages: { fields: ["occasion_data", "body", "cover_image", "subject"], constraints: [{ "occasion_data.end_time": { ">=": new Date().toISOString() } }] } }] </code> but this time time constraints wont work and throw error.
Solved
5 years ago Place Developer Discussion
2.3KViews
Sign in to react to this post
1Comment
vamshi9666
Guide
5 years ago
I solved this by using converting time value into unix timestrap format by Date.now().

updated query looks like :
<code>
var currentDate = Date.now()
var liql = "SELECT  body, cover_image, subject,occasion_data.rsvp.user, occasion_data.location FROM messages where occasion_data.end_time >= " + currentDate
            var jsonQuery = [{
                messages: {
                    fields: ["occasion_data", "body", "cover_image", "subject", "occasion_data.rsvp"],
                    constraints: [{
                        "occasion_data.end_time": {
                            ">=": currentDate
                        }
                    }]
                }
            }]
</code>
Sign in to react to this post

You’ve seen all recent content