search

Starcounter / Home

Starcounter is an in-memory database application engine.
https://starcounter.io
27 stars 1 forks source link

ObjectID in Admin panel #442

Closed mmnosek closed 4 years ago

mmnosek commented 6 years ago

This problem related to testing single app hits me over and over.

I have a page shoppingcart/product/X that shows a specific product. This page is related to a product (X). It's not possible to open this page through navigation in the app, it's only specific URL that has to be opened. So I have to figure out what X is.

This page expects there ObjectID. I go to the Admin tool and execute the query: SELECT * FROM Showroom.Database.Product but I get only ObjectNo. There's no way to retrieve ObjectId easily, and it affects all of Starcounter apps. What can we do about that?

miyconst commented 6 years ago

There's no way to retrieve ObjectId easily, and it affects all of Starcounter apps. What can we do about that?

We can add a UI tool to convert ObjectNo to ObjectId and other way around. Would that work?

Mihaiii commented 6 years ago

We can add a UI tool to convert ObjectNo to ObjectId and other way around.

The conversion shouldn't be made in JS given that JS is not good with big numbers. That being said, if you still want to do it on Admin app level - meaning after it receives the data - I'm fine with it.

LE: I would prefer to receive the ObjectID when the results for a select query get to Admin app, but I guess for SC 2.4 I'll make a request and be done with it.

mmnosek commented 6 years ago

From the user/developer perspective it doesn't really matter how. I would like to have either additional column, or to click on ObjectNo and then receive ObjectId

warpech commented 6 years ago

Meanwhile, anyone who needs a tool to convert ObjectNo to ObjectID, can use this tiny command line app: https://gist.github.com/warpech/9c624c954afbbb70f28c77dec9702261

warpech commented 6 years ago

@Mihaiii made a better hosted tool: https://mihai.lib.id/base64@dev/?id=123456

miyconst commented 4 years ago

Closing as won't fix in Starcounter 2.4 and not applicable in Starcounter 3.0.