Forum Discussion

Qrew Cadet

2 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

Qrew Cadet

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

Qrew Captain

2 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

Qrew Captain

2 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
------------------------------