Please let me warn you that this is my first attempt to create a database view. It is showing fields but they are all blank when I click "try it" and I tried to add a where clause but not sure how that works. Any guidance would be appreciated.....
Do NOT be ashamed. We all start somewhere, and Lord knows I've built my share of "What the hec is database view" threads.
you need to update your where clause. use other database views in the system as an example. This one does something SIMILAR, but instead of connecting Project Tasks to status reports it joins to time worked.
See how the where clause works? You're going to do teh same. But you're also going to need to ONLY select Project Task Milestones, right? So like...
| (pmt_milestone=true) && (whatever connects Project Task to Status Report) |
I wish they'd give database view builder a facelift. In normal scriptiong you'd dot walk, but in this database view builder its "prefix_field" in the where clause.
