Data source good, but SQL Prep failure when in App

[mramos]

I'm having an issue that began when I added a CTE and an additional left join table (for a total of 2 inner joins and 2 left joins) to my select statement in my data source.

My data source is mostly used by a tree grid to show totals/summary fields.... All data checks out when I save my tree grid pops up with an error when I load into my application. I'd really like to not be limited by the use of CTE OR left joins if that is what is triggering the issue.... screen shots attached. There is another application I'm using that is similar with the same issue... Thank you!

[Johnny Major]

What level of the tree grid is this data source used on?

Thanks

[mramos]

It is at level 1.

[Johnny Major]

Unfortunately we are unable to replicate this issue. Can you please email support so we can setup a very quick online meeting

Thanks

[mramos]

I'm now on Valence Framework 6.1.20230224.0 and that seems to have resolved the problem. I have not replicated it since.

Thanks, Johnny.

[Johnny Major]

Great, thanks for letting us know