andre_mangatal
New Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Tail snap and documents
Hello Snaplogic Community We have a pipeline that has a JSON generator acting as a loop with some dates as input into the first pipeline execute and we need to have the loop entirely finished before calling the second pipeline execute but the tail snap with number of documents set to 1 presently calls the second pipeline execute even before the “loop” finishes executing. How can this be achieved??? Should the tail snap be set to the no of documents from the JSON generator? Thank you very much in advance.3.6KViews0likes2CommentsManaged Service Active Directory Accounts & Snaplogic
Good day Community Is there a way to integrate Managed Service Active Directory Accounts with Snaplogic SQL Server Select or JDBC Select. We don’t want to use the a regular Active Directory account. Would appreciate your assistance with this. Thank you1.4KViews0likes0CommentsRe: Help Using Group By!
Hi tstack Thank you for the reply. I need to get a solution for this. The date fields are strings and they are sorted descending before i did the group by via JDBC execute. A sample of the json just after the group by is shown below. I am grouping by “POL_ID” then “CVG_NUM” but I need to return ONLY the first record in each group i.e. with the latest date. How can I do this please?? [ {“groupBy”:{“CVG_NUM”:“01”,“POL_ID”:“DT90000051”},“group”:[{“CVG_NUM”:“01”,“POL_ID”:“DT90000051”,“CO_ID”:“01”,“FIA_EFF_DT”:“2010-04-30”}]},{“groupBy”:{“CVG_NUM”:“02”,“POL_ID”:“DT90000051”},“group”:[{“CVG_NUM”:“02”,“POL_ID”:“DT90000051”,“CO_ID”:“01”,“FIA_EFF_DT”:“2010-04-30”}]},{“groupBy”:{“CVG_NUM”:“01”,“POL_ID”:“DT90000051”}]}]1.3KViews0likes1Comment