course_content | Public daily content for Empower course | Web Site library

Try via strip() and replace():

As documented in the manual assignment is done using := operator - there is no SET in PL/pgSQL.

You are also missing the END IF

The problem is that you are not referring to the using parameter anywhere in your query. Instead, you are concatenating $1 directly into your query, and this $1 refers to the first argument of the pl/pgsql function you are in (and apparently is NULL).

To use parameters in dynamically executed sql and pass them through using, you need to hardcode the text $1 into the query string:

Try this way:

Since the object you are attempting to change a value on is an array, you need to specify an index. In your sample document, there are 2 objects in the array, so your index is either 0 or 1.

If you wanted to update the first item in the array, your query would look like this: $set: { "courseDetail.contentDetail.0.isDelete" : false }

(notice specifying an index to select an item from the array)

Here is some supporting documentation for the array operator in mongodb.

The many-to-many relationship is defined by returning a belongsToMany relationship in the relationship method contents in the Course model. As stated in the Laravel many-to-many documentation.

To retrieve only the Content items in the many to many relationship and not the pivot columns, you should change the relationship instance from App\CourseContent to App\Content.

Instead of querying all objects of student_course model, query the list of all students in your view like this:

I would do it like this: