Method:Classic General Q&A

Re: Need help with SQL Override syntax.

Method_Adam — Thu, 25 Jul 2013 21:39:58 GMT

Mark - Thanks for the input. :)

viret56,

Just as Mark said, this would be a tall order, and unfortunately beyond the scope of help we could provide over the forums. His suggestion of dynamically filtering a grid of estimates I think is the best suggestion. This will allow you to see some details about the estimates before viewing them in the Estimate screen.

I'd just include a select link that will show the hidden section containing the estimate grid and save the active recordID from the select link into a shared result. The just create a filter view on the estimate grid for the shared result.

Let me know if you have any questions.

Adam

Re: Need help with SQL Override syntax.

LaCrews — Wed, 24 Jul 2013 21:56:49 GMT

This is tall order for a SQL override. I would probably take a different tack. You might try using some sort of show/hide section that contains a grid of dynamically filtered estimates. You could then select the appropriate estimate.

Need help with SQL Override syntax.

viret56 — Wed, 24 Jul 2013 21:28:50 GMT

I have a grid based on the Opportunity Table. I want to add a column to the grid with a comma delimited list of Estimate numbers related to the Opportunity. Is it possible to write an SQL Override that accomplishes this? Ideally I would like each estimate number in the list to be a link to the associated estimate.

I have tried several techniques I found in variuos forum posts, but none has worked for me yet. I appreciate any pointers I can get.

Thanks