selecting a single TSPARMCD-TSVAL row and value

[JozefAerts]

For rule FB0804 (similar to the non-finished rule FB0803) I am still struggling.
The rule is "TSPARMCD.EXPSTDTC => EXENDTC or EXENDTC => TSPARMCD.EXPENDTC"
but I am currently only testing on the second part "EXENDTC => TSPARMCD.EXPENDTC"

For getting TSPARMCD.EXPENDTC, for the filter, I am currently using:

• domain: TS
  filter:
  TSPARMCD: EXPENDTC
  id: $ts_expendtc_value
  name: TSVAL
  operator: distinct
  and in the check:
• name: EXENDTC
  operator: date_greater_than_or_equal_to
  value: $ts_expendtc_value
  #value: '2001-01-01'
  (remark the last line commented out)
  Even when in my test file, the value for TSPARMCD=EXPENDTC TSVAL=2001-01-02
  no issues are reported, although all EXENDTC are after 2001-01-02.
  When I comment out the line "value: $ts_expendtc_value"
  and un-comment the line "value: '2001-01-01"
  issues are generated.
  Test file is attached.

I have the suspicion that the reason is the "distinct" operator, as that returns an array instead of a single value, so the date comparision doesn't work (I suppose it requires two single strings).
Another possibility could be that there is something wrong with my test file.

Any help highly appreciated!

P.S. Similar rule FB0803 seems to have started by Els, but was not finished (I suppose). I also could not find any test data for it on SharePoint.

unit-test-coreid-FB0804_negative_1.xlsx

[eljanssens]

@JozefAerts I have a question related to SENDIG: is it possible that TS dataset contains more than one record where TSPARMCD = EXPSTDTC and/or more than one record where TSPARMCD = EXPENDTC?

[JozefAerts]

I have no idea, I will pass to Christy and Keith.

[JozefAerts]

Answer from Christy Kubin:
"There will only be one value for each of those parameters as they are the overall start and end dates of the study."

[eljanssens]

Ok thanks. I was wondering if we couldn't solve this by starting from TS, filter on TSPARMCD and then check TSVAL versus EXENDTC and EXSTDTC. Or work with a max and min EXENDTC and EXSTDTC. Maybe something to try out or further discuss in one of the upcoming office hours.

[eljanssens]

@JozefAerts please let me know if the proposed suggestions were helpfull and if we can close this issue or if we need to further discuss this.

[JozefAerts]

@eljanssens Yes, you can close, though I need to again need to look into the YAML for this rule and continue working on it.