Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

SQL Query returning 0's for values

Posted on by 65

Query-returns-0.png

I've set up the query with a few different joins. 

Where you see the value hardcoded it's supposed to be a value coming in from the client side.

I tried hard coding as I wanted to see if it was a problem with the query and I'm no further in understanding why this is happening. 

You can see from the image the table holds the values I've hardcoded. 

If you look at the debugger the recId = 0 in each joined table I called. 

Is there a problem with my join somewhere to where I won't even get the value for the first buffer variables?

  • JGjinx321 Profile Picture
    JGjinx321 65 on at
    RE: SQL Query returning 0's for values

    Thank you, I closed the joins and re-added them line by line to see which relation was causing the problem. If it matters it was spiffChassis.

  • Verified answer
    ergun sahin Profile Picture
    ergun sahin 8,812 Super User on at
    RE: SQL Query returning 0's for values

    You are using inner join so saying "I won't even get the value for the first buffer variables" not correct. Try outer join or close extra joins and open them step by step

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans