I have created a view as follows:
CREATE VIEW vMyEntityTest AS SELECT *, 'somestring' AS somestring FROM MYENTITY
When accessing this from the UI reporting menu I can pull the somestring field into a report. However, when the view is accessed by SData…
Hi Everyone,
I am trying to customize a view that can look up customer number from the entity company and match it with each person associated with that company. The fields that I would like in the view are customer number, company name, business…
I would like to create a view that limits the list of opportunities to only those that the current user is working on OR opportunities that are closed (won, lost, dead). I copied vListOpportunities and added the oppo_status criteria, however I have not…
Although I'm working with Sage CRM for 7 years now I still discover new things every day.
Today I've remembered that we can create a workflow rule based on a view instead of a table, and it lead me to some new thoughts and I need a few answers to see…
Hi all,
I have a problem : I've added a notification on Opportunity entity, but when the rule is executed it generates the following error :
Error SQL : Cannot create a row of size 8559 which is greater than the allowable maximum row size of 8060…
We're experiencing periodic slowdowns in our recently-upgraded Sage CRM 7.2 system, and see a lot of these kinds of errors:
You may need to recreate views manually. : SQL Error
Well, we should clean those out anyway. When I try to edit some of our…
I'm looking to create a report that takes opportunities that have a due date (oppo_proposaldue) today, tomorrow, and the day after and groups them by those three categories.
I'm getting close to what is required want with this SQL:
SELECT oppo_quoteid…
Dear All
I am looking for some help if possible as it would appear that our issue has both our support partner, and Sage stumped. We have the standard system view vListOpportunity in the DB, however, for some reason on a fairly regular basis, this…
Is it not possible to create a view (or execute a view) that is based on a third party connection?
I have the third party database and table connections created. But there isn't a way to create a view.
I want to create a view so I can put a gadget…
Hello,
I am noticing that performance around system views, predominantly the views surrounding communications, are performing badly in comparison to the rest of the system.
If we take vListCommunication as an example, it has the following syntax in…
Hi I am trying to create a view in X3 using the following code
SELECT TOP (100) PERCENT ga.CCE_4 AS BPCINV, a2.TEXTE_0 AS BPCNAM, SUM(ga.AMTLED_0 * ga.SNS_0) AS NETAMTNOT FROM FOLDERNAME.GACCENTRYD AS gd WITH (nolock) INNER JOIN FOLDERNAME.GACCOUNT…
Hello,
Does anyone know if it's not possible anymore to add views in Crystal Reports for update 9?
In Crystal after picking the folder, it doesn't show the option for views anymore.
Can anyone help on this?
Best regards,
Nuno Roque
Hi All,
First post, a little bit about myself: I'm an IT intern for a small manufacturing company in Northern Colorado, I've been given some projects that involve MAS 500, mainly report customization. There currently is no on-site IT staff, so I've…
Looking at any views in Explorer for our main company works fine. However, in our test company (which should be a recent copy of our main company), when you click on any view, the screen shows no details and when you close the window, you receive Providex…
