Dynamics Community Forum Thread Details

How to integrate queries by using view?

Hi, experts.
I want to integrate these three queries into one. I attempted to create a view for the second query, selecting values from table B without going through table A, and tried to integrate the values from the view along with the data from table C into a string variable for the parent query, but it didn't work well. I want to filter the data based on the condition /tableB.FieldY == tableA.Field1/ only for Field X.　I want to get other data without any conditions. How can I integrate them into one query?

while select
        Field1,
        Field2,
        Field3,
    from
        transactionTemp
{
    TableB transactionLine;
    select minOf(FieldX)
    from transactionLine
    where transactionLine.FieldY == transactionTemp.Field1;

    TableC tempSplit;
    tempS.Field1 = transactionTemp.Field1;
    tempS.Field2 = transactionTemp.Field2;
    tempS.Field3 = transactionLine.FieldX;
    tempS.insert();
}
while select
        Field1,
        Field2,
        Field3,
    from
        tempS
    order by
        tempS.Field1,
        tempS.Field2,
        tempS.Field3
{
    str field1 = tempS.Field1;
    str field2 = tempS.Field2;
    str field3 = tempS.Field3;
}

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL