I am having trouble using a reference field in my query.
The Website link is https://www.shopmayven.com/ .
So the problem is I have two tables, one is Tag and other one is brands. Page name is all brands. I have a reference field of tags in the brands collection. Now I have a tag input field in the search results. I want to search brands according to the tags selected. As tags is a reference field I am not able to use in query to perform my search. So I added a new field in the Brand collection to perform my search. I can have my search results through that query but the problem is I want to use a reference field for which I have entered all the records. I can not re-enter all the data into that field.
Here is my code. And it is working but not for the reference field. Please help me that how I can use reference field into my query so I can result like that
function loadDataToRepeater( ) { let dataQuery = wixData.query(collectionName) let dataQuery1 = wixData.query(collectionName) if ($w("#tags").value.length>0 || $w("#checkboxGroup1").value.length>0 || $w("#checkboxGroup2").value.length>0 || $w("#checkboxGroup3").value.length>0) { //dataQuery = dataQuery.hasAll(fieldToFilterByInCollection, $w("#tags").value) dataQuery1 = dataQuery.hasAll(fieldToFilterByInCollection, $w("#tags").value.concat($w("#checkboxGroup1").value,$w("#checkboxGroup2").value, $w("#checkboxGroup3").value ) ) console.log(dataQuery1); } dataQuery1 .find() .then(results => { const itemsReadyForRepeater = results.items $w('#repeater1').data = itemsReadyForRepeater; console.log(itemsReadyForRepeater); const isRepeaterEmpty = itemsReadyForRepeater.length === 0 if (isRepeaterEmpty) { $w('#noResultsFound').show() } else { $w('#noResultsFound').hide() } }) }
![](https://static.wixstatic.com/media/a27d24_a0a0e2ab461041e39e3791574b6471ff~mv2.png/v1/fill/w_980,h_465,al_c,q_90,usm_0.66_1.00_0.01,enc_auto/a27d24_a0a0e2ab461041e39e3791574b6471ff~mv2.png)
![](https://static.wixstatic.com/media/a27d24_fe2a026ac8034f579a20051b374752c3~mv2.png/v1/fill/w_980,h_456,al_c,q_90,usm_0.66_1.00_0.01,enc_auto/a27d24_fe2a026ac8034f579a20051b374752c3~mv2.png)