go to post Jimmy Christian · Apr 18, 2019 Thank you all. Only reason i have to do it is because i cannot import the csv file data into my table in USER namespace using IMPORT WIZARD. Wizard is not working and throwing CSP error.I will try and see if i am able to map the class and package. and then run the query i need to extract the data. Thank you
go to post Jimmy Christian · Apr 12, 2019 Thanks Alexander. Version i have installed isCache for Windows (x86-64) 2017.2.2 (Build 865_0_18763U).It worked in previous version, so not sure if it could be related to it.
go to post Jimmy Christian · Feb 11, 2019 Thank you Jeffrey. I was able to pass the value to my function and worked very well. Glad to see such a rich set of methods and properties in the Enslib.HL7.Message which can be helpful in future. I appreciate your help and assistance.Regards,Jimmy Christian.
go to post Jimmy Christian · Feb 11, 2019 That seems very interesting. I wasn't aware of such method to import file or refer to a message in the file. Pretty interesting !Will test this out today and post . Just something i noticed is we have assigned the datatype to messages in tMsg object, which is after the fact of referring it to a filename.ext. So in this case if the message does not match schema/doctype , below command would fail.JEFF > set tMsg.DocType="2.3.1:ORU_R01"Correct?
go to post Jimmy Christian · Feb 9, 2019 Thank you Jeffrey. This looks perfect. I am going to test this and let you know.
go to post Jimmy Christian · Feb 8, 2019 Thank you Jeffrey. Yep, writing a new class and extending Functionset class is totally fine.But i am trying to find out if RuleDefinition class itself allows you to write any methods within it or you cannot embed a method within RuleDefinition class.
go to post Jimmy Christian · Feb 8, 2019 Thank you Eduard. But i want to code this method directly in my XYZ rule definition class instead of coding in a seperate class with functions.Reason is the Function set class is shared by many projects and i do not want to modify or update it.
go to post Jimmy Christian · Nov 20, 2018 Hello all,I used the ChangeQueryOnServer as a reference and my code is working good. This is from the ZenTest example in SAMPLES namespace.Regards,Jimmy
go to post Jimmy Christian · Nov 20, 2018 Thank you very much Vladimir .This was very helpful. I used the ChangeQueryOnServer as a reference and my code is working good.Regards,Jimmy
go to post Jimmy Christian · Nov 19, 2018 So i was successful creating the datagrid and some combo box. Making some progress. But....Got another hurdle. Help will be appreciated.I want the datagrid to reflect values based on the value i select in the Combobox. How to pass value from the combobox to the altJSONSQLProvider parameter and reload the datagrid ?My combobox defines below method on change. onchange="zenPage.rowSelected(zenThis.getValue());" <altJSONSQLProvider id="PatchClassJsonId" OnGetSQL="GetSQL" ><parameter paramName="1" value="C"/></altJSONSQLProvider><dataGrid ,......</dataGrid> Method GetSQL(ByRef pParm As %String, ByRef pSQL As %String, pCriteria As %ZEN.proxyObject, ByRef pPagingInfo As %String) As %Status{Set pParm= "zenPage.getComponentById('DataComboId').getValue()"Set pSQL = "SELECT ID,PatchClassName,Environment,ModuleName,ModuleClass,TargetConfig,BusinessRule,MessageSchemaCategory FROM ProjectInventory.TablePatchClass where PatchClassName %STARTSWITH ? " Quit $$$OK} Thank you..
go to post Jimmy Christian · Nov 19, 2018 Thank you very much Vasiliy Bondar.I tweaked the code as per my tables and fields and is working as expected. I appreciate your help.
go to post Jimmy Christian · Nov 18, 2018 Thank you very much ! I appreciate your time. I will apply it to my code and validate.