Forum | Appery.io

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

Hi Yaniv,

We will test this and will update you.

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.

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

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

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

Thanks,
Chen R

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

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.