I am trying to build a GI to list all Generic Inquiries in the system. The Site Map Title is not within the GIDesign table. I believe I need to tie the GIDesign table with the SiteMap table to get those details. Can’t seem to figure that out though… Has anyone been successful with this?
Generic Inquiry List/Report
Hi
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.