Database View not working fields not display info

Daniel142
Tera Expert

‎07-21-2023 06:45 PM

Hi guys!

 

I'm trying to build a database view with two tables, cost_plan & cost_plan_breakdown.

The requirement is to make a report like this:

Daniel142_0-1689990126499.png

All cost_plans have a cost_plan_breakdown, but also a project_funding and a fiscal_period. I'm not able to display project_funding info also i'm not able to display fiscal_period.

Any suggestion?

 

Daniel142_1-1689990258175.png

 

This is what the join is displaying, only cost_plan names 🤔

Daniel142_2-1689990302889.png

 

 

0 Helpfuls
  • 293 Views
1 REPLY 1

Bert_c1
Kilo Patron

‎07-22-2023 07:01 AM

Hi Daniel142,

 

Try where clause 'cpb_cost_plan=cp_sys_id'.  As 'name' is a string field, and cost_plan_breakdown.cost_plan is a Reference field to a record in the cost_plan table.

0 Helpfuls