Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Tag ids (Primary Keys) Are all the same #13

Closed
austinmm opened this issue Sep 21, 2019 · 1 comment
Closed

Tag ids (Primary Keys) Are all the same #13

austinmm opened this issue Sep 21, 2019 · 1 comment
Assignees
Labels
bug Something isn't working help wanted Extra attention is needed

Comments

@austinmm
Copy link
Owner

GET localhost:3000/api/tags/
Bearer Auth: cc93d2ef-a0ca-405d-8e8d-633b70ab51d4

{
    "Status": "Successful",
    "Result": [
        {
            "id": 2326,
            "token_id": 2326,
            "name": "groups.custom.0",
            "value": "Example Tag Value",
            "created": "2019-09-21T06:56:41.000Z",
            "token": "cc93d2ef-a0ca-405d-8e8d-633b70ab51d4",
            "organization": "BATS",
            "issued": "2019-09-21T06:56:02.000Z"
        },
        {
            "id": 2326,
            "token_id": 2326,
            "name": "groups.custom.1",
            "value": "Example Tag Value",
            "created": "2019-09-21T06:57:20.000Z",
            "token": "cc93d2ef-a0ca-405d-8e8d-633b70ab51d4",
            "organization": "BATS",
            "issued": "2019-09-21T06:56:02.000Z"
        },
        {
            "id": 2326,
            "token_id": 2326,
            "name": "groups.custom.2",
            "value": "Example Tag Value",
            "created": "2019-09-21T06:57:58.000Z",
            "token": "cc93d2ef-a0ca-405d-8e8d-633b70ab51d4",
            "organization": "BATS",
            "issued": "2019-09-21T06:56:02.000Z"
        },...
@austinmm austinmm added bug Something isn't working help wanted Extra attention is needed labels Sep 21, 2019
@austinmm austinmm self-assigned this Sep 21, 2019
@ColeBennett
Copy link
Collaborator

ColeBennett commented Sep 22, 2019

@austinmm Looks like this is returning the id field from tokens, which should be equal to token_id in tags (this all looks correct). You would have to select tags.id AS tag_id or something explicit. But we aren't returning primary keys anyways so we should SELECT name, value, created

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

3 participants