greg [iero] Posts - Answer Overflow

greg [iero]

Posts Comments

TTwenty

•Created by greg [iero] on 8/27/2024 in #❓︱help

White empty page (Token expired)

16 replies

TTwenty

•Created by greg [iero] on 7/12/2024 in #❓︱help

Create entries in GraphQL

Hello all I try to use graphql to read and add objects to Twenty. I succeeded to get data, ie name, id and methodologies for a given "project" :

query MyQuery {
  project(filter: {verraId: {eq: 4890}}) {
    name
    id
    methodologies {
      edges {
        node {
          id
        }
      }
    }
  }
}

query MyQuery {
  project(filter: {verraId: {eq: 4890}}) {
    name
    id
    methodologies {
      edges {
        node {
          id
        }
      }
    }
  }
}

And I get:

{
  "data": {
    "project": {
      "name": "Anlo wetlands",
      "id": "9ae9ced6-f28c-4654-ae3d-8cdc1e035db9",
      "methodologies": {
        "edges": [
          {
            "node": {
              "id": "cb2791ff-b960-40e6-95fe-2a76708fdd02"
            }
          }
        ]
      }
    }
  }
}

{
  "data": {
    "project": {
      "name": "Anlo wetlands",
      "id": "9ae9ced6-f28c-4654-ae3d-8cdc1e035db9",
      "methodologies": {
        "edges": [
          {
            "node": {
              "id": "cb2791ff-b960-40e6-95fe-2a76708fdd02"
            }
          }
        ]
      }
    }
  }
}

If I try to create a new project :

query = gql(
        """
        mutation createProject($project: ProjectCreateInput!) {
            createProject(data: $project) {
                id
            }
        }
    """
    )

    variables = {
        "project": {
            'name': name, 
            'countryId': id,
            'verraId': vid,
            'methodologies': {
                'edges': [
                    {
                        'node': {
                            'id': mid
                        }
                    }
                ]
            }
        }
    }


    results = client.execute(query, variable_values=variables)

query = gql(
        """
        mutation createProject($project: ProjectCreateInput!) {
            createProject(data: $project) {
                id
            }
        }
    """
    )

    variables = {
        "project": {
            'name': name, 
            'countryId': id,
            'verraId': vid,
            'methodologies': {
                'edges': [
                    {
                        'node': {
                            'id': mid
                        }
                    }
                ]
            }
        }
    }


    results = client.execute(query, variable_values=variables)

It does work for simple fields as name or 1 to 1 relations but not with 1 to many (here the methodologies field could countains several Methodology objects):

gql.transport.exceptions.TransportQueryError: {'message': 'Variable "$project" got invalid value { name: "My New Project", countryId: "60d7ea0a-a5e1-4fc7-8dc8-78c1f39112a2", verraId: 1000, methodologies: { edges: [[Object]] } }; Field "methodologies" is not defined by type "ProjectCreateInput".', 'locations': [{'line': 1, 'column': 24}]}

gql.transport.exceptions.TransportQueryError: {'message': 'Variable "$project" got invalid value { name: "My New Project", countryId: "60d7ea0a-a5e1-4fc7-8dc8-78c1f39112a2", verraId: 1000, methodologies: { edges: [[Object]] } }; Field "methodologies" is not defined by type "ProjectCreateInput".', 'locations': [{'line': 1, 'column': 24}]}

Any idea how I can do that? Thanks !

12 replies

TTwenty

•Created by greg [iero] on 7/9/2024 in #❓︱help

Upgrading 0.2 to 0.21

Hello I upgraded my test server and I get those errors: Anything to do to correct that?

28 replies

TTwenty

•Created by greg [iero] on 6/24/2024 in #❓︱help

Update Belongs to One to Has many

6 replies

TTwenty

•Created by greg [iero] on 6/17/2024 in #❓︱help

Errors upgrading from 0.12 to 0.20

Hello, I updated the docker from 0.12 to 0.20 using docker-compose up --build -d I have some errors in the logs (attached), but it seems to work.

16 replies

TTwenty

•Created by greg [iero] on 5/31/2024 in #❓︱help

Error in Company "People" field

7 replies

TTwenty

•Created by greg [iero] on 5/7/2024 in #❓︱help

Projects criterias

Hello I have objects called "Projects". In this object I have a status (ie new project, screened, validated..). For each status I have some criterias (Does this project do at least X, Does the company works like that). Another status has other criterias. My idea is to use Twenty to assess those criterias and change status when all criterias are met. I don't know how to do that. Was thinking using "Tasks" but it is related to an object and not a status. Any idea?

2 replies

TTwenty

•Created by greg [iero] on 5/3/2024 in #❓︱help

Load more values when scrolling

When you scroll a lot of objects (ie companies), there is an (api?) call every X lines to get the next ones. Scrolling is not very smooth and you have to wait for all updates. Can we increase the number of lines loaded?

