How can i fetch all the address lookup table accounts created by an account(payer)?

Question

For my particular use case i need to create an address lookup table for every user , I could not find any function that returns the address table created by an account(payer)

Answer 1

You need to store the slot number when you create an Address Lookup Table, later you can resolve the same address for the table to be able to fetch the Data

let [ix_table, table_address] = anchor.web3.AddressLookupTableProgram.createLookupTable({
            authority:  payer.publicKey,
            payer: payer.publicKey,
            recentSlot: slot
        });

if your table inited to fetch data use this :

let lookupTableAccount = (await anchor.getProvider().connection.getAddressLookupTable(table_address)).value!;

Answer 2

You can try with getProgramAccounts:

curl RPC_ENDPOINT -X POST -H "Content-Type: application/json" -d '
  {
    "jsonrpc": "2.0",
    "id": 1,
    "method": "getProgramAccounts",
    "params": [
      "AddressLookupTab1e1111111111111111111111111",
      {
        "encoding": "base64",
        "filters": [
          {
            "memcmp": {
              "offset": 22,
              "bytes": "AUTHORITY ADDRESS"
            }
          }
        ]
      }
    ]
  }
'

Or in web3.js:

connection.getProgramAccounts(AddressLookupTableProgram.programId, {
  filters: [
    {
      memcmp: {
        offset: 22,
        bytes: payer.publicKey,
      },
    },
  ],
});