Determining Subcategories within a Tenants Tag Groups | Payload | Page 1

balmy lanceBOT May 3, 2024, 3:49 PM

#

Guys how can I determine the subcategories of category.

Imagine I select the tenant X

I just want to show the tag groups of this related tenant.

A tenant has multiple tag groups and a user can belong to multiple tenants.

Entities in a nutshell.

Tenant:
- Has many Tag Groups
- Has many Products
Tag Group:
- Belongs to one Tenant
- Has many Tags
Tag:
- Belongs to one Tag Group
- Belongs to one Tenant
- References many Products
Product:
- References many Tags
- Belongs to one Tenant

These relationships outline how the entities are interconnected within the system.

cloud spireBOT May 3, 2024, 3:49 PM

#

Original message from @magic blade - Moved from #general message

#

New Community-Help Thread Created!

Help is on the way! To mark it as solved, use the /solve command. In the meantime, here are some existing threads that may help you:

Documentation:

arctic shale May 3, 2024, 3:49 PM

#

Looking at this now

#

So the tag group select isn't populated?

magic blade May 3, 2024, 3:50 PM

#

The issue arises when I create a new tag.
In creation time, all the tag groups associated with user tenants continue to be displayed, which can clutter the interface and cause inconsistency in db.

arctic shale May 3, 2024, 3:50 PM

#

Hmm, if you detail out the issue a bit more with a screenshot, I can try to make some suggestions

#

Just a heads up, I'm running to lunch shortly, but will continue to check this thread when i return

magic blade May 3, 2024, 3:55 PM

#

The user has access to Tenant A and Tenant B
When I select tenant A, it must show the tag groups associated with the selected tenant (Tenant A) until there the Tag Groups must be disabled.

#

Thanks @arctic shale

magic blade May 3, 2024, 5:06 PM

#

@arctic shale are you there?

arctic shale May 3, 2024, 5:28 PM

#

Hey back

#

So what are you doing with the tag groups now

#

just showing all of them?

#

@magic blade

magic blade May 3, 2024, 5:44 PM

#

yes

arctic shale May 3, 2024, 5:45 PM

#

Can you post your collection here so I can see your logic?

magic blade May 3, 2024, 5:46 PM

#

Flow,

User logs in
Selects a tenant
When creating something (tags / tag groups) show only the entities of that tenant.

arctic shale May 3, 2024, 5:46 PM

#

Gotcha

#

Okay yeah, share your collection code and Ill see what's up

#

(you can just paste it right in here)

magic blade May 3, 2024, 5:47 PM

#


export const Users: CollectionConfig = {
  slug: 'users',
  admin: {
    useAsTitle: 'email',
  },
  auth: {
    depth: 0,
  },
  fields: [
    {
      name: 'tenants',
      type: 'relationship',
      relationTo: 'tenants',
      hasMany: true,
      saveToJWT: true,
    },
  ],
}

export const Tenants: CollectionConfig = {
  slug: 'tenants',
  admin: {
    useAsTitle: 'name',
  },
  fields: [
    {
      name: 'name',
      type: 'text',
      required: true,
    },
    {
      name: 'users',
      type: 'relationship',
      relationTo: 'users',
      hasMany: true,
    },
    {
      name: 'tag_groups',
      type: 'relationship',
      relationTo: 'tag_groups',
      hasMany: true,
    },
  ],
}

export const TagGroups: CollectionConfig = {
  slug: 'tag_groups',
  admin: {
    useAsTitle: 'name',
  },
  fields: [
    {
      name: 'name',
      type: 'text',
      required: true,
    },
    {
      name: 'tenant',
      type: 'relationship',
      relationTo: 'tenants',
      required: true,
    },
  ],
}

export const Tags: CollectionConfig = {
  slug: 'tags',
  admin: {
    useAsTitle: 'name',
  },
  fields: [
    {
      name: 'name',
      type: 'text',
      required: true,
    },
    {
      name: 'tag_group',
      type: 'relationship',
      relationTo: 'tag_groups',
      filterOptions: ({ user }) => {
        return {
          tenant: {
            // I need to find a way to get the tenant from the user (after login showing a dropdown of all available tenants, or select the tenant from a dropdown
            // Hardcoded to the first tenant
            equals: user!.tenants![0],
          },
        }
      },
      required: true,
    },
  ],
}

arctic shale May 3, 2024, 5:49 PM

#

@magic blade So in your filterOptions method, you also have access to siblingData

#

which will give you the value of the other fields in the collection

#

      filterOptions: ({ user, siblingData }) => {
        return {
          tenant: {
            // I need to find a way to get the tenant from the user (after login showing a dropdown of all available tenants, or select the tenant from a dropdown
            // Hardcoded to the first tenant
            equals: user!.tenants![0],
          },
        }
      },

