Generic Inquiry List/Report

Hi @Ehren_Dimitry,

I have created a simple GI to get all the Generic Inquiries with SiteMap details. Please find attached the XML format of GI and verify it. I hope this will help you.

Best Regards,
Naveen B

Hi Naveen!

Thanks for your help! So much appreciated…

This certainly gets me closer. However, it is only showing me generic inquiries that are visible to the UI. I changed the join to LEFT for GIDesign & SiteMap and the results didn’t change. 

My goal is to have a list of all GI’s so we can better manage them. There are several that are created for testing/learning, others that are project-based. I want to create filters based on the description field, if they are in the UI, etc….

Thanks again!

Ehren

Hi Ehren,

Sure. Yes, will get the exected results by doing this way!  Thanks for verifying and providing an update on this.


Thanks,
Naveen B
 

Hey @Ehren_Dimitry 

I’ve reviewed GI made by @naveenb74  (thanks! we use similar internally) and corrected it’s joins;

Pls find GI xml file in attachment