3 replies

TTwenty

•Created by greg [iero] on 4/22/2024 in #❓︱help

Update from 0.3.2

Hello, I have a docker install in version 0.3.2. What are the right steps to update the system to the last version?

94 replies

TTwenty

•Created by greg [iero] on 4/6/2024 in #❓︱help

Access API

The demo plateform is broken, so I cannot generate an API key to access the rest api documentation https://docs.twenty.com/rest-api/core#/ Is there a way to access this documentation? Even a static (not up to date) version will be great.

13 replies

TTwenty

•Created by greg [iero] on 3/28/2024 in #❓︱help

Members in Read mode

Is it possible to add a member in read mode only ? I mean not able to write modifications in the database (and not access settings) ?

6 replies

TTwenty

•Created by greg [iero] on 3/28/2024 in #❓︱help

Backup/restore/Migrate database

I have a local server in 0.3.2 and a (future) prod server in 0.3.3. I would like to move my database from the first one to the second one. Ok so I dumped DB:

pg_dump -U twenty -h localhost -p 5432 -Fc default > db_twenty.dump

pg_dump -U twenty -h localhost -p 5432 -Fc default > db_twenty.dump

I scp the dump to the server, copy in docker, and connect to this docker container:

docker cp ../db_twenty.dump twenty-db-1:
docker exec -it twenty-db-1 /bin/bash

docker cp ../db_twenty.dump twenty-db-1:
docker exec -it twenty-db-1 /bin/bash

I removed existing database and create a fresh one:

dropdb -U twenty -h localhost -p 5432 default
createdb  -U twenty -h localhost -p 5432 default

dropdb -U twenty -h localhost -p 5432 default
createdb  -U twenty -h localhost -p 5432 default

Next I restore the database

cd

pg_restore -U twenty -h localhost -p 5432 -C --clean --create --if-exists -d default db_twenty.dump 
Password: 
pg_restore: error: could not execute query: ERROR:  cannot drop the currently open database
Command was: DROP DATABASE IF EXISTS "default";
pg_restore: error: could not execute query: ERROR:  database "default" already exists
Command was: CREATE DATABASE "default" WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'en_US.UTF-8';


pg_restore: warning: errors ignored on restore: 2

cd

pg_restore -U twenty -h localhost -p 5432 -C --clean --create --if-exists -d default db_twenty.dump 
Password: 
pg_restore: error: could not execute query: ERROR:  cannot drop the currently open database
Command was: DROP DATABASE IF EXISTS "default";
pg_restore: error: could not execute query: ERROR:  database "default" already exists
Command was: CREATE DATABASE "default" WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'en_US.UTF-8';


pg_restore: warning: errors ignored on restore: 2

In server side:

docker exec -it twenty-server-1 sh

/app/packages/twenty-server $ yarn database:migrate:prod

docker exec -it twenty-server-1 sh

/app/packages/twenty-server $ yarn database:migrate:prod

And restart:

docker-compose restart

docker-compose restart

It seems to work. Do you think I did it the right way? Any improvement to that process?

13 replies

TTwenty

•Created by greg [iero] on 3/24/2024 in #❓︱help

Cannot access Twenty

I setup a standalone local server using an old Mac mini with ubuntu. So I installed everything using Docker method. Here is my .env:

TAG=latest

PG_DATABASE_URL=postgres://twenty:twenty@twenty-db:5432/default

FRONT_BASE_URL=http://localhost:3001
LOCAL_SERVER_URL=http://localhost:3000

ACCESS_TOKEN_SECRET=PWD1
LOGIN_TOKEN_SECRET=PWD2
REFRESH_TOKEN_SECRET=PWD3
FILE_TOKEN_SECRET=PWD4
SIGN_IN_PREFILLED=false

POSTGRES_ADMIN_PASSWORD=PWD5
POSTGRES_USER=postgres
POSTGRES_PASSWORD=twenty

SERVER_URL=https://sgl.local

TAG=latest

PG_DATABASE_URL=postgres://twenty:twenty@twenty-db:5432/default

FRONT_BASE_URL=http://localhost:3001
LOCAL_SERVER_URL=http://localhost:3000

ACCESS_TOKEN_SECRET=PWD1
LOGIN_TOKEN_SECRET=PWD2
REFRESH_TOKEN_SECRET=PWD3
FILE_TOKEN_SECRET=PWD4
SIGN_IN_PREFILLED=false

POSTGRES_ADMIN_PASSWORD=PWD5
POSTGRES_USER=postgres
POSTGRES_PASSWORD=twenty

SERVER_URL=https://sgl.local

And my compose.yaml;

