Method Community

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?

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

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.

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

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.

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.

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.