Filtering on Relations

Hi everyone,

so I have an interesting error. Instead of integer ids I use uuids (as primary key).
When searching "DreagonTreasures" with a specific user e.g. /api/users/0189d986-1e5c-7205-8e1c-466b139ceda1
I get a 200 response with

"hydra:totalItems": 0,
"hydra:member": [],

Here is what id looks like in my class:

 #[ORM\Id]
 #[ORM\Column(type: UuidType::NAME, unique: true)]
 #[ORM\GeneratedValue(strategy: 'CUSTOM')]
 #[ORM\CustomIdGenerator(class: 'doctrine.uuid_generator')]
 private ?UUid $id;

I'm using MySQL. The id (with uuid value) apparently is of type binary(16) in MySQL. Does it have something to do with that?
What am I missing / how can I fix this?

(When I use integer ids it works as it should.)

Thanks for your help.

Hey @David-S

I think that's unexpected. Have you watched this chapter? You may find it helpful https://symfonycasts.com/screencast/api-platform-extending/uuid-identifier
By the way, I don't recommend using UUIDs as the primary key because it will slow down your queries. It's better to keep a traditional integer id as the primary key and add a UUID as your "public id"

Cheers!

Hey @MolloKhan,

thanks for your reply. I wasn't sure that "slowing down" is a real world problem (at least for my application).
So, to keep it simple, I wanted to use the uuid instead of integer id. But Ok, I will use int as primary and add uuids as identifiers.

I used Symfony\Component\Uid\Uuid . In that Symfony 5 API Tutorial Ramsey\Uuid\Uuid is used. Which one shpuld be uses now with Symfony 6 and API Platform 3?

Good question. Since Symfony 5.2 there's a UID component that basically replaces Ramsey's library. You can read more about it here https://symfony.com/doc/current/components/uid.html#storing-uuids-in-databases

Cheers!

Hi everyone,

I am working on an application with API Platform 3. I have an Entity called "Users" and another Entity called "Prospects". I have created a route: /api/users/{partner_id}/prospects/{id}, where {partner_id} represents the custom id of users and {id} represents the id of prospects.

This setup is functioning correctly, but I want to apply a filter on the subresource "prospects," and I am having trouble understanding how to do this. I have encountered some issues, but I haven't found a solution yet.

Here is a portion of my code:

#[ApiResource(
    operations: [ 
        new Get(
            shortName: "Users",
            uriTemplate: '/users/{partner_id}/prospects/{id}',
            uriVariables: [
                'partner_id' => new Link(fromClass: Users::class, fromProperty: 'prospects'),
                'id' => new Link(fromClass: Prospects::class)       
            ],             
        ) 
    ],    
)]
#[ApiFilter(SearchFilter::class, properties:[
    'status',
    'lastname' => 'ipartial',
    'upline'
])]

Please let me know if you have any suggestions or solutions. Thank you!

Hey @David-G!

This is not a use-case I had thought of before! You said this isn't working. What does it do? An error? Just not work at all?

Cheers!

Hi,
The bug was between the chair and the screen because I didn't realize that I was trying to apply a filter on a Get operation when filters only work on GetCollection operations.
Thanks !