Yes Luanne, I got it, that is my mistake in understanding. Thanks a lot it is working fine for me.
-Sukaant Chaudhary On Tue, Dec 31, 2013 at 4:13 PM, Luanne Coutinho <luanne.couti...@gmail.com>wrote: > Sukaant, that is not correct. Again, > > *please see Skip: http://docs.neo4j.org/chunked/milestone/query-skip.html > <http://docs.neo4j.org/chunked/milestone/query-skip.html> and Limit: > http://docs.neo4j.org/chunked/milestone/query-limit.html > <http://docs.neo4j.org/chunked/milestone/query-limit.html> * > If you want 13 rows starting from 12 then SKIP 11 LIMIT 13 should do it. > > > On Tue, Dec 31, 2013 at 4:10 PM, Sukaant Chaudhary < > sukaant.chaudh...@gmail.com> wrote: > >> Hi Luanne, >> If I'm using *SKIP* *12 LIMIT 25 *then I think it should return results >> starting from 13th to 25. >> If I'm right, then in this case why it is returning 25 rows? >> If I'm wrong, then how to get the results starting from 12 and ending >> with 25 (ie 13 rows)? >> >> -Sukaant Chaudhary >> >> >> On Tue, Dec 31, 2013 at 3:56 PM, Luanne Coutinho < >> luanne.couti...@gmail.com> wrote: >> >>> Yes, irrespective of your skip, Limit 25 will return 25 rows if there >>> are 25 rows to return. The only difference skip makes is whether to return >>> 25 rows starting from the first record (skip 0) or 25 rows starting from >>> the 13th record (skip 12). >>> >>> >>> On Tue, Dec 31, 2013 at 3:53 PM, Sukaant Chaudhary < >>> sukaant.chaudh...@gmail.com> wrote: >>> >>>> Hi Luanne, >>>> If I'm trying this query then it is returning 25 rows - *It is >>>> accepted*. >>>> >>>> START n=node(2) MATCH (n)-[:FOLLOWED_BY*..5]->(m) WITH distinct m MATCH >>>> (m)-[:PUBLISHED_UNDER*..5]->(l) WHERE l.eventStartDate + l.eventStartTime >>>> >= "2013-12-3115:47:57" OR l.eventEndDate + >>>> l.eventEndTime>="2013-12-3115:47:57" RETURN l ORDER BY l.eventStartDate + >>>> l.eventStartTime ASC *SKIP 0 LIMIT 25*; >>>> >>>> >>>> But when I'm trying this query then also it is returning 25 rows - *Is >>>> it accepted* *?* >>>> >>>> START n=node(2) MATCH (n)-[:FOLLOWED_BY*..5]->(m) WITH distinct m MATCH >>>> (m)-[:PUBLISHED_UNDER*..5]->(l) WHERE l.eventStartDate + l.eventStartTime >>>> >= "2013-12-3115:47:57" OR l.eventEndDate + >>>> l.eventEndTime>="2013-12-3115:47:57" RETURN l ORDER BY l.eventStartDate + >>>> l.eventStartTime ASC *SKIP* *12 LIMIT 25*; >>>> >>>> -Sukaant Chaudhary >>>> >>>> >>>> On Tue, Dec 31, 2013 at 3:42 PM, Luanne Coutinho < >>>> luanne.couti...@gmail.com> wrote: >>>> >>>>> Yes 25 rows will be returned because that's the limit you set >>>>> (assuming of course that you have more than 25 rows). >>>>> >>>>> If you want the "total no of rows which are in the limit" then limit >>>>> 25 will give you 25 rows. >>>>> Please see Skip: >>>>> http://docs.neo4j.org/chunked/milestone/query-skip.html and Limit: >>>>> http://docs.neo4j.org/chunked/milestone/query-limit.html >>>>> >>>>> -Luanne >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Tue, Dec 31, 2013 at 3:31 PM, Sukaant Chaudhary < >>>>> sukaant.chaudh...@gmail.com> wrote: >>>>> >>>>>> Hi Luanne, >>>>>> This query is working fine for sorting the dates but now there is 1 >>>>>> issue with *SKIP* if I pass *SKIP 0 LIMIT 25* then it works fine and >>>>>> returns 25 rows, but when I pass *SKIP 10 LIMIT 25* then also it >>>>>> returns 25 rows. >>>>>> >>>>>> Here I noticed that it is adding and returning from all the nodes but >>>>>> I want total no of rows which are in the limit. >>>>>> >>>>>> -Sukaant Chaudhary >>>>>> >>>>>> >>>>>> On Mon, Dec 30, 2013 at 6:55 PM, Luanne Coutinho < >>>>>> luanne.couti...@gmail.com> wrote: >>>>>> >>>>>>> Sukaant, you have the > again after the "with distinct m". >>>>>>> To find out the cause of errors, please try debugging by breaking up >>>>>>> the query to isolate the faulty part. >>>>>>> >>>>>>> e.g. >>>>>>> Try >>>>>>> START n=node(2) MATCH (n)-[:FOLLOWED_BY*..5]->(m) >>>>>>> Return m >>>>>>> (no error) >>>>>>> >>>>>>> Then try >>>>>>> >>>>>>> START n=node(2) MATCH (n)-[:FOLLOWED_BY*..5]->(m) >>>>>>> WITH distinct m > >>>>>>> return m >>>>>>> >>>>>>> -->Error, so check the clause you added last i.e. the With clause. >>>>>>> >>>>>>> This query >>>>>>> START n=node(2) MATCH (n)-[:FOLLOWED_BY*..5]->(m) WITH distinct m >>>>>>> MATCH (m)-[:PUBLISHED_UNDER*..5]->(l) WHERE l.eventStartDate + >>>>>>> l.eventStartTime >= "2013-12-3017:37:00" OR l.eventEndDate + >>>>>>> l.eventEndTime>="2013-12-3017:37:00" RETURN l ORDER BY l.eventStartDate >>>>>>> + l.eventStartTime ASC SKIP 0 LIMIT 25; >>>>>>> >>>>>>> worked fine for me on your database. >>>>>>> >>>>>>> -Luanne >>>>>>> >>>>>>> >>>>>>> On Mon, Dec 30, 2013 at 6:17 PM, Sukaant Chaudhary < >>>>>>> sukaant.chaudh...@gmail.com> wrote: >>>>>>> >>>>>>>> Hi Luanne, >>>>>>>> I tried the following query: >>>>>>>> >>>>>>>> - >>>>>>>> neo4j-sh (?)$ START n=node(2) MATCH (n)-[:FOLLOWED_BY*..5]->(m) >>>>>>>> WITH distinct m > MATCH (m)-[:PUBLISHED_UNDER*..5]->(l) WHERE >>>>>>>> l.eventStartDate + l.eventStartTime >= "2013-12-3017:37:00" OR >>>>>>>> l.eventEndDate + l.eventEndTime>="2013-12-3017:37:00" RETURN l ORDER >>>>>>>> BY l.eventStartDate + l.eventStartTime ASC SKIP 0 LIMIT 25; >>>>>>>> - >>>>>>>> ==> SyntaxException: Invalid input ':': expected whitespace, an >>>>>>>> identifier, an expression or ']' (line 1, column 80) >>>>>>>> - >>>>>>>> ==> "START n=node(2) MATCH (n)-[:FOLLOWED_BY*..5]->(m) WITH >>>>>>>> distinct m > MATCH (m)-[:PUBLISHED_UNDER*..5]->(l) WHERE >>>>>>>> l.eventStartDate + l.eventStartTime >= "2013-12-3017:37:00" OR >>>>>>>> l.eventEndDate + l.eventEndTime>="2013-12-3017:37:00" RETURN l ORDER >>>>>>>> BY l.eventStartDate + l.eventStartTime ASC SKIP 0 LIMIT 25" >>>>>>>> - ==> >>>>>>>> >>>>>>>> Please check this >>>>>>>> >>>>>>>> -Sukaant Chaudhary >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Dec 30, 2013 at 6:07 PM, Luanne Coutinho < >>>>>>>> luanne.couti...@gmail.com> wrote: >>>>>>>> >>>>>>>>> You are missing the quotes around the >>>>>>>>> l.eventEndTime>=2013-12-3017:37:00 string. >>>>>>>>> >>>>>>>>> Please keep the mailing list copied, other folks can also >>>>>>>>> contribute. >>>>>>>>> >>>>>>>>> Regards >>>>>>>>> Luanne >>>>>>>>> >>>>>>>>> >>>>>>>>> On Mon, Dec 30, 2013 at 5:53 PM, Sukaant Chaudhary < >>>>>>>>> sukaant.chaudh...@gmail.com> wrote: >>>>>>>>> >>>>>>>>>> Hi Luanne, >>>>>>>>>> I tried the following query: >>>>>>>>>> >>>>>>>>>> START n=node(2) MATCH (n)-[:FOLLOWED_BY*..5]->(m) WITH distinct m >>>>>>>>>> > MATCH (m)-[:PUBLISHED_UNDER*..5]->(l) WHERE l.eventStartDate + >>>>>>>>>> l.eventStartTime >= '2013-12-3017:37:00' OR l.eventEndDate + >>>>>>>>>> l.eventEndTime>=2013-12-3017:37:00 RETURN l ORDER BY >>>>>>>>>> l.eventStartDate + >>>>>>>>>> l.eventStartTime ASC SKIP 0 LIMIT 25; >>>>>>>>>> >>>>>>>>>> Now I'm getting the following exception: >>>>>>>>>> >>>>>>>>>> SyntaxException: Invalid input ':': expected whitespace, an >>>>>>>>>> identifier, an expression or ']' (line 1, column 80) >>>>>>>>>> >>>>>>>>>> - >>>>>>>>>> ==> "START n=node(2) MATCH (n)-[:FOLLOWED_BY*..5]->(m) WITH >>>>>>>>>> distinct m > MATCH (m)-[:PUBLISHED_UNDER*..5]->(l) WHERE >>>>>>>>>> l.eventStartDate + l.eventStartTime >= '2013-12-3017:37:00' OR >>>>>>>>>> l.eventEndDate + l.eventEndTime>=2013-12-3017:37:00 RETURN l ORDER >>>>>>>>>> BY l.eventStartDate + l.eventStartTime ASC SKIP 0 LIMIT 25" >>>>>>>>>> - == >>>>>>>>>> ^ >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -Sukaant Chaudhary >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Mon, Dec 30, 2013 at 5:38 PM, Luanne Coutinho < >>>>>>>>>> luanne.couti...@gmail.com> wrote: >>>>>>>>>> >>>>>>>>>>> Sukaant, just make a string with your format: >>>>>>>>>>> "2013-12-3017:37:00" >>>>>>>>>>> >>>>>>>>>>> And use that in place of timestamp(). >>>>>>>>>>> That will work on the console. >>>>>>>>>>> If passing a in a value through a programming language/api, >>>>>>>>>>> then please parameterize your query by following >>>>>>>>>>> http://docs.neo4j.org/chunked/milestone/cypher-parameters.html >>>>>>>>>>> >>>>>>>>>>> -Luanne >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Mon, Dec 30, 2013 at 5:34 PM, Sukaant Chaudhary < >>>>>>>>>>> sukaant.chaudh...@gmail.com> wrote: >>>>>>>>>>> >>>>>>>>>>>> Hi Luanne, >>>>>>>>>>>> Please try the following query in the given URL >>>>>>>>>>>> and help me how to pass in a string value of the current >>>>>>>>>>>> datetime to compare: >>>>>>>>>>>> >>>>>>>>>>>> START n=node(2) MATCH (n)-[s:FOLLOWED_BY*..5]->(m) WITH >>>>>>>>>>>> distinct m > MATCH (m)-[r:PUBLISHED_UNDER*..5]->(l) WHERE >>>>>>>>>>>> l.eventStartDate >>>>>>>>>>>> + l.eventStartTime >= timestamp() OR l.eventEndDate + >>>>>>>>>>>> l.eventEndTime>=timestamp() RETURN l ORDER BY l.eventStartDate + >>>>>>>>>>>> l.eventStartTime ASC SKIP 0 LIMIT 25; >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> http://ec2-54-213-105-153.us-west-2.compute.amazonaws.com:7474/webadmin/#/console/ >>>>>>>>>>>> >>>>>>>>>>>> -Sukaant Chaudhary >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Neo4j" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to neo4j+unsubscr...@googlegroups.com. >>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Neo4j" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to neo4j+unsubscr...@googlegroups.com. >>>> For more options, visit https://groups.google.com/groups/opt_out. >>>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Neo4j" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to neo4j+unsubscr...@googlegroups.com. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Neo4j" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to neo4j+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to neo4j+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.