After running this query
select
*
from
`mongo.grounds`.`Elements` element
where element.PlanId = '1623263140';
Nothing is returned. Please see the attached screenshot.
[image: Screen Shot 2022-02-04 at 10.08.07 AM.png]
On Fri, Feb 4, 2022 at 10:03 AM James Turton <dz...@apache.org> wrote:
> Do you get records from this query?
>
> select
> *
> from
> `mongo.grounds`.`Elements` element
> where element.PlanId = '1623263140';
>
> Incidentally, for the full query including the WHERE clause, the form
> below is probably going to be a good deal faster than the ones we've
> written so far. I reintroduced some backticks, just in case that was
> causing any trouble.
>
> with element as (
> select
> `_id`,
> ElementTypeName,
> ElementSubTypeName,
> PlanId
> FROM
> `mongo.grounds`.`Elements`
> where PlanId = '1623263140'
> ), element_effort as (
> select
> `_id`,
> EffortTypeName
> FROM
> `mongo.grounds`.`Elements_Efforts`
> )
> select
> *
> from
> element
> join
> element_effort on element.`_id` = element_effort.`_id`
>
> On 2022/02/03 17:05, Daniel Clark wrote:
> > I tried again with this query:
> >
> > with element as (
> > select
> > _id,
> > ElementTypeName,
> > ElementSubTypeName,
> > PlanId
> > FROM
> > `mongo.grounds`.`Elements`
> > ), element_effort as (
> > select
> > _id,
> > EffortTypeName
> > FROM
> > `mongo.grounds`.`Elements_Efforts`
> > )
> > select
> > *
> > from
> > element
> > join
> > element_effort on element._id = element_effort._id
> > where element.PlanId = '1623263140'
> >
> > The query completed successfully, but it did not return any rows. I've
> > attached the log and the profile.
>
