Get all Journal voucher using financial dimensions Query x++ D365 Finance and Operations

 Get all Journal voucher using financial dimensions x++ D365 Finance and Operations

select DIMENSIONATTRIBUTE.Name, DIMENSIONATTRIBUTELEVELVALUEALLVIEW.DISPLAYVALUE, DIMENSIONATTRIBUTE2.Name, DIMENSIONATTRIBUTELEVELVALUEALLVIEW2.DISPLAYVALUE,

DIMENSIONATTRIBUTE3.Name, DIMENSIONATTRIBUTELEVELVALUEALLVIEW3.DISPLAYVALUE,* from GeneralJournalAccountEntry

join DIMENSIONATTRIBUTELEVELVALUEALLVIEW on GeneralJournalAccountEntry.LEDGERDIMENSION = DIMENSIONATTRIBUTELEVELVALUEALLVIEW.VALUECOMBINATIONRECID

join DIMENSIONATTRIBUTE on DIMENSIONATTRIBUTE.RECID = DIMENSIONATTRIBUTELEVELVALUEALLVIEW.DIMENSIONATTRIBUTE

join DIMENSIONATTRIBUTELEVELVALUEALLVIEW as DIMENSIONATTRIBUTELEVELVALUEALLVIEW2 on GeneralJournalAccountEntry.LEDGERDIMENSION = DIMENSIONATTRIBUTELEVELVALUEALLVIEW2.VALUECOMBINATIONRECID

join DIMENSIONATTRIBUTE as DIMENSIONATTRIBUTE2 on DIMENSIONATTRIBUTE2.RECID = DIMENSIONATTRIBUTELEVELVALUEALLVIEW2.DIMENSIONATTRIBUTE

join DIMENSIONATTRIBUTELEVELVALUEALLVIEW as DIMENSIONATTRIBUTELEVELVALUEALLVIEW3 on GeneralJournalAccountEntry.LEDGERDIMENSION = DIMENSIONATTRIBUTELEVELVALUEALLVIEW3.VALUECOMBINATIONRECID

join DIMENSIONATTRIBUTE as DIMENSIONATTRIBUTE3 on DIMENSIONATTRIBUTE3.RECID = DIMENSIONATTRIBUTELEVELVALUEALLVIEW3.DIMENSIONATTRIBUTE

where DIMENSIONATTRIBUTE.NAME = 'Projects'
and DIMENSIONATTRIBUTELEVELVALUEALLVIEW.DISPLAYVALUE ='PCB-000051'
and DIMENSIONATTRIBUTE2.NAME = 'PURPOSE'
and DIMENSIONATTRIBUTELEVELVALUEALLVIEW2.DISPLAYVALUE ='PSL-0002'
and DIMENSIONATTRIBUTE3.NAME = 'MainAccount'
and DIMENSIONATTRIBUTELEVELVALUEALLVIEW3.DISPLAYVALUE ='35710010005'