Reisacher-Forderung/templates/forderungen/details/queries/forderungen_buchungen.sql

SELECT TOP 1000 [Client_DB]
     , [Kunde_Nr]
     , [Fahrzeug_Nr]
     , [Beleg_Nr]
     , [Bezug_Beleg_Nr]
     , [Beleg_Datum]
     , [Beleg_Beschreibung]
     , [Betrag]
     , [Benutzer_ID]
     , [Bezahlt]
     , [Beleg_Art]
FROM [dbo].[Forderungen_Buchungen]
WHERE (
	[Client_DB] = {{ appsmith.URL.queryParams.Client_DB }}
AND [Kunde_Nr] IN (SELECT [Kunde_Nr] FROM [dbo].[Forderungen_Mahnungen] WHERE [Beleg_Nr] = {{ appsmith.URL.queryParams.Beleg_Nr }} )
AND (
	('D' = '{{ BelegeFilter.selectedOptionValue }}')
	OR
	('F' = '{{ BelegeFilter.selectedOptionValue }}' AND [Fahrzeug_Nr] IN (SELECT [Fahrzeug_Nr] FROM [dbo].[Forderungen_Mahnungen] WHERE [Beleg_Nr] = {{ appsmith.URL.queryParams.Beleg_Nr }} )) 

)
	
) OR 1 != 1

ORDER BY [Beleg_Datum], [Beleg_Art], [Beleg_Nr]