Improve "Database event log" readability

Hi ​@Edwin Saan,

You can view any request Universal makes, including input and output in F12 → Network.
This is a built-in browser feature that is available in any website. 🙂
If I take the task Insights → Finance → Generate sales invoice → Generate invoices as example, in F12 you can see a “choose” request when changing the “Customer” lookup.
When clicking this choose request, you can see the customer_id in the request URL.
On non lookup patches you can see the value being patched in the “Payload” tab.
The response from Indicium can be viewed in the “Preview” tab.

Do note that it will only start logging requests when opened. So you can't test something and open F12 → Network afterwards, as then the requests won't show up.

Kind regards,
Leroy Witteveen
 

See below an example. I just copy the form parameters and the values from f.e. the layout or the default or the contact and copy them to SSMS to query the record… 
I’m pretty sure I’m not the only one… The is a huge ommission!!!

​@Edwin Saan, besides F12 that I already mentioned, additionally if you are logged in as a developer, in the profile menu you can open the “Database event log” to look at this from the Indicium/database perspective:
 

Leroy, Are you really meaning that I need to extract an ID from this: 

https://serp.saan.nl/indicium/iam/80/view_opdracht_structuur?useControlBasedFiltering=true&$filter=((opdracht_basis_id%20eq%201303))&$orderby=opdracht_nummer%20desc,opdracht_deel_nummer%20asc,opdracht_dag_nummer%20asc,opdracht_regel_nummer%20asc&$prefilter=jaar_terug,niet_gearchiveerd,instelling_1&$skip=0&$top=0&$count=true

Thank you for giving me a direction, but I hope this is not a really serious answer relating to where we came from where I have all variables and there values direct in front of me, including the comma’s. I just need to add select * from tabel where. Please make this much better!!!! Give me a button on each page where all the variables and the values are shown…. 

O yes, the database eventlog, also such a dragon….  That gives me this…. I’m paid for developing not for putting lots of times in decoding unreadable and unstructured debug information… 

Hi ​@Edwin Saan,

My apologies, I wrongly understood that you didn't find the database event log or F12 debugging possibilities yet.
I agree that the database event log readability could be improved, we will investigate this.
If you have improvements in mind, please let us know!

Kind regards,
Leroy Witteveen

Can we change this item to an idea? I think it will get many upvotes

​@Edwin Saan done, I added a summary to the top of your original post, feel free to edit (if possible) or let me know if additions/changes need to be made.

Thank you very much, this would be a great benefit for all of us!