Help trying to filter a dynamic database

daviddaniels · February 14, 2021, 3:00pm

I’m trying to only display pricing plans that contain a certain value (there could be more than one). For now, I want to hard code the value in the filter. The collection is the Plan collection from the Pricing & Plans app. The field is ‘Name’.

The reason I need this is that the Pricing and Plans app does not allow multiple instances of the plans repeater on different pages, with different values (like the Bookings app does). So I’m trying to develop a workaround.

Page in question was created by going to Databases in Velo, choosing the Plans collection under PiadPlans, then “Add a Dynamic Page”. It’s been a very long time since I coded, so please forgive the sloppiness.

I get the error "Invalid filter operation $contains for field ‘Name’. And the error appears twice in the Dev Console. The full console list is below the code.

My Code

// import the wix datastructure
import wixData from “wix-data” ;

// Filter database to only retrieve records that contain the value “career”
// Field name is “Name” with the Plans collection
$w.onReady( function () {
var newFilter = wixData.filter();
var filtercareer = newFilter.contains( ‘Name’ , “career” );

$w( '#dynamicDataset' ).setFilter(filtercareer);

});

Dev Console log

[Dataset - Connected] ‘PaidPlans/Plans’ collection to element ‘#listRepeater.#name’:

{…}

[Dataset - Connected] ‘PaidPlans/Plans’ collection to element ‘#listRepeater.#tagline’:

{…}

[Dataset - Connected] ‘PaidPlans/Plans’ collection to element ‘#listRepeater.#PlanName’:

{…}

[Dataset - Connected] ‘PaidPlans/Plans’ collection to element ‘#listRepeater.#MoreButton’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#name’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#tagline’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#PlanName’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#MoreButton’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#name’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#tagline’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#PlanName’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#MoreButton’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#name’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#tagline’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#PlanName’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#MoreButton’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#name’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#tagline’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#PlanName’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater.#MoreButton’:

{…}

[datasetReady event] triggered on wix-dataset

[onReady callback registered] on wix-dataset

[datasetReady event] triggered on wix-dataset

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#title’:

{…}

[currentIndexChanged event] triggered on wix-dataset with (

[…]
)

[datasetError event] triggered on wix-dataset with (

[…]
)

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#title’:

{…}

[Dataset - Populated] ‘PaidPlans/Plans’ collection into element ‘#listRepeater’:

{…}

Invalid filter operation $contains for field ‘Name’.