Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
5 months ago

Pipeline message-Skipped because set values are the same as in source object.

I have a quickbase we will call it Network that has a connected table to another quickbase that we will call Escalations.  On the connected table in the Network QB, i have two added fields that reps update in the Network QB.  I then want to send the data in those two fields back to the Escalations QB.  The fields in the Escalations QB have the same name.

I created a pipeline who's trigger is when one of those fields in the Network QB is updated.  My next step is search record query on the Escalations QB and it pulls back the record where the Escalation QB record id matches the Network Escalation record id.  Next step is the loop and the final step is an update record.  The record to be updated is the search record.  I pull in the fields to be updated and do the matching.  The pipeline ran with no errors but the record from the Escalation QB did not update.  On the activity I see on the update record step, it gives me this, "Skipped because set values are the same as in source object.".

What have I done wrong?

Thanks

  

  • You said,  

    You said, " Escalation QB record id matches the Network Escalation record id"

    Don't you need a reference field in the table that matches the other application?   If you are actually comparing the RID of one table and the RID of another table,  they will almost never match.

     

     

    • CarolMcconnell's avatar
      CarolMcconnell
      Qrew Captain

      When I did the connected table from the Escalation QB to the Network QB I brought in the id of that record.  So when the record is updated in the Network QB, I do the match on that record id.  It's called record id in the Escalation QB and DNT Record ID in the Network QB. So, they should always match.  Matching it not the issue, because it retrieves the correct record but it's not upating it.

    • CarolMcconnell's avatar
      CarolMcconnell
      Qrew Captain

      Here is the YAML.  I changed a few things for privacy.

      # Update DNT Escalation QuickBase
      #

      # Account slugs:
      #  - quickbase[123generic]: Realm Default Account <None>
      ---
      - META:
          name: Update DNT Escalation QuickBase
          enabled: true
      - TRIGGER quickbase[123generic] record on_update -> a:
          FILTERS:
          - AND:
            - 'liaison_closed_date set '
          inputs-meta:
            export_fields: '"Liaison Closed Date, Liaison Comments, DNT Record ID" <11,
              12, 6>'
            table: '"Dental Network Operations: DNT Escalations" <123generic>'
            trigger_fields: '"Liaison Closed Date" <11>'
      - QUERY quickbase[123generic] record search -> b:
          FILTERS:
          - AND:
            - id equals {{a.dnt_record_id}}
          inputs-meta:
            export_fields: '"Liaison Comments, Liaison Date Closed" <167, 168>'
            table: '"DNT Escalation: DNT Escalation" <123generic>'
      - b<>LOOP:
        - DO:
          - b<>ACTION quickbase record update -> c:
              inputs:
                liaison_comments: '{{b.liaison_comments}}'
                liaison_date_closed: '{{b.liaison_date_closed}}'
      ...

    • CarolMcconnell's avatar
      CarolMcconnell
      Qrew Captain

      Nevermind, I found the problem.  On the update record action, I had it pulling the date from the searched record and not the updated record.