Grid to show database records.
Quote from lesanch on March 2, 2020, 9:52 pmHi @Luishp
Habría algún modo de visualizar los datos leídos desde una tabla en una bbdd Oracle en una grilla ?? Hasta donde se es posible usando el plugin NeoTable leer registros desde Mysql, pero eso mismo usando Json, sería posible ??
Por otro lado, para usar este mismo post, pregunto: es posible que el menú desplegable muestre submenús ? algo similar a esto:
suma
---> suma algrebraica
---> suma aritmética
resta
división
etc...
Saludos y gracias,
Sam
Hi @Luishp
Habría algún modo de visualizar los datos leídos desde una tabla en una bbdd Oracle en una grilla ?? Hasta donde se es posible usando el plugin NeoTable leer registros desde Mysql, pero eso mismo usando Json, sería posible ??
Por otro lado, para usar este mismo post, pregunto: es posible que el menú desplegable muestre submenús ? algo similar a esto:
suma
---> suma algrebraica
---> suma aritmética
resta
división
etc...
Saludos y gracias,
Sam
Quote from Gaev on March 3, 2020, 12:11 am@lesanch
Would there be any way to visualize the data read from a table in an Oracle database in a grid? As far as it is possible using the NeoTable plugin to read records from Mysql, but using Json, would that be possible?
I have never worked with an Oracle Database ... so I am not familiar with the format of the data (records) returned in response to a Query.
But if you can tell us what the response data looks like (csv, jason), it should be possible (with scripting) to feed it into a neoTable.
Perhaps you can tell us how it looks e.g. ...
"John","Smith","Male"40,"Accountant" "Jane","Doe","Female",45,"Lawyer etc. OR [ {"FirstName":"John","LastName":"Smith","Gender":"Male","Age":40,"Profession":"Accountant"}, {"FirstName":"Jane","LastName":"Doe","Gender":"Female","Age":45,"Profession":"Lawyer"}, etc. ]... or something else.
Would there be any way to visualize the data read from a table in an Oracle database in a grid? As far as it is possible using the NeoTable plugin to read records from Mysql, but using Json, would that be possible?
I have never worked with an Oracle Database ... so I am not familiar with the format of the data (records) returned in response to a Query.
But if you can tell us what the response data looks like (csv, jason), it should be possible (with scripting) to feed it into a neoTable.
Perhaps you can tell us how it looks e.g. ...
"John","Smith","Male"40,"Accountant"
"Jane","Doe","Female",45,"Lawyer
etc.
OR
[
{"FirstName":"John","LastName":"Smith","Gender":"Male","Age":40,"Profession":"Accountant"},
{"FirstName":"Jane","LastName":"Doe","Gender":"Female","Age":45,"Profession":"Lawyer"},
etc.
]
... or something else.
Quote from luishp on March 3, 2020, 10:32 am@lesanch neoTable trabaja con datos JSON. Hay un tutorial magnífico de @gaev (cuyo código puedes encontrar entre las aplicaciones de ejemplo) aquí:
https://visualneo.com/tutorials/neotable/Respecto a los menús, mira aquí:
https://visualneo.com/forum/topic/menu-builderSaludos!
@lesanch neoTable trabaja con datos JSON. Hay un tutorial magnífico de @gaev (cuyo código puedes encontrar entre las aplicaciones de ejemplo) aquí:
https://visualneo.com/tutorials/neotable/
Respecto a los menús, mira aquí:
https://visualneo.com/forum/topic/menu-builder
Saludos!
Quote from lesanch on March 4, 2020, 3:34 amHi Gaev,
Thanks for replay, i was searching a little and Oracle supports Json native from version 12 and up and the output could be in different formats, so that's not the version that i need right now to get the data, in fact i needed from multiples oracle versions, so the hard work i have to do to get json scripts in versions under 12 it's not justify. Maybe later in few month when migrate database version i will be asking for help with this.
Thank you very much for the help.
Regards,
Samir
Hi Gaev,
Thanks for replay, i was searching a little and Oracle supports Json native from version 12 and up and the output could be in different formats, so that's not the version that i need right now to get the data, in fact i needed from multiples oracle versions, so the hard work i have to do to get json scripts in versions under 12 it's not justify. Maybe later in few month when migrate database version i will be asking for help with this.
Thank you very much for the help.
Regards,
Samir