I have a demand to host a page where I can see a table with the hierarchical data from my DB.
Our MySQL database has 4 tables that are hierarchical and linked with foreign keys. So an entry on our first table is composed by entries from our 2nd table, so on and so forth until level 4 that has the most detailed info. What we need is to see a table with our 1st level (table operations) and if necessary expand to the 2nd level (table positions) seeing which positions compose the operation. We expect something like a '+' button to do that (similar to [url removed, login to view]).
By default the table should show our 1st level data filtering only today's data. We want to be able to filter older data by date or by ID (operationId).
In summary, two filters for the queries (date and operationId) presenting by default our daily operations presenting this data in a table that supports different levels of entries (exploding 1st level shows the child entries on the 2nd level table, expanding the 2nd level entries show the 3rd level child entries, etc).
If we were going to do it we would use Swagger, Flask and SQLAlchemy on the backend, if you can do it using these solutions it would be great.
Rodrigo Silva Cosme
43 freelance ont fait une offre moyenne de 1853 R$ pour ce travail
yes, let's clarify the requirement in details also if you want us to share our skill and previous work let us know.. hope to hear you soon.. Thanks & Regards RIMSHA