agaitan026 Comments - Answer Overflow

Topics

agaitan026

Explore posts from servers

CC#TTCTheo's Typesafe Cult XXata

•Created by agaitan026 on 7/30/2024 in #help

how to show all results in react app?

this is my code

7 replies

•Created by agaitan026 on 7/30/2024 in #help

how to show all results in react app?

https://pastebin.com/s9d7Vbe4

7 replies

•Created by agaitan026 on 7/30/2024 in #help

how to show all results in react app?

but how i do with my react app to paginate correctly using xata?

7 replies

•Created by agaitan026 on 7/30/2024 in #help

how to show all results in react app?

const response = await axios.post( 'https://alexis-gaitan-s-workspace-r0aiag.us-east-1.xata.sh/db/dbsnetworkdb:main/tables/usuarios/query', {"columns":["xata_id","nombre"],"page":{"size":1000}}, for example

7 replies

•Created by agaitan026 on 7/30/2024 in #help

how to show all results in react app?

i know it have a limit of 1000

7 replies

•Created by agaitan026 on 6/15/2024 in #help

summarize columns linked table

current request

{
  "page": {
    "size": 1000,
    "offset": 0
  },
  "columns": [
     "name",
    "xata_id",
    {
      "name": "<-variation_location_details.product",
      "columns": [
        "xata_id",
        "qty_available"
      ],
      "as": "product_references_in_variation_location_details",
      "limit": 200,
      "offset": 0
    }
  ]
}

{
  "page": {
    "size": 1000,
    "offset": 0
  },
  "columns": [
     "name",
    "xata_id",
    {
      "name": "<-variation_location_details.product",
      "columns": [
        "xata_id",
        "qty_available"
      ],
      "as": "product_references_in_variation_location_details",
      "limit": 200,
      "offset": 0
    }
  ]
}

5 replies

•Created by agaitan026 on 6/15/2024 in #help

summarize columns linked table

and MS105G Switch de escritorio de 5 puertos 10/100 / 1,000 Mbps qty_available = 11 + 0 = 11

5 replies

•Created by agaitan026 on 6/15/2024 in #help

summarize columns linked table

for example product MW305R Router Inalámbrico N de 300Mbps" should have qty_available 11 + 5 = 16

5 replies

•Created by agaitan026 on 6/8/2024 in #help

how i can link two table like this

got it then i just need to count the array for each id, works good, thank you very much

13 replies

•Created by agaitan026 on 6/8/2024 in #help

how i can link two table like this

No description

13 replies

•Created by agaitan026 on 6/8/2024 in #help

how i can link two table like this

i got this

13 replies

•Created by agaitan026 on 6/8/2024 in #help

how i can link two table like this

 {
  "meta": {
    "page": {
      "cursor": "dM1BisMwDIXh_RzjrT2Dk9n5Km0wwrGDimMXSymF0LuXJF2UQnf6hfh06VaINi4T3Al3UvI8wqwoNEc4nBdr_8PvjRqTci0-13AMY1TiLH_XVsclKAxCzctc5B0aDEjg8DryLabYYglRPBf_XYVB5pkVrrfWoKYkUeHsYzCQ2vTjR-Im-67bKtMR_R4H09nNSZkm2ZifZwAAAP__",
      "more": false,
      "size": 1000
    }
  },
  "records": [
    {
      "id": "1",
      "product_references_in_variation_location_details": {
        "records": [
          {
            "id": "1",
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:38:55.614973+00:00",
              "version": 1
            }
          },
          {
            "id": "6",
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:09.60911+00:00",
              "version": 1
            }
          }
        ]
      },
      "xata": {
        "createdAt": "2024-05-24T16:26:48.597836Z",
        "updatedAt": "2024-06-03T16:28:37.242412Z",
        "version": 13
      }
    },
    {
      "id": "2",
      "product_references_in_variation_location_details": {
        "records": [
          {
            "id": "2",
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:04.164232+00:00",
              "version": 1
            }
          },
          {
            "id": "7",
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:16.405594+00:00",
              "version": 1
            }
          }
        ]
      },
      "xata": {
        "createdAt": "2024-05-24T16:26:48.597836Z",
        "updatedAt": "2024-06-03T16:29:08.960135Z",
        "version": 11
      }
    }
  ]
}

 {
  "meta": {
    "page": {
      "cursor": "dM1BisMwDIXh_RzjrT2Dk9n5Km0wwrGDimMXSymF0LuXJF2UQnf6hfh06VaINi4T3Al3UvI8wqwoNEc4nBdr_8PvjRqTci0-13AMY1TiLH_XVsclKAxCzctc5B0aDEjg8DryLabYYglRPBf_XYVB5pkVrrfWoKYkUeHsYzCQ2vTjR-Im-67bKtMR_R4H09nNSZkm2ZifZwAAAP__",
      "more": false,
      "size": 1000
    }
  },
  "records": [
    {
      "id": "1",
      "product_references_in_variation_location_details": {
        "records": [
          {
            "id": "1",
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:38:55.614973+00:00",
              "version": 1
            }
          },
          {
            "id": "6",
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:09.60911+00:00",
              "version": 1
            }
          }
        ]
      },
      "xata": {
        "createdAt": "2024-05-24T16:26:48.597836Z",
        "updatedAt": "2024-06-03T16:28:37.242412Z",
        "version": 13
      }
    },
    {
      "id": "2",
      "product_references_in_variation_location_details": {
        "records": [
          {
            "id": "2",
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:04.164232+00:00",
              "version": 1
            }
          },
          {
            "id": "7",
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:16.405594+00:00",
              "version": 1
            }
          }
        ]
      },
      "xata": {
        "createdAt": "2024-05-24T16:26:48.597836Z",
        "updatedAt": "2024-06-03T16:29:08.960135Z",
        "version": 11
      }
    }
  ]
}

13 replies

•Created by agaitan026 on 6/8/2024 in #help

how i can link two table like this

How i can do that but using api rest? With json

13 replies

•Created by agaitan026 on 6/8/2024 in #help

how i can link two table like this

whats the best approach for this? using rest for sure

13 replies

•Created by agaitan026 on 6/8/2024 in #help

how i can link two table like this

with the others i dont have issue, but with this yes because for each product could be 1 or more records (this is how my current inventory system works, it add each transaction as a new records and i need to sum up all qty so i can show like productA actualstock = 10 units for example or productB actual stock = 20

13 replies

•Created by agaitan026 on 6/8/2024 in #help

how i can link two table like this

No description

13 replies

•Created by agaitan026 on 5/29/2024 in #general

hi one question, the xata_id its always

i see, i better leave xata_id thank you

6 replies

•Created by agaitan026 on 5/29/2024 in #general

hi one question, the xata_id its always

like a identity like in sql etc

6 replies

•Created by agaitan026 on 5/29/2024 in #general

hi one question, the xata_id its always

or its best to leave it default

6 replies