go to post Muhammad Waseem · Dec 4, 2021 Hi Mr. Evgeny Shvarov Please note that I have added OAuth2 support along with Article for Data_APP_Security appThanks
go to post Muhammad Waseem · Dec 3, 2021 Hi, I am requesting points for translated article in Spanish for Data_APP_Security app https://es.community.intersystems.com/post/c%C3%B3mo-crear-usuarios-conc... Thanks
go to post Muhammad Waseem · Dec 1, 2021 Hi Mr. Evgeny Shvarov Thanks for sharing Please note that Data_APP_Security app already have article on DC Thanks
go to post Muhammad Waseem · Nov 16, 2021 set st = ##class(%SQL.Statement).%New(2,"Sample")set sql = 3set sql(1) = "select TOP 5 %ID as id, Name, DOB, Home_State"set sql(2) = "from Person where Age > 40"set sql(3) = "order by 2"do st.%Prepare(.sql)for type="txt","pdf","csv","html","xml" { set rs = st.%Execute() do rs.%DisplayFormatted(type,"C:\Temp\report")}
go to post Muhammad Waseem · Nov 16, 2021 Hi, use %SQL.StatementResult:%DisplayFormatted()Please find below sample code(SAMPLE namespace):set st = ##class(%SQL.Statement).%New(2,"Sample") set sql = 3 set sql(1) = "select TOP 5 %ID as id, Name, DOB, Home_State" set sql(2) = "from Person where Age > 40" set sql(3) = "order by 2" do st.%Prepare(.sql) for type="txt","pdf","csv","html","xml" { set rs = st.%Execute() do rs.%DisplayFormatted(type,"C:\Temp\report") }
go to post Muhammad Waseem · Nov 15, 2021 Hi Michael, I submitted the request for CN translation. Thanks
go to post Muhammad Waseem · Nov 13, 2021 Congratulations! DC helped me a lot. good to see DC is growing.
go to post Muhammad Waseem · Nov 4, 2021 Try getGeneratedKeys() function https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=BGJD_coding Thanks
go to post Muhammad Waseem · Nov 4, 2021 Try getGeneratedKeys() function https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=BGJD_coding Thanks
go to post Muhammad Waseem · Oct 31, 2021 Hi @Rodolfo Moreira, Looks Like it is related to license. How can I extend the expiry of license ? Thanks
go to post Muhammad Waseem · Oct 19, 2021 Add any false statement in where clause e.g add where 1 = 0 Thanks
go to post Muhammad Waseem · Oct 18, 2021 Thanks Julian Matthews for the feedback. Actually this is just an idea.Apart what you already mentioned still reference ranges might be depending on age /sex as well. Hopefully will consider them in next release.Thanks
go to post Muhammad Waseem · Oct 13, 2021 Hi @Evgeny Shvarov, Please review the below snapshot How can I refer "test_banzai7.csv" file as do ##class(community.csvgen).Generate("test_banzai7.csv") command does not work. Thanks