Breaking News: Grepper is joining You.com. Read the official announcement!

Problem: Multiple Request for Retrieve Relational Data

Add Answer

Anjali Sharma answered on February 2, 2023 Popularity 1/10 Helpfulness 1/10

answer Problem: Multiple Request for Retrieve Relational Data

Problem: Multiple Request for Retrieve Relational Data

Comment

Problems

● Business teams want to see relational data on

screen. N+1 problem.

● Customer – Orders – Products

● REST: /customer/3/orders/4/products ?

● How we can get Products from Order X for

Customer Y ?

● Chatty Calls for enriching data

Solutions

● GraphQL API Design

● Structural relational data with querying

GraphQL AP

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[sp_myPersonalSalesOrderInfosList] 
     @OrderNumber NVARCHAR(50)
AS
BEGIN
    SET NOCOUNT ON;

    --Dt 1 
    SELECT TOP 1 
        OrderNumber,
        PLAN_AMOUNT Planamount,
        ID MppId
    FROM 
        PRODUCT_PLAN
    WHERE 
        OrderNumber LIKE '%' + @OrderNumber + ''
        AND isDeleted = 0;

    --dt2 
    SELECT 
        p.OrderNumber,  
        p.PLAN_AMOUNT Planamount,
        p.ID MppId,
        p.ProcessNo OpNo,
        m.MACHINE_CODE + '-' + m.MACHINE_NAME MachineInfo
    FROM
        PRODUCT_PLAN p
    JOIN 
        MACHINES m ON m.ID = p.MACHINE_ID
    WHERE 
        OrderNumber LIKE '%' + @OrderNumber + ''
        AND isDeleted = 0;

    --dt 3 
    SELECT 
        p.ID MppId,
        d.ID MppdId,
        d.PRODUCTION_AMOUNT ProductAmount
    FROM 
        PRODUCT_PLAN_DETAIL d
    JOIN 
        PRODUCT_PLAN p ON p.ID = d.MPP_ID
    WHERE 
        OrderNumber LIKE '%' + @OrderNumber + ''
        AND p.isDeleted = 0
        AND d.PRODUCTION_AMOUNT > 0;
END

https://www.ibm.com/topics/relational-databases

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: relational request sql

Link to this answer
Share Copy Link

Contributed on Feb 02 2023

Anjali Sharma

0 Answers Avg Quality 2/10

Problem: Multiple Request for Retrieve Relational Data

Contents

More Related Answers

Problem: Multiple Request for Retrieve Relational Data

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.