Method:Classic General Q&A

Re: Vendor Portal Tab

Shawn B — Thu, 20 Oct 2011 15:06:20 GMT

Ok Paul, apparently the issue was hard carriage returns in my SQL. I had used CASE WHEN THEN ELSE statements and wrote them in a text editor. Of Course it's easier to see when you indent, newline, etc. But when you copy them into the SQL Override, works fine in the portal, but not so much on the "inside". Removing those and one unnecessary </b> html tag (also not impacting portal) cleared it up. I'm good now.

Re: Vendor Portal Tab

Method_Paul — Thu, 20 Oct 2011 14:24:07 GMT

Same grid......but different data being returned, since the portals have an extra filter applied by default. Different data, a whole new way to break SQL!! You could have mathmatic overflows for example.

Re: Vendor Portal Tab

Shawn B — Thu, 20 Oct 2011 14:13:39 GMT

I will play around with it today, but I would think that if that were the case it wouldn't show up in the portal either since they are both looking at the same grid.

Re: Vendor Portal Tab

Method_Michael — Thu, 20 Oct 2011 14:07:14 GMT

Shawn-

If there is an issue with the SQL Statements then it would cause the grid to not show up. For testing purposes try the screen without the SQL and see if you get the same results.

-Michael

Re: Vendor Portal Tab

Shawn B — Thu, 20 Oct 2011 13:52:41 GMT

Yep, grid itself doesn't show up.

As far as filters on Step 3 of 9 in the Grid Wizard:

Field:Vendor = [vendorname] (actual Type In the vendors name); and then some OpportunityStage filters. All roles can view. Nothing in the Advanced Screen settings. The only thing I can think of is that a few of the grid fields (Advanced Link) have some SQL statements. But, I would think if there was something wrong with those, it wouldn't show up on their portal either. But it is fine there.

Re: Vendor Portal Tab

Method_Michael — Thu, 20 Oct 2011 13:22:33 GMT

Shawn-

Do you mean the grid itself doesn't show or there is no data in the grid? It could be the filters you are applying to the grid. What filters do you currently have set?

-Michael

Vendor Portal Tab

Shawn B — Thu, 20 Oct 2011 12:46:20 GMT

I created a special tab for one of my vendors and set them up with a portal to see just that one tab. That tab contains a simple grid. When I log in to the portal I can see the grid beautifully. However, the tab is blank within my Method site. The grid won't load/show.

Thoughts?