Pointer value not always return its reference data value

[Yaniv]

Hi,
In our database structure we have a collection that contains several columns that are pointer to the same table.
Not all the time we have values populated for all columns, means that some rows are fully populated and some rows contains several empty pointer columns.
While we need to query the information in order to get the reference value as well we specify ALL related columns that exists in the table under include.

While querying the DB:
In case ALL pointer columns are populated - no issue, information retrieved with the reference values as well.
In case PART of the pointer columns are populated - we are getting for some the reference value and for some the pointer itself only.

i.e.

"Item_1":{
"Description":"AAA",
"MainImg":"main-img-t",
"SecImg1":"sec-img-t",
"SecImg2":"sec-img-t2",
"Title":"BBB",
"Type":"1",
"createdAt":"2013-10-24 20:30:20.792",
"id":"5269835ce4b03be988b6dc64",
"updatedAt":"2014-01-05 20:44:14.808"
},
"Item_2":{
"collName":"Item_Ref",
"id":"5611835ce4b03be111b2dc08"
},
"Item_3":{
"collName":"Item_Ref",
"id":"5090835ce4b03be368b6dc23"
},
"Item_4":{
"Description":"CCC",
"MainImg":"main-img-c",
"SecImg1":"sec-img-c",
"SecImg2":"sec-img-c2",
"Title":"DDD",
"Type":"2",
"createdAt":"2013-10-24 20:30:20.792",
"id":"511235ce4b03be608b6dc11",
"updatedAt":"2014-01-05 20:44:14.808"
},

*The table is populated as expected from pointer column,
*In case we populating all pointer columns - there is no issue for the same row that minute ago we face issue since not all pointer column was populated.

Can you please suggest

Thanks

[Illya Stepanov]

Hi Yaniv,

We will test this and will update you.

[Maryna Brodina]

Hello! This is how it works - populating for table with pointer starts from end right column. If pointer is empty for some column all the following pointers for current record won't work and just gives pointer value itself. It looks like a bug, I'll report it.

[Yaniv]

Hi Maryna,
As you can see in my example above all 4 records are populated with the pointer but while querying I get for the 1st and 4th referance value and for the other 2 (2nd and 3rd) im getting the pointer only

[Maryna Brodina]

Hello! We've reported this problem already. Developers are looking into this issue. Sorry for inconvenience.

[Hen Reu]

do u have an estimation of time for the fix(Build Number)?
cause it is a bottleneck for my project.

Thanks,
Chen R

[Maryna Brodina]

Sorry, don't have ETA yet, but I'll check and let you know.

[Maryna Brodina]

Hello! It's going to be fixed in next release (around January 18). Workaround: fill null pointer values with some data: use some existing object as a "null" value indicator.