Forum Discussion

PARIS2020's avatar
PARIS2020
Frequent Visitor
5 years ago

slicer Selected value as sql query parameter

I want to get the selectedvalue (table.id) and use it in my request as a parameter. for at each click on a row of the table, the query is executed with the selected value table[id].   I tried th...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI PARIS2020 

Can you please provide more info with screenshots, input and required output in table format for the community so that you ask can be better understood and resolved quickly.

PARIS2020's avatar
PARIS2020
Frequent Visitor
5 years ago

I have 2 tables :

     - a header table Ticket(IdTicket, summarize, Creation-Date, IdStatus)
     - detailed table Status (IdStatus, oldStatus, New status, IdTicket)


I need to find records on the Stauts table based on the IdTicket selected.

The IdTicket, appears in a report filter, and when I click on the IdTicket that interests me to select it. Once selected, this filter acts on the Status table to display only the records corresponding to the IdTicket selected.

 

My problem is that this operation requires retrieving more than 2 million lines, and it does not work well. I would like to be able to click on my IdTicket filter, and the selected value will be passed as parameter of a query that only fetch the values ​​that interest me.

  • daniel__'s avatar
    daniel__
    New Member
    3 years ago

    did you manage to find a solution to this ?