Hello every one ,
I have a table with primary key(JOB ID) and along with I have some other columns like status id, version id, manager id ... I haev another table with columns Drop ID and Drop desc .. we get description for status , version and manager by joining respective columns with Drop ID like
status ID = Drop ID --> status desc , version ID= Drop Desc--> version Desc now my table has columns.....I am creating a model query subject with Prim Key and other columns as descriptions...now my table has columns PK, Status, Version and Mgr .. now when I am trying to create a query studio report JOBID , status, Version and apply filter on status it is showing in the filter (list of values look like prompt in QS) all descriptions instead of giving distinct values for status ...
but in report it is showin the values for status description only...when I use only one column status again it is giving all descriprtions and I can see no join is forming in query when I open with RS like simply select status desc from drop table...
Please help me out