kasen0177

Explore posts from servers

CC#JCHJava Community | Help. Code. Learn.

PostsComments

CC#

•Created by kasen0177 on 8/15/2024 in #help

performance issue when using Oracle sql versions query

I’m tryna do the versions query trying to get the user who did the operation with the versions_xid using dbms_flashback_archive.get_sys_context However, when I combine that with sorting the query takes 17 seconds to load

1 replies

CC#

•Created by kasen0177 on 7/23/2024 in #help

Help needed with design design

So i am creating an audit log dashboard I will have a dropdown of tables, user select one and I fetch the audit logs for that table. I have a quite a of tables to fetch I am using the Clean Architecture. I was thinking of having function called GetLogByTable(string tableName) but then I have like 7 entities and I would have to map to dto dynamically which confuses me. Is there a better approach?

15 replies

CC#

•Created by kasen0177 on 6/14/2024 in #help

Devexpress loadOptions parse filter array, how to handle in serverside

Anyone know how to parse the array or restructure to make it easier the syntax var filter = [ ["Product_Current_Inventory", "<>", 0], "or", [ ["Product_Name", "contains", "HD"], "and", ["Product_Cost", "<", 200] ] ]

15 replies