Columns missing in my secondary data source - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Columns missing in my secondary data source

Last post 04-09-2010 06:41 AM by bmanes. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 04-08-2010 04:13 PM

    • bmanes
    • Not Ranked
    • Joined on 04-08-2010
    • Posts 2

    Columns missing in my secondary data source

    I am using Query Builder to Query a SharePoint list (Form library).  I have added 33 columns to my query.  When I build my data connection, I only see 21 of the 33 fields lsited in the secondary data source.  I can’t figure out why some are missing.  I don’t see a trend.  Sequence, field name, field type does not seem to matter.  Ideas? 

     

    My queries are included below.  As an example, 'ShaftLength_5' is NOT included in my datasource but 'ShaftLength_1', 'ShaftLength_2', 'ShaftLength_3' and 'ShaftLength_4' are included.

     

     

    <query maxrows='2'><columns><column name='Phone'/><column name='Address_x0020_2'/><column name='Flex_x0020_5'/><column name='ShaftLength_5'/><column name='FNS_x0020_Samples_x0020_1_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_2_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_3_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_4_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_5_x0020_Qty'/><column name='Comments_x0020_Graphics'/><column name='Loc_x0020_Finish'/><column name='Project_x0020_ID'/><column name='Customer_x0020_Name'/><column name='Customer_x0020_No'/><column name='Customer_x0020_Contact'/><column name='Address_x0020_1'/><column name='Customer_x0020_City'/><column name='Customer_x0020_State'/><column name='Customer_x0020_Zip'/><column name='Country'/><column name='Project_x0020_Description'/><column name='UNFModel_1'/><column name='UNFModel_2'/><column name='UNFModel_3'/><column name='UNFModel_4'/><column name='UNFModel_5'/><column name='Flex_x0020_1'/><column name='Flex_x0020_2'/><column name='Flex_x0020_3'/><column name='Flex_x0020_4'/><column name='ShaftLength_1'/><column name='ShaftLength_2'/><column name='ShaftLength_3'/><column name='ShaftLength_4'/><column name='Sales_x0020_Contact'/><column name='Comments_x0020_Program'/><column name='Date_x0020_Start'/><column name=''/></columns></query>

     


    concat("<query><columns><column name='Phone'/><column name='Address_x0020_2'/><column name='Flex_x0020_5'/><column name='ShaftLength_5'/><column name='FNS_x0020_Samples_x0020_1_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_2_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_3_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_4_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_5_x0020_Qty'/><column name='Comments_x0020_Graphics'/><column name='Loc_x0020_Finish'/><column name='Project_x0020_ID'/><column name='Customer_x0020_Name'/><column name='Customer_x0020_No'/><column name='Customer_x0020_Contact'/><column name='Address_x0020_1'/><column name='Customer_x0020_City'/><column name='Customer_x0020_State'/><column name='Customer_x0020_Zip'/><column name='Country'/><column name='Project_x0020_Description'/><column name='UNFModel_1'/><column name='UNFModel_2'/><column name='UNFModel_3'/><column name='UNFModel_4'/><column name='UNFModel_5'/><column name='Flex_x0020_1'/><column name='Flex_x0020_2'/><column name='Flex_x0020_3'/><column name='Flex_x0020_4'/><column name='ShaftLength_1'/><column name='ShaftLength_2'/><column name='ShaftLength_3'/><column name='ShaftLength_4'/><column name='Sales_x0020_Contact'/><column name='Comments_x0020_Program'/><column name='Date_x0020_Start'/><column name=''/></columns><filter><eq><column name='Project_x0020_ID'/><value>", xdXDocument:get-DOM()/my:myFields/my:Form_Details/my:Unique_ID ,"</value></eq></filter></query>")

      

    SQL Server 2005

    InfoPath 2007

    MOSS 2007

    Dual Server installation with SharePoint

    Client:  Windows XP

     

     

    Thanks

     

    Filed under: , ,
  • 04-09-2010 05:46 AM In reply to

    Re: Columns missing in my secondary data source

    Hi Barb,

    Is it possible that the missing fields are sometimes blank? The query that creates the data connection (the first one, without the concat) has a maxrows='2'. This means that (for performance issues while designing the form) it will only query two rows to get the sample schema. However, if there are blank fields in those two sample rows, then the full schema won't be derived correctly. For more info, please read this example. Since your data connection is not getting executed on load (i.e. you execute the concat query after the user has entered some information) then there's no harm in removing the maxrows parameter while designing your form (while creating the data connection). Can you try this?:

    <query><columns><column name='Phone'/><column name='Address_x0020_2'/><column name='Flex_x0020_5'/><column name='ShaftLength_5'/><column name='FNS_x0020_Samples_x0020_1_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_2_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_3_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_4_x0020_Qty'/><column name='FNS_x0020_Samples_x0020_5_x0020_Qty'/><column name='Comments_x0020_Graphics'/><column name='Loc_x0020_Finish'/><column name='Project_x0020_ID'/><column name='Customer_x0020_Name'/><column name='Customer_x0020_No'/><column name='Customer_x0020_Contact'/><column name='Address_x0020_1'/><column name='Customer_x0020_City'/><column name='Customer_x0020_State'/><column name='Customer_x0020_Zip'/><column name='Country'/><column name='Project_x0020_Description'/><column name='UNFModel_1'/><column name='UNFModel_2'/><column name='UNFModel_3'/><column name='UNFModel_4'/><column name='UNFModel_5'/><column name='Flex_x0020_1'/><column name='Flex_x0020_2'/><column name='Flex_x0020_3'/><column name='Flex_x0020_4'/><column name='ShaftLength_1'/><column name='ShaftLength_2'/><column name='ShaftLength_3'/><column name='ShaftLength_4'/><column name='Sales_x0020_Contact'/><column name='Comments_x0020_Program'/><column name='Date_x0020_Start'/><column name=''/></columns></query>

     

    Thanks.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 04-09-2010 06:41 AM In reply to

    • bmanes
    • Not Ranked
    • Joined on 04-08-2010
    • Posts 2

    Re: Columns missing in my secondary data source

    Perfect.  That fixed it.

    Thanks

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.