multiselect field problem when using dataview as source

[simplynotes]

I try to use dataview query for the suggestions of a multiselect field. If I hardcode the query with the value for recType ('parking') as below it works

dv.pages('"Informationen"')
.where(p =>
p.recType == 'parking')
.file.name

if I try to use the value from a form field as below it doesn't work

dv.pages('"Informationen"')
.where(p =>
p.recType == form.selType)
.file.name

any ideas or suggestions are much appreciated ;-)

[danielo515]

Let's try to debug this a bit.

Can you try this code and see what you get in the console? You have to open the console, then open the form and put the cursor in the dv field:

dv.pages('"Informationen"').where(
    p => { 
    console.log(p.recType, form)
    return p.recType == form.selType 
}
).file.name

Do you know how to open the debug console?

[simplynotes]

Asyou can see from the screenshot it lists all documents below the "Informationen" folder - some of them are folder notes. It clearly shows the 3 note with the 'parking' recType (Frontmatter) and 2 with the 'hiking' recType
Intersting is that the multiselect field has all the notes with "undefined" as suggestions but not the 'parking' (the one I expected) nor the 'hiking' notes.

Meanwhile I use the builder from Modal Form and with that it works. I only need the multi-select field in this case as I build the query string with all the filter values (recType | country | region). it also allows me to set the form title and the field label according to what I want to select

I am fine with this as workaround | solution

here the code.

let defValues = new Array();
// APIs we need
const modalForm = app.plugins.plugins.modalforms.api;
const dView = app.plugins.plugins.dataview.api;

// get current file
const cFile = this.app.workspace.getActiveFile();
const curFile = dView.page(cFile.path);

// get country and region (if set)
let curCountry = curFile.fld_tripCountry.display;
let curRegion = curFile.fld_tripRegion;

// what do we need
selType = context.args.infoType

switch (selType) {
  case "parking":
	formTitle = "Stellplätze wählen";
	defValues = {
    	mselect: linkstoarray(curFile.parking)
	};
    break;
  case "hiking":
	formTitle = "Wanderungen wählen";
	defValues = {
    	mselect: linkstoarray(curFile.hiking)
	};
    break;
  case "sight":
	formTitle = "Sehenswürdigkeiten wählen";
	defValues = {
    	mselect: linkstoarray(curFile.sight)
	};
    break;
  case "activity":
	formTitle = "Aktivitäten wählen";
	defValues = {
    	mselect: linkstoarray(curFile.activity)
	};
    break;
  case "food":
	formTitle = "Restaurants wählen";
	defValues = {
    	mselect: linkstoarray(curFile.food)
	};
    break;	
  default:
    console.log(`Sorry, we are out of ${selectInfo}.`);
}

const queryString = "(dv.pages('\"Informationen\"')\n.where(p => \np.recType == '" + selType + "' && \np.fld_country.display == '" + curCountry + "' && \n(p.fld_region == '" + curRegion + "' || \np.fld_region == \"\" || \np.fld_region == \"#-\" )\n).file.name)";

// build form
const result = await modalForm.openForm({
    title: formTitle,
    fields: [
        	{
            name: "mselect",
            label: "Auswahl",
            type: "multiselect",
            description: "",
            required: false,
            input: {
                type: "multiselect",
                source: "dataview",
                query: queryString,
                allowUnknownValues: false,
                multi_select_options: []
            	},
	        },
    	],
	},{values: defValues});

// user cancelled
if (result.status === 'cancelled') {
	return
};

[danielo515]

From your screenshot I see the form is empty

Are you selecting the field before you try to click on the dataview input? Or are you clicking direclty in the input?

[simplynotes]

I tried both. I use default values to populate the fields in the form, the plan was to hide them once it is working, ad therefor I clicked directly in the multiselect field. but I also tried to change the type field (e.g. change it to hiking and back to parking) but this did not change the result.

[simplynotes]

Hi Danielo,
after further testing with the builder version of my form I strongly belief, that the multiselect field doesn't respond to change events in the form.
My dataview query string has a logical XOR combination to find the suggestion notes. however the query evaluates when opning the form. Changing the toogle field does nto trigger an re-evaluation of the query string. I tested the query by using different defaults.

best regards
Raimund

[danielo515]

Ok, thank you for pointing it out, I will investigate the multi select, maybe it's the root cause of the problem. Just to prove the point, can you just use a normal text field and see if it works as expected? Don't rely on defaults, as I don't think those get "inserted" into the form, they are added later when you extract the data from the form (if I recall correctly)

[simplynotes]

I tested it with a normal select field.

first screenshot you can see that the select field shows only 1 suggestion beause type / country and region must match.
2nd screenshot the toggle makes the dataview query ignoring the region field and the select field shows 3 suggestions for the selected country.