- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Rohan,
This is what Milan's said by adapt your script to read temp query instead of nms delivery.
- If you have a initial query on deliveries schema that pulled the list of deliveries you need
<queryDef operation="select" schema={vars.targetSchema}>
<select>
<node expr="@label"/>
<node expr="@internalName"/>
<node expr="@id"/>
</select>
</queryDef>
- If you want to keep using nms:delivery add a where condition. below I'm selected deliveries created in August 2020
<queryDef schema="nms:delivery" operation="select">
<select>
<node expr="@label"/>
<node expr="@internalName"/>
<node expr="@id"/>
</select>
<where>
<condition boolOperator="AND" expr="@created >= #2020-08-01 00:00:00.000Z#"/>
<condition boolOperator="AND" expr="@created <= #2020-08-26 23:59:00.000Z#"/>
<condition boolOperator="AND" expr="@state = 95"/>
</where>
</queryDef> );
Thanks,
David
Views
Replies
0 Likes
Total Likes