Automate

 View Only

  • 1.  Query or Report to Pull all Fields from a Solution

    Posted 5 days ago

    Hello,

    I am looking for a way to retrieve a list of all the fields in a form solution in Automate Evolve. There is another community article which references achieving this using a query but does not go into detail: List of solutions and fields | Automate. I'd like to pull all form fields at a minimum but it would also help to see data that is associated with the field like field type, all rules that are attached to each field, etc.

    Any assistance would be appreciated.

    Thanks!

    Knavis McGowan



    ------------------------------
    Knavis McGowan
    Lamb Weston, Inc.
    ------------------------------


  • 2.  RE: Query or Report to Pull all Fields from a Solution

    Employee
    Posted 5 days ago

    HI Knavis,

    There is no exposed view or report to find the fields in current solution.

    But you can design a form, make a dataconnection in the form to evolve database, and use below queries to pull the relevant data.

    select ScriptId from FR_FileInfo_ScriptFiles where FileName = 'Solution Name' and islatest =1
     
    select top(1) FormXml from FR_FileInfo_DataFiles where StoreId = 'Id returned from above query' and IsLatest = 1

    this will return the FormXMl of format :
    <?xml version="1.0" encoding="UTF-8"?><?mso-infoPathSolution name="urn:schemas-microsoft-com:office:infopath:Form1:-myXSD" href="manifest.xsf" solutionVersion="1.0.0.4" productVersion="14.0.0" PIVersion="1.0.0.0" ?><?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.2"?><my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:pc="http://schemas.microsoft.com/office/infopath/2007/PartnerControls" xmlns:d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields" xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003"><my:field_1></my:field_1><my:field_2></my:field_2><my:field_3></my:field_3><my:field_4></my:field_4></my:myFields>

    from this XML you can easily parse the form fields.
    Hope this helps.


    ------------------------------
    Hammad Naeem
    *Precisely Software Inc.
    ------------------------------

    Original Message