# Nothing happens when creating full text index

**URL:** <https://community.neo4j.com/t/nothing-happens-when-creating-full-text-index/11510>\
**Category:** Procedures & APOC\
**Tags:** index\
**Created:** [November 1, 2019, 10:49am UTC](https://community.neo4j.com/t/nothing-happens-when-creating-full-text-index/11510 "2019-11-01T10:49:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bjoernoesth](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/bjoernoesth/32/3911_2.png) [@bjoernoesth](https://community.neo4j.com/u/bjoernoesth)\
**Post date:** [November 1, 2019, 10:49am UTC](https://community.neo4j.com/t/nothing-happens-when-creating-full-text-index/11510/1 "2019-11-01T10:49:55Z")

</div>

I am having a bit of trouble with the full text index  
I got nodes with the label SRA, and they contain properties including eg. library\_name and dev\_stage  
I tried to call below

> CALL db.index.fulltext.createNodeIndex("SRA\_fulltext",["SRA"],["library\_name","dev\_stage"])

the result is

> (no changes, no records)

And no results when I query it.

Any suggestions of what I can try?  
Im Running Enterprise 3.5.7  
Best  
Bjoern

---

<div class="post-metadata">

**Author:** ![mark.needham](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/mark.needham/32/104_2.png) [@mark.needham](https://community.neo4j.com/u/mark.needham)\
**Post date:** [November 1, 2019, 1:21pm UTC](https://community.neo4j.com/t/nothing-happens-when-creating-full-text-index/11510/2 "2019-11-01T13:21:33Z")

</div>

Hi,

So I think the first `(no changes, no records)` is expected, if confusing. If you run this query you'll be able to see all the indexes on your database:

```auto
CALL db.indexes()

```

So e.g. having applied the index you shared, my db shows this:

```auto
╒════════════════════════════════════════════╤═════════════════╤══════════════╤════════════════════════════╤════════╤══════════════════════╤══════════╤══════════════════════════════════════╤════╤════════════════╕
│"description" │"indexName" │"tokenNames" │"properties" │"state" │"type" │"progress"│"provider" │"id"│"failureMessage"│
╞════════════════════════════════════════════╪═════════════════╪══════════════╪════════════════════════════╪════════╪══════════════════════╪══════════╪══════════════════════════════════════╪════╪════════════════╡
│"INDEX ON NODE:SRA(library_name, dev_stage)"│"SRA_fulltext" │["SRA"] │["library_name","dev_stage"]│"ONLINE"│"node_fulltext" │100.0 │{"version":"1.0","key":"fulltext"} │40 │"" │
└────────────────────────────────────────────┴─────────────────┴──────────────┴────────────────────────────┴────────┴──────────────────────┴──────────┴──────────────────────────────────────┴────┴────────────────┘

```

And then to query it you could do this:

```auto
CALL db.index.fulltext.queryNodes("SRA_fulltext", "Foo*")

```

Replace 'Foo' with a value that you know exists for at least one node on one of those properties.

Hope that helps.

Cheers, Mark

---

<div class="post-metadata">

**Author:** ![bjoernoesth](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/bjoernoesth/32/3911_2.png) [@bjoernoesth](https://community.neo4j.com/u/bjoernoesth)\
**Post date:** [November 3, 2019, 9:46am UTC](https://community.neo4j.com/t/nothing-happens-when-creating-full-text-index/11510/3 "2019-11-03T09:46:50Z")

</div>

> [@mark.needham](#):
>
> CALL db.index.fulltext.queryNodes("SRA\_fulltext", "Foo\*")

Thank you. I thought I would get a message that it was created like with a normal index, and I had not thought about how long time it would take to create it compared to a normal index so when I queried it nothing came out. Patience worked its magic, thanks.