Dashboard - Strange behavior

Hi

I have a tracker on my dashboard that is being used to filter the datagrid, nothing unusual there. It works as expected. I can populate any or all of them and refresh to get the filtered data. If i populate 1, only that one stays populated until i clear it.

We added a new calculated field to the BAQ that determines the Product Group Location and then updated the dashboard to include this field. Still all good.

Then we wanted to use this field to filter the data rows by Product Group location and this is where the odd behavior comes into play. There are 2 options i have tried:

  1. remaking the tracker to include the ProductGroupLocation field as criteria
  2. adding a combo as setting this to the column.

When i do this, all of the other tracker fields become bound and start to populate with the first row of the result datagrid. If i clear the fileds and refresh, they all re-populate. If i delete the compobox, they all behave as expected.

There is nothing special about the field, is shows 3 values in total which are all added to the combobox. I set the field condition to Equals, also set it to Matches.

Any ideas on how to just make it search as needed without populating the other fields? Because the other fields are populating, the return dataset is incorrect as its using all of the field values to search which is not what we need.

Thanks

1 Like

If customizing the tracker view to add the combo do you have DashboardPrompt set to true?

If rebuilding the tracker do you have input prompts only selected?
image

I know I have run into that issue in the past if I don’t have those set right.

Thanks for replying

ive tried a combination of these also. If this set to false, my controls become readonly and editable. I dont know why there is even a need to automatically make these readonly or disabled, seems kind of counterintuitive to provide a way to add controls only to make them readonly immediately… what purpose is that?

Anyway, driving me crazy today :slight_smile:

Sorry my response wasn’t very clear, it’s been too long of a day… My understanding is these fields need to be set to true.I also wouldn’t try to test this in the dashboard designer, go to tools → deploy and preview/test it there. Have definitely seen custom combo’s and retrievers act odd (or just not work) in the designer.

1 Like

no worries

ive had them set to True and also i have been testing using the Deploy / Test Application button…

For now we can live without filtering the Product Group, its just strange how the addition of this column forces the other controls to show the top row data.

Thanks bud