List of Contributions

Norbert Prumbs

Contact Details

My Content

1 to 12 of 12 total

RE: Automate EVOLVE - How to query Reference Data List by Query Element using GROUP BY

Posted By Norbert Prumbs 03-04-2026 08:32
Found In Egroup: Automate \ view thread
Sorry Verma, I have to disagree: The "<>" can be intentional part of a criterion in the reference data list. So please note, for example the packaging type criterion "<>SA" in the reference data list. This excludes the label data within this row for materials of packaging type "Sack" (bag). ...

RE: Automate EVOLVE - How to query Reference Data List by Query Element using GROUP BY

Posted By Norbert Prumbs 03-03-2026 02:48
Found In Egroup: Automate \ view thread
Thanks Divya, for your try. But before testing your suggestion: What do you hope to achieve with your suggestion to change the filter condition? Please note the contradiction between the two filter criteria: ... AND ([Criteria_Packaging_Type] LIKE '%[/my:myFields/my:HLP_Container_Type_PH]%' ... ...

RE: Automate EVOLVE - How to query Reference Data List by Query Element using GROUP BY

Posted By Norbert Prumbs 03-02-2026 02:26
Found In Library: Automate

RE: Automate EVOLVE - How to query Reference Data List by Query Element using GROUP BY

Posted By Norbert Prumbs 03-02-2026 02:26
Found In Egroup: Automate \ view thread
Hello Sigrid, no I haven't yet added Sort Fields in the data connection. As well no SORT BY in the query code. Please find attached a zip file with my test data (test solution, reference list to be queried and EXCEL file with data from reference list). Appreciate your feedback. ...

RE: Automate EVOLVE - How to query Reference Data List by Query Element using GROUP BY

Posted By Norbert Prumbs 02-27-2026 02:44
Found In Egroup: Automate \ view thread
Thanks Hammad, for your quick response. I would be happy to provide you my test solution and reference data list, but your "Upload file" function doesn't except .wzip or .zip files. Only .xlsx would be possible. Please show me a way to post the files. Regards ------------------------------ ...

Automate EVOLVE - How to query Reference Data List by Query Element using GROUP BY

Posted By Norbert Prumbs 02-26-2026 06:47
Found In Egroup: Automate \ view thread
Hi Community, I need to query a "Reference Data List" with multiple criteria and insert the result aggregated into unique records into a "Repeating Table" element of my form. To do this, I use a "Query Element" in my form with SQL code as a "Raw Query." The code contains the selection conditions and ...

RE: Studio Query - Wrong numerical value from SAP floating point field (dot vs. comma)

Posted By Norbert Prumbs 09-13-2024 02:56
Found In Egroup: Automate \ view thread
Thanks Sigrid, unfortunately I am in an EXCEL based query in Winshuttle-Studio. So your multiplication by 1 is not applicable there. Here the original value in SAP(-QuickView): And here the outcome in Studio-Query ("Run" tab, "Excel" data file type): Open the Sheet in EXCEL app (local ...

Studio Query - Wrong numerical value from SAP floating point field (dot vs. comma)

Posted By Norbert Prumbs 09-12-2024 04:58
Found In Egroup: Automate \ view thread
I am developing a query on SAP table AUSP. This table contains several fields of SAP data type FLTP (floating point). For example field ATFLV with the value "2,000000000000000000E+02" (comma is decimal separator!). So I expect the value "200". Unfortunately, the query in Winshuttle-Studio returns ...

RE: EVOLVE Form: How to customize button behavior by SVFormDoSetActionsAndSubmit()

Posted By Norbert Prumbs 08-12-2024 04:16
Found In Egroup: Automate \ view thread
Perfect. That's it! And meanwhile I also understand your aproach by rule conversion. I will do the same. Best regards ------------------------------ Norbert ------------------------------

RE: EVOLVE Form: How to customize button behavior by SVFormDoSetActionsAndSubmit()

Posted By Norbert Prumbs 08-12-2024 03:46
Found In Egroup: Automate \ view thread
Thanks Amini for your reply. Unfortunately it does not meet my question exactly. I am interested in possible values to the parameters of this function: SVFormDoSetActionsAndSubmit(2,'TODO_ButtonId'); //Approve SVFormDoSetActionsAndSubmit(?,'TODO_ButtonId'); //? as well: SVFormDoSetActionsA ...

EVOLVE Form - How to tranfer field value from a child process to all related childs on runtime

Posted By Norbert Prumbs 08-09-2024 06:13
Found In Egroup: Automate \ view thread
My EVOLVE solution is a parent/child scenario. After the child processes have been started via Launch-Plugin, the parent process is finished and the child processes run separately in parallel. Now I want to transfer certain field values during runtime from one child process to all other children of ...

EVOLVE Form: How to customize button behavior by SVFormDoSetActionsAndSubmit()

Posted By Norbert Prumbs 08-09-2024 05:44
Found In Egroup: Automate \ view thread
I must customize button behavior more specific by javascript (js) code. Beside other coding, also standard button behavior (save, save submit, exit, etc.) should be carried out by the js code. I know js function SVFormDoSetActionsAndSubmit(), but can't find any source about how to setup its parameter. ...