Skip to Content
avatar image
Former Member

how to filter data depending on the data from the column of a table.

hi Experts,

I am working on a project on VC where i need to display data in a table which has to be filtered depending on the data in a column of another table.

Eg:- I have a table which has a field "Count " which has a number in it. Every row has a field "count", when i click on the count field for a particular row it should filter the data in the table which is to be displayed according to the "company code" which is also one of the fiel from the same row as "count" .

Also every row will have different value for "company code".

Points will be awarded to helpful answers.

Regards,

Sanjy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 05, 2007 at 07:19 PM

    Sanjyoti,

    If i understand you correctly, you hv 2 tables - say table A and table B. Based on the values of the row selected in table A, you want to pass the company code (of the selected row) to another query to populate another table B?

    If so, add a toolbar to the table A -->include "select row" system action, save the company code and any other field you need in a datastore (upon event select row) and also call another (or the same) query for displaying table B filtered by the selected company code (use value saved frm store)

    prachi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 05, 2007 at 10:01 AM

    Hi,

    there is no possibility of "dynamic" filtering in the visual composer; the only possibility is to adapt your data source (BAPI/RFC/BI Query) so that it accepts the filetring value as input parameter and returns filtered data.

    Sorry, that's the only way !

    Rgds,

    Karim

    Add comment
    10|10000 characters needed characters exceeded