Skip to main content
S
21-Topaz I
STEVEG21-Topaz I
21-Topaz I
January 19, 2018
Question

Query Builder Report - Display CAD files and Documents from one CN

  • January 19, 2018
  • 2 replies
  • 2004 views

Some of our CN's have both CAD files AND documents in the Resulting Objects table.  Up until now it was easier to just create separate reports and be done with it.  One report for the CAD files and one report for the documents. 

Recently, I have been trying to get a report that displays both CAD files and documents in one report but have been unsuccessful so far.

 

I have been playing around with several different variations using the AND and OR booleans but I just can't get it.

 

Does anyone know how this can be done.

    2 replies

    S
    21-Topaz I
    STEVEG21-Topaz IAuthor
    21-Topaz I
    January 19, 2018

    The problem comes in on the Select tab.  If if have entries there for just one TYPE then the report will show all those types.  Once I add an entry for a second type it displays nothing.  So I assume it must be done a different way.

    S
    21-Topaz I
    STEVEG21-Topaz IAuthor
    21-Topaz I
    January 23, 2018

    Don't tell me this cannot be done.

    B
    BrianToussaint19-Tanzanite
    19-Tanzanite
    January 23, 2018

    I don't know if this would help or not but you could try CS33057.  I just glanced over it and it seems a little confusing at first glance and I haven't dug into it.

    S
    21-Topaz I
    STEVEG21-Topaz IAuthor
    21-Topaz I
    January 24, 2018

    Some of it is beyond me but I thought using that type "Workable" was interesting.

     

    I'll have to review it some more to see if anything else sinks in.

     

    Thank you.

      Terms & ConditionsCookie settingsAccessibility statement