Question
Galax E Solutions
IN
Last activity: 29 Oct 2018 16:46 EDT
Single Text of CSV values to be filtered for Report defintion of Joined Table
Hi I am Try to achieve Following Requirement.
There are Two Tables TAB1 and TAB2 joined with Common Column in report Definition.
TAB2 has a Column Name VALUES with Text Data Type has a Value like (1,2,3) or (2,3,4) or (5,4,6)See Structure below.
TAB1 has a Column ID with Text DATA (1)or (2) or (3) or (4) See Structure below
Now I need Dropdown values if TAB2 VALUES column is (1,2,3), then Dropdown Should have (1,2,3) options from TAB1 or corresponding values of other Column of TAB1 See Explanation below
If TAB2 VALUES column is (2,3,4,5), then Dropdown Should have (2,3,4,5) options or Corresponding values of other column of TAB1 See Explanation below
Dropdown Source is Datapage with Report definiton Reference.
TAB 1 STRUCTURE
ID OPTION ...............
1 ABC
2 XYZ
3 UVW
4 PQR
TAB 2 STRUCTURE
ID VALUE ..................................
1 1,2,3
2 2,3,4
3 3,4,5
Explanation
If VALUE column in TAB2 is (1,2,3)
drop down should reflect (ABC/XYZ/UVW)
f VALUE column in TAB2 is (2,3,4)
drop down should reflect (XYZ/UVW/PQR)
f VALUE column TAB2 is (2,3)
drop down should reflect (XYZ/UVW)
How to Achieve this ?
Thank you
Pegasystems Inc.
US
I'm not sure what the relevance is of the report definition joining the 2 tables.
What it sounds like you are trying to do is the equivalent of the query:
SELECT OPTION FROM TAB1 WHERE TAB1.ID IN TAB2.VALUE
for whichever TAB2.VALUE is selected (you don't state how the TAB2.VALUE is chosen).
You can achieve the SQL "IN" operation by putting the individual values from the TAB2.VALUE property into a text value list property and using that value list property as the filter value for your report definition.
See the help page for "Report Definition Query tab" for details.