Hi @pedro ,
Thanks for your response.
it's the case for all the instances in Movie node, not for a particular movie id
Moreover, i could see the details for the same node in Stardog studio
Also could find a strange behavior, when i tried to filter based on subject IRI. Hope if this get solved, then i may be able to see the details in Stardog explorer. Please Correct me if I'm wrong.
note: Tried with double quotes and single quotes appended for filter value as well like FILTER(?movies = "<http://ey.com/movies/21032>""). but no luck.
Query Plan for above query:
From default
From named local named
From named virtual
Slice(offset=0, limit=1000) [#258]
`─ Projection(?movies, ?genretriple, ?movieId, ?imdbId) [#258]
`─ Bind(<http://abc.com/movies/21032> AS ?movies) [#258]
`─ NestedLoopJoin(_) [#258]
+─ NestedLoopJoin(_) [#233]
│ +─ NestedLoopJoin(_) [#233]
│ │ +─ VirtualGraphMongoDB<virtual://spokeAproduct> [#116] {
│ │ │ +─ RelNode=
│ │ │ +─ LogicalProject(imdbId=[$1])
│ │ │ +─ LogicalFilter(condition=[AND(=($1.0, '21032':VARCHAR(2048)), IS NOT NULL($1))])
│ │ │ +─ UnwoundRel(coll=[movies], key=[[$_id]], projection=[movieId=$id, imdbId=$imdb_id, lang=$original_language, title=$original_title])
│ │ │ +─ Query=
│ │ │ +─ { $match : {$and : [ {"id" : {$eq : "21032"}}, {"imdb_id" : {$exists : true, $ne : null}} ]} },
│ │ │ +─ {$project: {imdbId: '$imdb_id'} }
│ │ │ +─ Vars=
│ │ │ +─ ?imdbId <- COLUMN($0)^^xsd:string
│ │ │ }
│ │ `─ VirtualGraphMongoDB<virtual://spokeAproduct> [#174] {
│ │ +─ RelNode=
│ │ +─ LogicalProject(gName=[$1])
│ │ +─ LogicalFilter(condition=[AND(=($0, '21032':VARCHAR(2048)), IS NOT NULL($1))])
│ │ +─ UnwoundRel(coll=[movies], unwind=[[$genres]], projection=[movieId=$id, gName=$genres.name])
│ │ +─ Query=
│ │ +─ {$unwind: "$genres"},
│ │ +─ { $match : {$and : [ {"id" : {$eq : "21032"}}, {"genres.name" : {$exists : true, $ne : null}} ]} },
│ │ +─ {$project: {gName: '$genres.name'} }
│ │ +─ Vars=
│ │ +─ ?genretriple <- TEMPLATE(http://abc.com/movies/{gName/0})
│ │ }
│ `─ VirtualGraphMongoDB<virtual://spokeAproduct> [#116] {
│ +─ RelNode=
│ +─ LogicalProject(movieId=[$0])
│ +─ LogicalFilter(condition=[AND(=($2.0, '21032':VARCHAR(2048)), IS NOT NULL($0))])
│ +─ UnwoundRel(coll=[movies], key=[[$_id]], projection=[movieId=$id, imdbId=$imdb_id, lang=$original_language, title=$original_title])
│ +─ Query=
│ +─ { $match : {$and : [ {"id" : {$eq : "21032"}}, {"id" : {$exists : true, $ne : null}} ]} },
│ +─ {$project: {movieId: '$id'} }
│ +─ Vars=
│ +─ ?movieId <- COLUMN($0)^^xsd:string
│ }
`─ VirtualGraphMongoDB<virtual://spokeAproduct> [#129] {
+─ RelNode=
+─ LogicalProject
+─ LogicalFilter(condition=[=($3.0, '21032':VARCHAR(2048))])
+─ UnwoundRel(coll=[movies], key=[[$_id]], projection=[movieId=$id, imdbId=$imdb_id, lang=$original_language, title=$original_title])
+─ Query=
+─ { $match : {"id" : {$eq : "21032"}} },
+─ {$limit:1}
+─ Vars=
+─
}
Please advise.
Thanks,
Muthu

