I have a case where I need to get the section's id that the detail belongs to in detail edit page. While var sectionName: this.get("DetailColumnName"); gives me the code of the section, it would be easier to process logic if I could get the section's Id in SysModule table.
You can initiate the ESQ query on the onEntityInitialized method execution on the edit page of your detail and call the SysSchema table using the detail column name so to get the UId of the section schema and then call the SysModule table to get the module id (the column in SysModule is SectionSchemaUId).
It's not recommended at all. Please create a section that will be not displayed anywhere and use its table to perform a data import from an external source.
We need to import lookup values in more than a language from an Excel file.
We have an Excel with two columns: Name (italian) and Name (english).
When we import from Excel the Name column goes into the "current language" lookup name but we want to import the names in two different languages (both active in Creatio) without duplicating them.
You need to import values into two different objects. Let's take [Lookup] for example.
When you import the values for the English culture, you can import directly into [ObjectName] (Lookup in our case) and can only have two columns: Id of the record and the actual Value.
When you import the values for Italian Culture you need to import into Sys[ObjectName]Lcz ( SysLookupLcz in our case) and you need 3 columns: Id of the record - mapped to RecordId, CultureId and the Actual Value.
Which exact API call do you perform? Also try publishing the object directly from configurations and try calling the API once again and check the result.
Were the new columns added in the section wizard (and not to the object directly)? In some older versions it wouldn't build the OData objects when done via the wizard and you had to open the object in the configuration and publish before it was available via odata (however, that's no longer the case in recent versions)
Have you tried opening the object and publish it to see if the properties show up?
If you have questions or encounter any issues while using the add-on, please write at a.technologies.foundation@gmail.com in order to get assistance on this matter.
Can anyone tell me what is the functionality of the Portal message button (as highlighted in the image) present in the Cases section on portal, and where can I find its configuration in the system?
There is no inbuild element that allows the process to show a popup, but you can create a logic that can open a popup for the user and then the input data can be used elsewhere.
The set of actions is simple:
1) Using the logic described by me in this community thread you can create a process that will send a WebSocket message to the user that triggered the process and pass all the parameters needed to the message.
2) When the message is received to the edit page you can create a handler that will open the popup with fields that can store values. There are community posts about creating a popup on the UI as well as Academy articles, for example here and here.
3) When the information is input and the OK button is pressed you can pass this information either to the UI fields, or create requests with UpdateQuery\InsertQuery classes (examples of the client-side logic using InsertQuery class and UpdateQuery class) to input information elsewhere. Or trigger another business process as described here.
So you need to study all of these and then create the logic on your side.