Search where value null

[warmwhisky]

Description

I've been trying to make a search where the field committed_at = null.
I could not find in the docs how to do it so have tried the following to no avail

{"field": "committed_at", "operator": "=", "value": "null"}

{"field": "committed_at", "operator": "=", "value": "NULL"}

{"field": "committed_at", "operator": "=", "value": false}

{"field": "committed_at", "operator": "=", "value": ""}

I'm sure its possible, but cannot figure it out.

[GautierDele]

Actually it's a problem with the laravel rule "required_without" that doesn't allow null values, i'll put this as a bug and will fix it soon because it might not be hard to

For now you can use "instructions" to unblock yourself: https://laravel-rest-api.lomkit.com/digging-deeper/instructions

[warmwhisky]

Thank you for the direction. I got this going doing the following

In the new instruction 'NullCommittedAtInstruction'

public function handle(array $fields, \Illuminate\Database\Eloquent\Builder $query) {
    if($fields['committed_at'] === 'null') {
        return $query->whereNull('committed_at');
    };
}

In my JavaScript search endpoint

let data = {
    "filters": [
        {"field": "debtor_id", "operator": "=", "value": debtorObject.id, "type": "and"},
        {"field": "document_type", "operator": "in", "value": document_type_query, "type": "and"},
    ],
    "instructions": [
        {
            "name": "null-committed-at",
            "fields": [
                { "name": "committed_at", "value": "null" }
            ]
        }
    ],
}

[GautierDele]

Glad it worked, i'm looking for a solution 😄

[GautierDele]

I'll need a bit more time, i'm working on improving the performances. Will come just after 😄

[warmwhisky]

Thanks, I appreciaite it 🙏
I'm in no rush as I have it working perfectly at ther moment with the work around.

[warmwhisky]

I have upgraded today and converted all search endpoints to version 2. All working great. Thanks so much!

[GautierDele]

Nice ! I'm glad it worked well for you, it's only the beginning, many features will come 😄

[warmwhisky]

I would like to document this for future reference, both for myself and others who may encounter challenges related to utilizing null values.

I found that "null" did not work but null does the trick

data = {
    "search": {
        "filters": [
            {"field": "prepared_at", "operator": "!=", "value": null, "type": "and"},
        ],
    }
}

[GautierDele]

Thanks for the clarification, effectively "null" will look for a string containing null 😊