Hi Andrew,
I just checked, the script data is not available directly in database, Script files are encoded in base64 and then saved in database.
So creating a report which can fetch you all the columns is not an option.
Regards
------------------------------
Hammad Naeem
Precisely Software Inc.
------------------------------
Original Message:
Sent: 03-14-2024 07:01
From: Andrew Lewis
Subject: List of solutions and fields
Hi Hammad
We are using Studio Manager 20.2.8 (64 bit)
Thanks
------------------------------
Andrew Lewis
Global Master Data Analyst
QuidelOrtho
Wales
United Kingdom
www.QuidelOrtho.com
------------------------------
Original Message:
Sent: 03-14-2024 06:40
From: Hammad Naeem
Subject: List of solutions and fields
Hi Andrew,
Can also clear if you are using Foundation with Sharepoint or Automate Evolve?
Regards
------------------------------
Hammad Naeem
Precisely Software Inc.
Original Message:
Sent: 03-14-2024 06:28
From: Andrew Lewis
Subject: List of solutions and fields
Hi Hammad
Thanks for responding so quickly.
The report that I'm looking for is to list all of the current winshuttle transaction scripts along with the fields that are contained within each one. This is so that a user can enter the SAP field name and the report will display all of the transactions scripts that contain this field.
Hope this makes more sense but please reach out to me if you have any other questions. ?
Andy
------------------------------
Andrew Lewis
Global Master Data Analyst
QuidelOrtho
Wales
United Kingdom
www.QuidelOrtho.com
Original Message:
Sent: 03-14-2024 05:25
From: Hammad Naeem
Subject: List of solutions and fields
Hi Andrew,
Can you please clear what type of solutions you are referring to, is it Form Solutions, Excel Solutions or both,
Pulling such a report in Automate Evolve can be easy for Form Solutions as we just need to query the right table and check if the field is available in the FORMXML or not, for Transaction and Query Type solution this can be tricky as the data is stored in bytes rather than plane text.
I believe same should be feasible for Foundation as well.
Let me know more details on the Solution and I will give it a try.
Regards
------------------------------
Hammad Naeem
Precisely Software Inc.