ATS-PFM-QRY-020 Evaluate dated conditions for named records: Capability Test Specification
Markdown Design / Platform / Questions, record exploration and data delivery / Dataset access and querying / Capability Test Specification Coverage Rule covered Transition not-applicable Validation gap: FND-PFM-QRY-070 Permission covered Edge covered Failure gap: FND-PFM-QRY-070 Boundary covered Concurrency gap: FND-PFM-QRY-070 Invariant covered Interaction covered Test Scenarios 7 scenarios proving CAP-PFM-QRY-020
02 Invalid evaluation lists are refused boundary api negative proposed
Proves BR-CAP-PFM-QRY-020-02Preconditions A system context with access to a registered dataset. Steps Try empty and oversized subject and predicate lists, duplicate names and incompatible options. Expected Each invalid request is refused before its statement runs. Data Controlled contacts, affiliations and system execution contexts. Source services-platform:modules/queries/services/execute/compile-predicates.ts :validPredicates 04 Collection calculations handle empty populations edge api proposed
Proves BR-CAP-PFM-QRY-020-04Preconditions Contacts have zero, one and several qualifying child records. Steps Evaluate count, sum, minimum and maximum over their collections. Expected Calculated values match qualifying children; empty collections return the stated zero or absent value. Data Controlled contacts, affiliations and system execution contexts. Source services-platform:modules/queries/services/execute/compile-query.ts :subjectPredicateCompiler 05 Evaluation follows the requested calendar day boundary api negative test
Proves BR-CAP-PFM-QRY-020-05Preconditions A contact reaches an age threshold today and has dated affiliations. Steps Evaluate today and the previous day; use an invalid day and a date token on a non-date field. Expected The threshold changes with the chosen day; both invalid uses are refused. Data Controlled contacts, affiliations and system execution contexts. Bound to Source services-platform:modules/queries/tests/integration/services/execute/compile-predicates.integration.spec.js #resolves the same shift from the as-of day, so a contact eighteen today was not the day before 06 Evaluation confines reads and avoids sensitive logs invariant api negative proposed
Proves BR-CAP-PFM-QRY-020-06Preconditions Two workspaces have records with the same identities. Steps Evaluate in each workspace and inspect the role, execution settings and emitted logs. Expected Results contain only local records; database reads are read-only and logs contain no subject identities, values or statement text. Data Controlled contacts, affiliations and system execution contexts. Source services-platform:modules/queries/services/execute/compile-predicates.ts :evaluateSubjectPredicates 07 Dated conditions agree with a same-day question interaction api proposed
Proves BR-CAP-PFM-QRY-002-10BR-CAP-PFM-QRY-020-05Preconditions Two contacts straddle an age threshold on a chosen local calendar day. Steps Evaluate the dated predicate as a system caller and execute an equivalent contact question on that day. Expected The predicate’s true identities equal the contact question’s matching identities on each of two adjacent days. Data Use a workspace calendar and two birthdays at the threshold. Source services-platform:modules/queries/tests/integration/services/execute/run-query.integration.spec.js #reads a day as that day in the tenant's zone, not in UTC,services-platform:modules/queries/tests/integration/services/execute/compile-predicates.integration.spec.js#resolves the same shift from the as-of day, so a contact eighteen today was not the day before ← Previous Capability Test Specification ATS-PFM-QRY-019 · Preserve and inspect monthly data snapshots: Capability Test Specification