Forum Discussion

Sweez's avatar
Sweez
New Contributor III
16 days ago
Solved

Parameter Value Not Resolved

I have an issue that I have seen before I never figured out so want to see if others have encountered this and figure out what I am doing wrong.  I have a data adapter that calls a Dashboard Dataset ...
Dashboards
Parameters
  • ChristianW's avatar
    ChristianW
    15 days ago

    It is related to the processing order of the components, data adapters, and parameters. In your case, the parameter „someotherparameter“ is needed to build the data adapter, but it doesn’t exist yet. And the query fails.

    The solution is easy, you just need to test, if the parameter already exists, and exit the business rule if not.

    I‘m not at my desk, so I can‘t post a sample. 

ChristianW's avatar
ChristianW
Valued Contributor
15 days ago

It is related to the processing order of the components, data adapters, and parameters. In your case, the parameter „someotherparameter“ is needed to build the data adapter, but it doesn’t exist yet. And the query fails.

The solution is easy, you just need to test, if the parameter already exists, and exit the business rule if not.

I‘m not at my desk, so I can‘t post a sample. 

ChristianW's avatar
ChristianW
Valued Contributor
10 days ago

I'm using this functions

In C#:

public bool UnresolvedParameters(Dictionary<string, string> nameValuePairs)
{
    foreach (KeyValuePair<string, string> kvp in nameValuePairs)
    {
        if ((StringHelper.DoesStringContainCustomSubstVarsOrSubstVarStringFunctions(kvp.Value)))
            return true;
    }

    return false;
}

or in VB:

Public Function UnresolvedParameters(nameValuePairs As Dictionary(Of String, String)) As Boolean
    For Each kvp In nameValuePairs
        If StringHelper.DoesStringContainCustomSubstVarsOrSubstVarStringFunctions(kvp.Value) Then Return True
    Next

    Return False
End Function