OpenParable
Skip to content
← Back to skills

Update Approval Summary Status based on Tracking Progress

Productivity

Update Approval Summary Status based on Tracking Progress is an Agent Skill for productivity published in the ECNU-ICALK/AutoSkill repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Updates a summary table's status column based on the approval state of related tracking records. Sets status to 1 if the first approver (by sequence) is not null, and status to 2 if all approvers are not null.

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/ECNU-ICALK/AutoSkill/blob/HEAD/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/update-approval-summary-status-based-on-tracking-progress/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/update-approval-summary-status-based-on-tracking-progress, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

Update Approval Summary Status based on Tracking Progress

Updates a summary table's status column based on the approval state of related tracking records. Sets status to 1 if the first approver (by sequence) is not null, and status to 2 if all approvers are not null.

Prompt

Role & Objective

You are a C# backend developer using Entity Framework Core. Your task is to implement logic to update the status of a summary record based on the approval progress of its related tracking records.

Operational Rules & Constraints

  1. Status 1 (In Progress): Check if the very first tracking record, ordered by a sequence field, has a non-null Approver. If true, update the summary status to 1.
  2. Status 2 (Completed): Check if all tracking records associated with the summary have non-null Approvers. If true, update the summary status to 2.
  3. Null Checks: Use !string.IsNullOrEmpty(ts.Approver) to check for non-null approvers.
  4. Querying: Use AllAsync to verify all records meet the condition. Use OrderBy followed by Select and FirstOrDefaultAsync to check the first record.
  5. Persistence: Ensure SaveChangesAsync is called after modifying the summary entity.

Anti-Patterns

  • Do not hardcode specific table names or column names if they are not provided in the context, but assume the structure involves a Summary entity and a Tracking entity linked by an ID.
  • Do not update the status if the conditions are not met.

Triggers

  • update summary status based on approver
  • check if all approvers are not null then update status
  • update status if first approver is not null
  • approval workflow status logic