Database view not showing Questions columns from view table

[BijoyDeb]

Hi All,

I had requirement to build a report on specific form which i did like following.

Lets says there is form which creates a record on case table and to access values for record producer variables

In report, i found a Questions column on case to which i dot walked to get exact record producer and then i dot walked  to all variables from that record producer

But now they want approver and state of approval as well in same report----

For this, i did create a database view between case and approval table.

Now i'm able to see approval table columns, but Questions column from case table is not showing anymore.

Not sure what is happening

Anyone faced same issue ever, please let me know how can we fix this or if its not possible

Thanks in advance!!

[AshishKM]

Hi @BijoyDeb , 

You can create report on sysapproval table and get all case columns using the dot walking because sysapproval table has case record as reference and you can pull all columns in report. 

Database View, this is also a good option for reporting. Check if Question belongs to some other table then you have to add that table with applied mapping with case table in the same view configuration

-Thanks,

AshishKM

[NIRANJAN S2]

Hi,

I am also facing a similar kind of issue, has any solution been found for this?
if so kindly let me know