All
Accepted answers
Mindy Caldwell · Apr 28, 2023 go to post

Edward,  Thank YOU!   You solved the problem.  I'll need to do more testing but on first glance it appears that by adding  COLLATION = "Space" to the property and recompiling the class, the CMQL select now works as I expect.

Mindy Caldwell · Apr 26, 2023 go to post

Edward,  Thanks for your suggestion.

Class modified as suggested.  Index rebuilt.

Select command still  fails unless I put the leading space.

TRAX:SELECT ISELLER WITH FundraiserId = "HTE_FSG_SPRING2022"

[401] No items present.
TRAX:SELECT ISELLER WITH FundraiserId = " HTE_FSG_SPRING2022"

505  Items selected to list #0
TRAX>>clearselect
TRAX:SELECT SALESREP WITH FundraiserId = "HTE_FSG_SPRING2022"

505  Items selected to list #0
TRAX>>clearselect
TRAX:
Mindy Caldwell · May 5, 2022 go to post

Well,  I won't win any prizes but I just wanted to rejoice in writing my first classmethod in objectscript.

Here is my less than elegant solution

ClassMethod Detector(a As %String, b As %String) As %Boolean
{
  SET a=$CHANGE(a," ","")
  SET a=$ZCVT(a,"l")
  SET b=$CHANGE(b," ","")
  SET b=$ZCVT(b,"l")
  SET c = ""
  FOR i = 1 :1 :$L(a)
  {
    SET p = $F(b,$E(a,1))
    if p { SET $E(b,p-1)="" } else { set c=c_$E(a,1) }
    set $E(a,1)=""
  }
  if ($L(a) + $L(b) + $L(c) ) { q 0 } else { q 1 }
}

}