All
Accepted answers
Irène Mykhailova · Aug 27, 2022 go to post

I'm really glad I could attend Global Summit this year! I had a blast! And I look forward to the next year's Summit laugh

Irène Mykhailova · Aug 8, 2022 go to post

I love it! It's so much more informative right now! Of course, it would be nice to have the same in other supported languages, French for example  winkcheeky

Irène Mykhailova · Jul 26, 2022 go to post

OK it's good and interesting but is it possible to also realize RESTfull service based on Django?

Irène Mykhailova · Jul 5, 2022 go to post

Hmm, this is strange, in the article "How to earn points" it says that a post on the French community gives 400 pints, and here it is just 200. And for translation, it is 150 vs 50.

Irène Mykhailova · Jun 29, 2022 go to post

Another way to do it would be the following. Make TypeOfTest an array:

Class My.Test extends%Persistent
{
Property PatientName;Property TypeOfTest as array of %String; //%Numeric maybe?Property OrderID;
}

In the array, each element is a pair of key and value. In this case, you add a key with the name of type of test and with value the result of test. And if the "Name" is "Thyroid", then you add the rest of the elements. For example:

do test.TypeOfTest.SetAt("10", "Thyriod")
  do test.TypefTest.SetAt("148", Tsh)

This way, for your array in SQL you will get a separate table, the name of it will be a combination of class name and property name.

You can actually write a select just to query results of the tests and then find the name of the order using the primary key (which is a link to the main table My.Test)

Irène Mykhailova · Jun 29, 2022 go to post

Hello,

I would suggest you do the following.

I understand you have a class something like:

Class My.Test extends%Persistent
{
Property PatientName;Property TypeOfTest as My.TestType;Property OrderID;
}

Make TypeOfTest an instance of another class My.TestType:

Class My.TestType extends%SerialObject
{
Property Name As%String(VALUELIST = ",Sugar,Urine,Thyroid");Property Tsh;
...
}

In this case, as Robert has mentioned, you will be able to write a query like 

select PatientName, TypeOfTest_Name, TypeOfTest_Tsh
  from My.Test