Forum Discussion

seangly's avatar
seangly
New Contributor III
2 years ago
Solved

How to retrieve data on a selected row from a grid view inside a dashboard by clicking a button

I am looking to extract the data of a selected row in a grid view by click a button inside a dashboard;  
dashboards
  • MarkBird's avatar
    MarkBird
    2 years ago

    Hi seangly 

    Had another thought on this....

    If you don't have a column in stage that that uniquely identify each record in stage then you can just create a column in your data adapter that is a concatenation of the key columns in your table. E.g. (Account|Entity|Flow|UD1...) and set this as the column for the bound parameter.

    (Hide the column using column formats)

    In your business rule, you can extract this information using a string.split e.g.:

    Dim items() As String = rowID.Split("|")

Dim sAccount As String = items(0)
Dim sEntity As String = items(1)
Dim sFlow As String = items(2)
Dim sUD1 As String = items(3)

     

MarkBird's avatar
MarkBird
Contributor III
2 years ago

Ah okay, I understand now.

You can do something similar with the bound parameters, however, with the grid view you can only have one column as the bound parameter so you would need to have a Row ID or unique identifier for each row in your grid view:

You would then pass through the row ID parameter to your business rule the same way as before:

{MyBusinessRule}{DrillToSourceFunction}{rowID=|!Selected_RowID!|}
MarkBird's avatar
MarkBird
Contributor III
2 years ago

Hi seangly 

Had another thought on this....

If you don't have a column in stage that that uniquely identify each record in stage then you can just create a column in your data adapter that is a concatenation of the key columns in your table. E.g. (Account|Entity|Flow|UD1...) and set this as the column for the bound parameter.

(Hide the column using column formats)

In your business rule, you can extract this information using a string.split e.g.:

Dim items() As String = rowID.Split("|")

Dim sAccount As String = items(0)
Dim sEntity As String = items(1)
Dim sFlow As String = items(2)
Dim sUD1 As String = items(3)

 

  • seangly's avatar
    seangly
    New Contributor III
    2 years ago

    Hi Mark,

    The bound parameter work when I tried with amount (I dont rowID as I am querying against a view in the database).  I wasn't really satisfied with using the amount field as we might have same amount but the mechanic of bound parameter work.

    With concatenating several fields, it provides us with unique combination (same as unique key) that will work fine.

    Thank for your advice on this one.