• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD Plant 3D

    Reply
    Valued Contributor
    andy.davis
    Posts: 72
    Registered: ‎07-10-2009

    Re: Data Manager - Project Reports

    08-07-2012 08:52 AM in reply to: Arch_art

    Hi,

     

    If you could send me a copy of the processpower.dcf file from your project I'll have a look for you.  The exact query depends upon the database schema.

     

    If you don't want to make the file public, please PM me.

     

    Regards,

    Andy

    Please use plain text.
    Valued Contributor
    andy.davis
    Posts: 72
    Registered: ‎07-10-2009

    Re: Data Manager - Project Reports

    08-08-2012 02:47 AM in reply to: andy.davis

    Hi,

     

    Thanks for the PM.  Please find the modified report attached.  Just need to make sure that the field lists match on both sides of the UNION and with the SelectList.  

     

    Regards,

    Andy

    Please use plain text.
    Valued Contributor
    Arch_art
    Posts: 55
    Registered: ‎08-08-2011

    Re: Data Manager - Project Reports

    08-08-2012 04:14 PM in reply to: andy.davis

    HI, Andy,

     

    eh... Strange... It still doesn't work on the project. I don't understand. It only still shows information that is from <LeftQuerySpecification>. I did check the order SelectionList and the number of them. I even tried to leave on PnPID on the list, it still only shows the information on <LeftQuerySpecification>.

     

    Any thoughts?

     

    Peggy

    Please use plain text.
    Valued Contributor
    Arch_art
    Posts: 55
    Registered: ‎08-08-2011

    Re: Data Manager - Project Reports

    08-08-2012 05:59 PM in reply to: andy.davis

    Hi, Andy

     

    I get it to work now. It is the --xsi:type="PnPSetQuerySpecification"-- I didn't get it right. I used --xsi:type="PnPRelationshipQuerySpecification"--, Of course, it is not going to work...

     

    Thank you very much!!

     

    Peggy

    Please use plain text.