Where are my archived projects at? [Epic2]

[jordanh]

Issue - Bug

While poking around on staging, I was doing some testing.

I:

1. Logged in using my Google account
2. Chose me demo team
3. Ran a meeting, creating a new project for myself
4. Archived it
5. Navigated to the archive

And see:

Uh, oh! Where are my archived projects at?

I can also reproduce this locally using npm run dev.

[jordanh]

Ah ha, here's the server exception:

Creating a pool connected to localhost:28015
1488779087725 - Origin: Worker (PID 97328)
   [Error] ReqlOpFailedError: Index `teamIdCreatedAt` was not found on table `actionDevelopment.Project` in:
r.table("Project").between(["team123", r.minval], ["team123", r.maxval], {
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    index: "teamIdCreatedAt"
    ^^^^^^^^^^^^^^^^^^^^^^^^
}).filter({
^^^^^^^^^^^
    isArchived: true
    ^^^^^^^^^^^^^^^^
}).pluck(["content", "id", "isArchived", "status", "teamMemberId", "updatedAt"]).changes({
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    includeInitial: true
    ^^^^^^^^^^^^^^^^^^^^
})

It looks like that index was still in use!

[jordanh]

The exception is fixed (I had to re-add the index by hand because an existing migration was changed), but I still don't see any archived items. There are no client exceptions, no new server exceptions.

When tracing the socket:

Looks like the sub goes out, but the server never responds with any archived items...

[mattkrick]

this did the trick for me. can you try to cut n paste this?

• r.db('actionDevelopment') .table('Project').indexCreate('teamIdCreatedAt', (row) => [row('teamId'), row('createdAt')])

[jordanh]

Oh yes, that did it just fine! I made a mistake when re-adding the index to staging. I didn't make it a multi-index. Danke!