i need the ward_bed_number to be unique if only the discharged_date or expiry_date is null, and

[steady compass]

i need the ward_bed_number to be unique if only the discharged_date or expiry_date is null, and ignore this on update

if ($admission = $this->route('admission')) {
            $rules['patient_id'] = ['required', Rule::exists('patients', 'id')
                ->where('status', 'alive'), Rule::unique('admissions', 'patient_id')
                ->ignore($admission->id)
                ->whereNull('discharged_date')
            ];
            
            $rules['admission_number'] = 'required|unique:admissions,admission_number, ' . $admission->id;
            $rules['ip_number'] = 'required|unique:admissions,ip_number, ' . $admission->id;
            $rules['hospital_number'] = 'required|unique:admissions,hospital_number, ' . $admission->id;
            $rules['ward_bed_number'] = ['required', Rule::unique('admissions', 'ward_bed_number')->ignore($admission->id)->whereNull('discharged_date')->WhereNull('expiry_date')];
        } else {
            $rules['patient_id'] = ['required', Rule::exists('patients', 'id')
                ->where('status', 'alive'), Rule::unique('admissions', 'patient_id')
                ->whereNull('discharged_date')
            ];
            
            $rules['admission_number'] = 'required|unique:admissions,admission_number';
            $rules['ip_number'] = 'required|unique:admissions,ip_number';
            $rules['hospital_number'] = 'required|unique:admissions,hospital_number';
            $rules['ward_bed_number'] = ['required', Rule::unique('admissions', 'ward_bed_number')->whereNull('discharged_date')->WhereNull('expiry_date')];
        }

[haughty stratus]

@steady compass no need to post on other channels that you've posted here, if people can and want to help you they'll help you.

[steady compass]

The thing is, i post here as a last resort and i have posted several times here. Few are really helpful. I really normally don't post alot 😬

[haughty stratus]

Yeah, no worries, only giving a heads-up. Just a bit of advice; have a little patience. You posted this and within the same minute you posted in general you were looking for help, it's a bit spammy and usually has the opposite effect of what you're trying to achieve with it 🙂