Getting values with criteria from a field

siimsand · 2017-12-20

Hello!

I've created an option type field in the Item(27) table with options 1, 2 and 3. If I'm counting the number of objects with, let's say, option 2, then how do I get that object in code?
I have:

IF _Item.FINDSET THEN
REPEAT
_SoftcaseObjects += _Item.<this is where the option should be if I'm on the right track>;
UNTIL _Item.NEXT = 0;

Thanks in advance!

AK · 2017-12-20

If you mean the number of item records with the option value 2, then:

item.setrange(optionfield,optionfield::2);
SoftcaseObjects = item.count;
item.setrange(optionfield);

You might want to create a key with the optionfield, depending on the number of records in the item table and on how often you perform that count.
Another solution would be a flow field with method "count". It depends on what you want to achieve.

BTW, underscores at the beginning of a variable are a really bad idea.

AK · 2017-12-20

If you mean the number of item records with the option value 2, then:

item.setrange(optionfield,optionfield::2);
SoftcaseObjects = item.count;
item.setrange(optionfield);

You might want to create a key with the optionfield, depending on the number of records in the item table and on how often you perform that count.
Another solution would be a flow field with method "count". It depends on what you want to achieve.

BTW, underscores at the beginning of a variable are a really bad idea.

Howdy, Stranger!

Quick Links

Categories

Getting values with criteria from a field

Best Answer

Answers