2022.01.10 05:32 AM
Hello,
Below are the steps to create a highlight rule from a multiselect dropdown list.
1. Have the viewstate for the dropdown list be of type list
2. Create a virtual datasource with the following code to change the selected viewstate to a different format
function (list, callback) {
var toReturn = {
columns: ["Syntax", "Search"],
meta: { Syntax: 11, Search: 11 },
rows: [ { Syntax: "Syntax", Search: list.join(" OR ") }]
}
callback(toReturn);
}
3. In this virtual datasource, set the list as the "selected" viewstate, and the value of the output to a new viewstate of type symbol
4. Now create your highlight rule on the data grid with condition operator "search" and using the "correctSelected" as condition value
Now you should be able to highlight multi rows in a data grid from a drop down list
Feel free to suggest improvements below.
Many Thanks
Luke
2022.01.10 09:49 AM
Super @leades 🙌
Confirming that this is the accepted solution when creating a highlight rule from a multiselect dropdown list.
Happy Coding 💻,
Leah
2022.01.10 09:49 AM
Super @leades 🙌
Confirming that this is the accepted solution when creating a highlight rule from a multiselect dropdown list.
Happy Coding 💻,
Leah
EMEA
Tel: +44 (0)28 3025 2242
AMERICAS
Tel: +1 (212) 447 6700
APAC
Tel: +61 (0)2 9236 5700
KX. All Rights Reserved.
KX and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.