Is there a system table that can be queried to find out which section and/or detail run process menu(s) a process is found in? Or any other way of doing this?
*Edit* A query to find out what section(s) an object is a detail in would be quite helpful.
Also, there is no differentiation in Creatio between section and detail objects. So basically, an object is the same for a detail and a section. You could use the following script:
SELECT DISTINCT ss.Name ,
CASE
WHEN EXISTS (SELECT 1 FROM SysModule WHERE SysModuleEntityId IN (SELECT Id FROM SysModuleEntity WHERE SysEntitySchemaUId = ss.Uid)) THEN 'Section'
WHEN EXISTS (SELECT 1 FROM SysDetail WHERE EntitySchemaUId = ss.Uid) THEN 'Detail'else''
END AS "Section/Detail"
FROM SysSchema ss
WHERE EXISTS SELECT 1 FROM SysModule WHERE SysModuleEntityId IN (SELECT Id FROM SysModuleEntity WHERE SysEntitySchemaUId = ss.Uid)
OR EXISTS
(SELECT 1 FROM SysDetail WHERE EntitySchemaUId = ss.Uid)
AND
ss.ManagerName='EntitySchemaManager'
*Edit* The below queries return both active and inactive processes., at a glance I am not able see how to select active only.
The query we arrived at to list the processes in the run process menu of sections:
SELECT SM.Caption AS [Section Name], SS.Caption AS [Process Name]
FROM ProcessInModules AS PIM
JOIN SysModule AS SM ON PIM.SysModuleId= SM.Id
JOIN SysSchema AS SS ON PIM.SysSchemaUId= SS.UId;
And the query to list the processes in the run process menu of individual details:
SELECT SD.Caption AS [Detail Name], SS.Caption AS [Process Name]
FROM ProcessInDetails AS PID
JOIN SysDetail AS SD ON PID.SysDetailId= SD.Id
JOIN SysSchema AS SS ON PID.SysSchemaUId= SS.UId;
I would like to be able to say what sections a detail appears in, but would imagine this information to be buried deep in Creatio system tables.
If anyone can check the above queries I would be grateful!
The queries you have written are correct. However, it's hard to check which details belong to which sections by a DB query as details are connected to a page in the page's schema. So you need to decode the schema's content and filter in it. Such a query is hard to build and it will take a long time for it to get executed.
Such logic was implemented only for portal users since the Self-service Portal was designed only for them and they could be from different companies (from the accounts section).
Such logic was implemented only for portal users since the Self-service Portal was designed only for them and they could be from different companies (from the accounts section).
were trying to show the contact who was responsible for setting an opportunity at a certain stage of the DCM .
The base object of the dashboard is on Opportunity. So when we try to add the person who modified the opp, we try to look in available data on the object "Stage in opportunity". We are able to show when the stage started. But we cannot figure out how to select who did the change (Modified by). Any advice ?
In this particular case object "Opportunity" may have a lot of connected records with "Stage in opportunity" object. In other words, the system doesn't know which value exactly should be displayed for the record and you can only display the number of it (Quantity column from your screenshot).
In order to achieve your business task there is a need to create a chart based on the "Stage in opportunity" object.
In PortalEmailMessageHistoryItemPageV2 file, these items were inserted. However it is hidden in the GUI. Any idea to which file it was removed so that we can insert it back.
The basic functionality does not support sending the emails from the portal case page, and therefore it is not possible to add the email activity to the detail from the portal.
We will register your idea to R&D team to add this functionality in the future.
We are having an issue with the BPMonline WordPress plugin not pulling information from our forms - instead sending them to an error page. We have isolated that the plugin is the issue as the forms work okay when the plugin is removed.
Have upgrades been made to the plugin's compatibility with the Php 8.0 and/or WordPress Platform 5.9?
We started having this issue on 3/9. We updated the platforms on 3/23. We have just gone in and tested - by turning the BPMonline plugin back on and we are still receiving a Wordpress "critical error" notice.
Then it is because of how newer php versions treats constant string values. If you feel adventurous enough to edit the plugin (and if that is the error you're getting), you can fix it by doing the following (there are 3 lines to change, basically just enclosing some values in quotes). NOTE: only do this if you're comfortable editing the PHP code, doing something wrong can break your whole website. So proceed at your own risk. If this isn't something you're comfortable with, contact a PHP developer for help.
In Wordpress to go Plugins -> Plugin Editor.
Select "Forms-3rd-Party-Integration-Bpmonline-1.0.6" and make sure you have the "forms-3rdparty-integration.php" file selected.
Go to line 611 and change this:
if(isset($_COOKIE[bpmRef])) {
to this (notice quotes around bpmRef):
if(isset($_COOKIE["bpmRef"])) {
Go to line 617 and change this:
if(isset($_COOKIE[bpmHref])) {
To this (notice quotes around bpmHref):
if(isset($_COOKIE["bpmHref"])) {
Go to line 623 and change this:
if(isset($_COOKIE[bpmTrackingId])) {
To this (notice quotes around bpmTrackingId):
if(isset($_COOKIE["bpmTrackingId"])) {
Save the file by clicking "Update file"
I don't know if you'll encounter other errors with the plugin code, but that will fix the error I mentioned above.
2) There are _getTabsVisibility, getExtraActionDashboadTabVisible and getEsnChannelVisible methods in the base SectionActionsDashboard module and they all contain the following check:
There is the initTabs method in the BaseActionsDashboard that removes this tab from the portal in this part of code:
if(!this.get("UseDashboard")){
var dashboardTabName =this.get("DashboardTabName");this.removeTab(dashboardTabName);}
Even if adding this tab in the diff it won't be displayed in the page because of this method. This method logic should be overridden and also you should check if the localizable string for the caption is added to the PortalCaseSectionActionsDashboard.
Thank you Oscar, dashboard tab is now showing in Portal Case.
Do you have idea why default subject is not setting on Portal Case. I tried to debug the source code and breakpoint is not going to "setListenerEmailData" method in "EmailMessagePublisherPage.js". Any idea please?
I am trying to understand the logic of why we can not add an organization (Account) to an organizational structure of the system. I have seen some of the documentation and tables that link to VwSysAdminUnit and VwSspAdminUnit but I can not find out why they are not displayed in the user interface the same as in the portal organizational structure.
Such logic was implemented only for portal users since the Self-service Portal was designed only for them and they could be from different companies (accounts).
First of all please keep in mind that access rights might be inherited and since your custom section is based on Contact lookup - permissions are checked for Contacts as well as for your Custom section.
We also recommend looking at the SysSSPEntitySchemaAccessList table. There should be a record of the schema with which you have a problem. For portal users, by default, all schemas are considered to be administered and inaccessible. In order that portal users can use them, this schema must be in the lookup (the list of objects available to portal users). In other words - it must be in the SysSSPEntitySchemaAccessList table. After adding this schema to this table, the problem should be solved.
Should the above trouble-shooting not resolve your issue - please send us an email with detailed explanations of your problem to support@creatio.com so we may inspect and analyze your specific case (as it is too few details available by now and further evaluation will be required for precise solution)
Thank you for your question. Could you please elaborate more on your business task? Would you like to receive a notification each time a record is modified? Kindly provide us with more details.
I am trying to create a lookup filter in client side based on the values of a detail. The case is as follows: I want to display within the application only the contacts which are in the detail UsrApplicationAssignedTo where the application id must be equal to the id of the current application.
After adding the following code to my page I get 0 records.
attributes:{"UsrAssignedTo":{// Attribute data type."dataValueType": Terrasoft.DataValueType.LOOKUP,
// The configuration object of the LOOKUP type."lookupListConfig":{// Array of filters used for the query that forms the lookup field data."filters":[
function(){
var filterGroup = Ext.create("Terrasoft.FilterGroup");
filterGroup.add("Contact",
Terrasoft.createColumnIsNotNullFilter("[UsrApplicationAssignedTo:UsrContact].UsrContact.Id"));
debugger;
filterGroup.add("AppFilters",
Terrasoft.createColumnFilterWithParameter(
Terrasoft.ComparisonType.EQUAL,
"[UsrApplicationAssignedTo:UsrApplication].Id",
this.get("Id")));return filterGroup;}]}}}
Similar filter example was already provided here with the only difference in the section name (there it was the Projects section, here it's Applications section).
Similar filter example was already provided here with the only difference in the section name (there it was the Projects section, here it's Applications section).
