User bio
404 bio not found
Member since Apr 27, 2017
Posts:
Replies:
Welcome to the DC, @DC AI Bot
Hello @Evgeny Shvarov
We can define the global name using either a compile-time class parameter or a runtime expression (COSEXPRESSION):
- Compile-time:
Parameter GlobalName = {$NA(^AGlobal)};
- Runtime (COSEXPRESSION):
Parameter GlobalName As COSEXPRESSION = "$NA(^AGlobal)";
Instead of assigning just the global name to the parameter and then later generating the full reference using $NAME
, you can directly assign the full $NA(^AGlobal)
expression to the parameter.
This eliminates the need to do something like:set gn = $name(..#GlobalName)
Parameter GlobalName As COSEXPRESSION = "$NA(^AGlobal)";
Parameter GlobalName1 = {$NA(^AGlobal)};
ClassMethod SetGbl()
{
Set @..#GlobalName1("test")=112
zw @..#GlobalName
}
Open Exchange applications:
Certifications & Credly badges:
Ashok Kumar has no Certifications & Credly badges yet.
Global Masters badges:







Followers:
Following:
Here is the simplified version of the LIKE operator with SQL Procedure
Stored procedure
/// add multiple parameters depends on needs Query NAMEINLIKE(p1 As %String = "", p2 As %String = "") As %Library.SQLQuery [ SqlProc ] { SELECT Name,Age FROM Sample.Person WHERE Name like :p1 or Name like :p2 }
SQL query
select * FROM SAMPLE.PERSON_NAMEINLIKE('%Eisenstien%','Xenia%')
ClassMethod INLIKE(pSQLColumnValue, pSearchValues...) As %Boolean [ SqlProc ] { Set rtn=0 For i=1:1:$O(pSearchValues(""),-1) { Set data = pSearchValues(i) If $E(data,1)="%"&&($E(data,*)="%") { Set data = $TR(data,"%") If pSQLColumnValue[data s rtn=1 } ElseIf $E(data)="%" { Set data = $TR(data,"%") Set pat = ".ANPC1"""_data_""".ANPC" If pSQLColumnValue?@pat Set rtn = 1 } ElseIf $E(data,*)="%" { Set data = $TR(data,"%") Set pat = "1"""_data_""".ANPC" If pSQLColumnValue?@pat Set rtn = 1 } } quit rtn }
SQL Query
SELECT * FROM SAMPLE.PERSON WHERE 1=SAMPLE.PERSON_INLIKE(FirstName,'%vid','Zelda%')