Is it Possible to Know date and size of a imported solutn?

Questions and answers regarding general SQL and backend databases

Is it Possible to Know date and size of a imported solutn?

Postby cuoredisardegna » Tue Sep 12, 2017 6:49 pm

Hi to All,

could Someone resolve this problem?

I have imported, in the DB "repository_server" (Postgresql), 10 releases of "My_solution", but only the 9 is the Active release, because it works fine on Application Server.

Now, I have to develop the solution, starting from the release 9; but, I MUST BE SURE of finding the exact copy of exported release 9, so that I can import exactly it on Servoy_Developer, not to frustrate the work I have to do, using another release.

In order tho this I need to know the date and the size of the imported release n.9 in Application_server.

Is it possible to find them in "repository_server", or in same other way?
Or, is it possible to resolve this problem?

Tanks in advance.

Gianni Pinna
cuoredisardegna
 
Posts: 68
Joined: Mon May 07, 2012 5:34 am

Re: Is it Possible to Know date and size of a imported solut

Postby jcompagner » Thu Sep 14, 2017 10:11 am

if you query the servoy_repository table the servoy_releases do have a creation date (so the date that you imported it)
so you need to lookup the root_element_id from the servoy_root_elements and then check back with that id in the releases to see the creation_date.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Is it Possible to Know date and size of a imported solut

Postby cuoredisardegna » Sat Sep 16, 2017 10:54 pm

Hi Johan Compagner ,

tank You for Your liminous replay,
Hope all wll for You.
Humbly.

Gianni Pinna
cuoredisardegna
 
Posts: 68
Joined: Mon May 07, 2012 5:34 am


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 8 guests

cron