Forum Discussion

Hongkunliang's avatar
Hongkunliang
Qrew Cadet
3 years ago

Jinjia question

Hi, I am not familiar with Jinjia.  I am trying to generate several child records by using Pipeline. The 1st child will get a date "9/21/2023", 2nd one will get "9/22/2023", and so on.  However, it a...
Hongkunliang's avatar
Hongkunliang
Qrew Cadet
3 years ago

Just give a quick update.

By using namespace function as Prashant 's instruction, I am able to calculate each total within each cycle and assign the value to the child table.  Thanks again for Prashant's post.



------------------------------
Hongkun liang
------------------------------
PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
3 years ago

@Hongkun liang ,you've just committed a cardinal solution ,by saying a solution has been found but not posted it for others to stumble across this discussion :D 



------------------------------
Prashant Maheshwari
------------------------------

  • PrashantMaheshw's avatar
    PrashantMaheshw
    Qrew Captain
    3 years ago

    For the completist in me !

    {
  "to": "tablename",
  "data": [
    {% set ns = namespace(adate=(time.now|timezone('Asia/Calcutta'))) %}
    {% for num in range(7) %}
      {% set ns.adate = ns.adate + time.delta(days=1) %}
      {# Check if the date is Saturday (5) or Sunday (6) #}
      {% if ns.adate.weekday() == 5 %}
        {# If it's Saturday, add 2 days to make it Monday #}
        {% set ns.adate = ns.adate + time.delta(days=2) %}
      {% elif ns.adate.weekday() == 6 %}
        {# If it's Sunday, add 1 day to make it Monday #}
        {% set ns.adate = ns.adate + time.delta(days=1) %}
      {% endif %}
      {
        "7": {
          "value": "{{ ns.adate }}-{{ ns.adate.strftime('%A') }}"
        }
      }
      {% if not loop.last %},{% endif %}
    {% endfor %}
  ]
}


    ------------------------------
    Prashant Maheshwari
    ------------------------------