Use "sync:%", not "%sync%". You only want to block IDs that start with "sync:".
—Jens On Feb 10, 2016, at 8:07 AM, Victor Fernandez <[email protected]<mailto:[email protected]>> wrote: Ok we add an aditional restriction to the query like the example: SELECT * FROM holamundo WHERE META(holamundo).id NOT LIKE "%sync%" AND tableId="L1"; And it looks like works! Thanks for your advice Regards! El lunes, 8 de febrero de 2016, 23:02:26 (UTC-6), Jens Alfke escribió: On Feb 8, 2016, at 6:27 PM, Sandra Bazan <[email protected]<javascript:>> wrote: How do we tell N1QL to ignore keys that start with "sync" so that we actually retrieve the last revision of each document? I don’t actually know N1QL. You may have better luck asking in the Couchbase Server web forums. Does it matter if at document creation, we are assigning specific key to each document instead of allowing CB to assign a default key (name)? We don't wee any document starting with "sync". No, it doesn’t matter. —Jens -- You received this message because you are subscribed to the Google Groups "Couchbase Mobile" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/mobile-couchbase/9abff64c-7660-4f60-9142-88da7474ad19%40googlegroups.com<https://groups.google.com/d/msgid/mobile-couchbase/9abff64c-7660-4f60-9142-88da7474ad19%40googlegroups.com?utm_medium=email&utm_source=footer>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Couchbase Mobile" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/mobile-couchbase/45BB8797-5105-42A2-9030-B9EA2C42E609%40couchbase.com. For more options, visit https://groups.google.com/d/optout.