#

Can you log, console.log(siblingData) before the return statement and tell me if you get the sibling field data

#

Then we can continue

magic blade May 3, 2024, 5:50 PM

#

In create

arctic shale May 3, 2024, 5:51 PM

#

What's that?

magic blade May 3, 2024, 5:51 PM

#

arctic shale May 3, 2024, 5:51 PM

#

Ah yes, like that

#

what does it log?

#

it should be the other fields in the collection and their values

magic blade May 3, 2024, 5:51 PM

#

Im using pgsql

arctic shale May 3, 2024, 5:52 PM

#

what does it log?
it should be the other fields in the collection and their values

#

Let me know if you need additional instruction

magic blade May 3, 2024, 5:53 PM

#

Alright

#

im using payload 3.0 beta

arctic shale May 3, 2024, 5:54 PM

#

That shouldn't matter here, we're just trying to see what siblingData is

#

You put the log statement in

#

Now if you view the collection, it should log the value to your console

magic blade May 3, 2024, 5:55 PM

#

sorry

arctic shale May 3, 2024, 5:55 PM

#

It's okay take your time

magic blade May 3, 2024, 5:55 PM

#

this is just showing the id's of tag groups.

arctic shale May 3, 2024, 5:56 PM

#

Check out the example here:

#

https://payloadcms.com/docs/fields/relationship#filtering-relationship-options

#

For the first part of this, you just need to confirm that you can access the sibling data

magic blade May 3, 2024, 5:57 PM

#

I have the following.

tag groups

arctic shale May 3, 2024, 5:57 PM

#

To confirm

#

You should be going to your collection

#

Then checking your log for the siblingData

#

Does that make sense?

#

And I think in particular, youll want to get the value of the "users" field

#

the collection in question only has like two fields

magic blade May 3, 2024, 5:59 PM

#

I have this tags

#

My user is associated with tenant A1

When I create a new tag it shows all the tag groups of all tenats

arctic shale May 3, 2024, 6:02 PM

#

Why didn't equals: user!.tenants work

#

You said that you want to get the tennant from the user

magic blade May 3, 2024, 6:02 PM

#

logs

#

arctic shale May 3, 2024, 6:03 PM

#

what's wrong with tenants[1] ?

magic blade May 3, 2024, 6:04 PM

#

arctic shale You said that you want to get the tennant from the user

nothing, the problem is I dont want to hard the first assigned tenant.
We have two options

The after logins choose the tenant he want operate
Have a dropdown in each entity for user select the tenant

arctic shale May 3, 2024, 6:04 PM

#

ohhh

magic blade May 3, 2024, 6:05 PM

#

Sorry if my english is not very good

arctic shale May 3, 2024, 6:05 PM

#

Nah it's alright, its impressive you know more than 1 lang

magic blade May 3, 2024, 6:05 PM

#

I saw a lot of people with this kind of problems

#

Thanks!

#

Even checked the multi-tenant example from payload,
https://github.com/payloadcms/payload/tree/main/examples/multi-tenant
but it's focused on the domain url
https://github.com/payloadcms/payload/blob/main/examples/multi-tenant/src/collections/Users/hooks/recordLastLoggedInTenant.ts#L10

arctic shale May 3, 2024, 6:08 PM

#

Ah I see

#

I'm happy to help you out with this more, but I do have to run an errand

#

Can you wait a little bit?

#

Shouldn't be more than an hour

magic blade May 3, 2024, 6:09 PM

#

Off course. Thanks, please don't forget this issue. We're really trying to migrate to PayloadCMS, we're in love with this project.

magic blade May 3, 2024, 8:06 PM

#

@arctic shale are you back?

magic blade May 3, 2024, 9:25 PM

#

@short juniper can you help me here?

arctic shale May 6, 2024, 12:33 PM

#

Good morning

magic blade May 6, 2024, 4:30 PM

#

Hello

#

Do you know how can I pass the filterOptions data to the custom component?

arctic shale May 6, 2024, 5:23 PM

#

Hey - did you solve this yet?

#

I am back

magic blade May 6, 2024, 5:37 PM

#

Not yet

#

How can I access the filter Options data to the custom component?

#

I need to do an API call?

arctic shale May 6, 2024, 5:44 PM

#

Generally in a custom functional component, you define what props it can take in

#

Then you pass the props wherever it is constructed

#

MyCustomComponent(filterOptions, other, stuff)

magic blade May 6, 2024, 5:58 PM

#

I need to pass the data in the default relationship (the default select)

#Determining Subcategories within a Tenants Tag Groups

Documentation: