The start value specified for this query is invalid : dynamic Initial selection filter error Fixing in CRM Analytics

Ramdosk
2 min readJul 20, 2022

--

Use case’s : Dynamically selecting the start value for our filters/List Selector/Toggle based on logged in user Country.

Country toggle

when you set the initial selection through UI (Pick initial values) for getting to know the position and syntax of “start” parameter. after selection when you go to the dashboard JSON you could see the start parameter positioned automatically at the bottom of “step section”. pls see below image.

Initial section through UI syntax

Replacing the UI selection hardcoded value into Dynamic value by “binding”.

binding applying on the start parameter

when you done . you will get below error. why….? its weird…shhhhhhhhhhhhhhhhhhhh

Error screen

Solution:

Note: Start value bindings can only reference the query results, not selections.so result binding only be applicable.

a. ) we would need to remove the square brackets from start parameter . correct syntax would like below

"start”: {

“column name”: “binding”

},

b.) place holder of start parameter in step section:

start parameter should be placed below the “selectmode” parameter. pls see below image

Correct placeholder and syntax of start parameter

result:-

User country

initial toggle selection was “CA” but after applying binding in start parameter. its picks “USA” Because logged in user country is “USA”….

trailhead error question related to start parameter….

--

--

No responses yet