Bilgi Bankası Makalelerinde Ara

Ürün Listesi Raporlama 

[Price List:5 ,3,6, 2]
>ÜRÜN|PORS|KATEGORİ|[C]FİYAT

{REPORT SQL DETAILS:

    SELECT

        product.[GroupCode] AS [Group],

        product.[Name] AS [Product],

        portion.[Name] AS [Portion],

        price.[Price] AS [Price]

    FROM [MenuItems] product 

    LEFT JOIN [MenuItemPortions] portion 

    ON product.[Id] = portion.[MenuItemId] 

    LEFT JOIN [MenuItemPrices] price

    ON price.[MenuItemPortionId] = portion.[Id]

    ORDER BY product.[GroupCode]

    :F.Product,F.Portion,F.Group,F.Price::{0} |{1}| {2}| {3}

}

Bu makaleyi yararlı buldunuz mu?

İlişkili Makaleler

  • Menü Yaml Formatı

    - Name: Test Item 1 GroupCode: Test Items Barcode: 12345 Tag: Tag1 Portions: - Name: Pcs ...

  • Database Clear

    DELETE FROM [TicketEntities]GODELETE FROM [Tickets]GODELETE FROM [AccountTransactionDocuments]GODELE...

  • Payment - Transactions Report

    [Report:1,2, 1] >Payment Total|| CREDIT CARD TOLTAL:||[=F((TN("{ACCOUNT TRANSACTION TOTAL:Payment...

  • Server Clock Out Report

    [Server Checkout:1,1]User|{SETTING:CURRENTUSER}Clocked In|{REPORT TASK DETAILS:T.StartDate,T.StartTi...

  • metrik

    [S1:1, 1]{REPORT TICKET TYPES:!PreOrder && TotalAmount >= 0} [O1:1, 1]{REPORT TICKET TYPE...