Add Inline Character to List & Make Searchable

[avinashtelsa]

LessonCrudController

CRUD::addField([
'name' => 'lessonFilter',
'label' => 'Lesson Filters',
'type' => "relationship",
'max_rows' => 1,
'subfields' => [
[
'name' => 'flashcard_type',
'type' => 'select_from_array',
'label' => 'Flashcard Type',
'options' => [
'pre_made' => 'Pre-made',
'must_know' => 'My Must-Know Flashcards',
'extra_info' => 'My Extra Info Flashcards',
],
'wrapper' => [
'class' => 'form-group col-md-4',
],
],
[
'name' => 'character_id',
'label' => 'Character',
'type' => 'relationship',
'model' => "App\Models\Character",
'minimum_input_length' => 0,
'allows_null' => true,
'inline_create' => [
'entity' => 'character',
],
'data_source' => url('api/characters'),
'wrapper' => [
'class' => 'form-group col-md-4',
],
],
],
]);

Lesson Model

public function lessonFilter(): HasOne
{
return $this->hasOne(LessonFilter::class);
}

LessonFilter Model

protected $fillable = [
'lesson_id',
'character_id'
];

public function lesson(): BelongsTo
{
return $this->belongsTo(Lesson::class);
}

public function character(): BelongsTo
{
return $this->belongsTo(Character::class);
}

Character Model

protected $fillable = ['name'];

public function lessonFilters(): HasMany
{
return $this->hasMany(LessonFilter::class);
}

routes.api
Route::resource('/characters', CharacterController::class);

CharacterController

public function index(Request $request): \Illuminate\Http\JsonResponse
{
    $query = $request->input('q');

    $characters = Character::query();

    if ($query) {
        $characters->where('name', 'like', '%' . $query . '%');
    }

    $characters = $characters->get();

    return response()->json($characters, 200);
}

This is my complete code here. The character is being added through inline creation, but I want it to be in the character list. Also, when the user searches, it should appear. Help me complete this.

[backpack-ai-bot[bot]]

I see you're trying to implement the inline creation functionality for characters in your Backpack application, but you're having issues with the search functionality and displaying newly created characters in the list. Let me help you with this.

The issue you're experiencing is related to how the relationship field with inline creation works in Backpack. When you create a new character using the inline creation feature, it needs to be properly configured to appear in the search results.

Fixing the Inline Create and Search Functionality

Based on the knowledge sources, here are the steps to fix your issue:

1. First, make sure your CharacterCrudController has the InlineCreateOperation trait:

class CharacterCrudController extends CrudController
{
    use \Backpack\CRUD\app\Http\Controllers\Operations\ListOperation;
    use \Backpack\CRUD\app\Http\Controllers\Operations\CreateOperation;
    use \Backpack\CRUD\app\Http\Controllers\Operations\InlineCreateOperation;
    // other operations...
}

2. For the relationship field in your LessonCrudController, you need to ensure you're using the ajax parameter and properly configuring the field:

[
    'name'        => 'character_id',
    'label'       => 'Character',
    'type'        => 'relationship',
    'model'       => "App\Models\Character",
    'ajax'        => true,  // This is important for search to work
    'minimum_input_length' => 0,
    'allows_null' => true,
    'inline_create' => [
        'entity' => 'character',
        'force_select' => true,  // This will select the newly created item
    ],
    'wrapper'     => [
        'class' => 'form-group col-md-4',
    ],
]

3. Make sure you have a FetchOperation in your LessonCrudController to handle the AJAX requests:

use \Backpack\CRUD\app\Http\Controllers\Operations\FetchOperation;

// Then in your controller:
public function fetchCharacter()
{
    return $this->fetch(\App\Models\Character::class);
}

The issue with your search might be related to how the search query is constructed. According to the knowledge sources, you might need to use orWhere instead of where in your search query as mentioned in this GitHub issue.

Also, make sure your API endpoint for characters is correctly set up to handle the search parameters that Backpack sends. The search functionality in Backpack's relationship fields uses AJAX to fetch results.

If you're still having issues with the search functionality, you might need to check your browser's developer console for any JavaScript errors or network requests that are failing.

Remember that for the inline creation to work properly, both the FetchOperation and InlineCreateOperation need to be properly configured.

Let me know if you need further assistance with any specific part of this implementation!

ℹ️ Please note our AI Bot does not reply to follow-ups, this will be the only AI answer in this thread. If the AI helped you find the answer, please mark it as answered or write details below so it can learn. Then close the conversation. If not, please give more information for when a human reads this. ℹ️

Relevant sources:

Github Issue (closed): How to customize search query?
Github Issue (closed): CRUD : Adding Multiple Child Records (1-n relationships) on related CRUD form?
Github Issue (closed): [4.1.0][Bug] Problems with relationship field type
Github Issue (open): [Bug] inlineCreate not working on hasMany relationship
InlineCreate Operation PRO|How to Use Part 3
Github Issue (closed): [Feature Request] Add InlineCreate to relationship field when there are subfields
Github Issue (closed): [Bug] Search is not working correctly
Github Issue (closed): [Bug] Error using a accessor as "attribute" on "relationship" field type with the "inline create" functionality
Github Issue (closed): [Bug] Display many - many inline create data in table structure instead of dropdown
Github Issue (closed): [Bug] Inline create "Add" button doesn't show
FAQs for CRUDs|What field should I use for a relationship? Part 1
Fields|Create related entries in a modal - using the InlineCreate Operation
Github Issue (closed): Problem with relationship field with inline_create attribute

[avinashtelsa]

Thanks! :)

[jcastroa87]

As our bot help you to solve it, I will close this issue, but please feel free to re-open or create a new one if needed.

Cheers.