version: "3.9"
services:

  twenty-front:
    image: twentycrm/twenty-front:${TAG}
    ports:
      - 3001:3001
    environment:
      - SIGN_IN_PREFILLED=${SIGN_IN_PREFILLED}
      - REACT_APP_SERVER_BASE_URL=${LOCAL_SERVER_URL}
      - REACT_APP_SERVER_AUTH_URL=${LOCAL_SERVER_URL}/auth
      - REACT_APP_SERVER_FILES_URL=${LOCAL_SERVER_URL}/files
    depends_on:
      - twenty-back

  twenty-back:
    image: twentycrm/twenty-server:${TAG}
    ports:
      - 3000:3000
    environment:
      - SIGN_IN_PREFILLED=${SIGN_IN_PREFILLED}
      - PG_DATABASE_URL=${PG_DATABASE_URL}
      - FRONT_BASE_URL=${FRONT_BASE_URL}
      - PORT=3000
      - STORAGE_TYPE=local
      - STORAGE_LOCAL_PATH=.local-storage
      - ACCESS_TOKEN_SECRET=${ACCESS_TOKEN_SECRET}
      - LOGIN_TOKEN_SECRET=${LOGIN_TOKEN_SECRET}
      - REFRESH_TOKEN_SECRET=${REFRESH_TOKEN_SECRET}
        #- SERVER_URL=${SERVER_URL}
    depends_on:
      - twenty-db

  twenty-db:
    image: twentycrm/twenty-postgres:${TAG}
    volumes:
      - twenty-db-data:/var/lib/postgresql/data
    ports:
      - 5432:5432
    environment:
      - POSTGRESQL_USER=${POSTGRES_USER}
      - POSTGRESQL_PASSWORD=${POSTGRES_PASSWORD}
      - POSTGRESQL_DB=default

volumes:
  twenty-db-data:

version: "3.9"
services:

  twenty-front:
    image: twentycrm/twenty-front:${TAG}
    ports:
      - 3001:3001
    environment:
      - SIGN_IN_PREFILLED=${SIGN_IN_PREFILLED}
      - REACT_APP_SERVER_BASE_URL=${LOCAL_SERVER_URL}
      - REACT_APP_SERVER_AUTH_URL=${LOCAL_SERVER_URL}/auth
      - REACT_APP_SERVER_FILES_URL=${LOCAL_SERVER_URL}/files
    depends_on:
      - twenty-back

  twenty-back:
    image: twentycrm/twenty-server:${TAG}
    ports:
      - 3000:3000
    environment:
      - SIGN_IN_PREFILLED=${SIGN_IN_PREFILLED}
      - PG_DATABASE_URL=${PG_DATABASE_URL}
      - FRONT_BASE_URL=${FRONT_BASE_URL}
      - PORT=3000
      - STORAGE_TYPE=local
      - STORAGE_LOCAL_PATH=.local-storage
      - ACCESS_TOKEN_SECRET=${ACCESS_TOKEN_SECRET}
      - LOGIN_TOKEN_SECRET=${LOGIN_TOKEN_SECRET}
      - REFRESH_TOKEN_SECRET=${REFRESH_TOKEN_SECRET}
        #- SERVER_URL=${SERVER_URL}
    depends_on:
      - twenty-db

  twenty-db:
    image: twentycrm/twenty-postgres:${TAG}
    volumes:
      - twenty-db-data:/var/lib/postgresql/data
    ports:
      - 5432:5432
    environment:
      - POSTGRESQL_USER=${POSTGRES_USER}
      - POSTGRESQL_PASSWORD=${POSTGRES_PASSWORD}
      - POSTGRESQL_DB=default

volumes:
  twenty-db-data:

Note that I updated twenty-front part with ports: 3001:3001 instead of 3001:3000.

28 replies

TTwenty

•Created by greg [iero] on 3/19/2024 in #❓︱help

Datamodel Store float numbers

Hello Is there a way to store a float? "Numbers" type seems to be Integer only

6 replies

TTwenty

•Created by greg [iero] on 3/11/2024 in #❓︱help

Sort People by name

5 replies

TTwenty

•Created by greg [iero] on 3/8/2024 in #❓︱help

Update and add Steps to Pipeline Steps

6 replies

TTwenty

•Created by greg [iero] on 3/8/2024 in #❓︱help

Error when adding a relation to an object

I try to add a relation (HQ for HeadQuarters) to a Company. A Company HQ has to belong to One Country (Another Object). I got a 500 error. Any idea why?

22 replies

TTwenty

•Created by greg [iero] on 3/6/2024 in #❓︱help

Update Docker install

Hello, I installed version 0.3.0 and I'm looking for updating the installation to last version. How can I do that? Thanks

22 replies

TTwenty

•Created by greg [iero] on 3/6/2024 in #❓︱help

Cannot access to demo version

We cannot use 'noah@demo.dev' anymore. There is a message with "Plan required" only. Is it a bug?

3 replies

TTwenty

•Created by greg [iero] on 2/13/2024 in #❓︱help

Data Model

8 replies

Gaming

Programming