You can filter a list based on the selected record of another list all using no code in Freedom UI. See this post: https://community.creatio.com/questions/filtering-records-freedom-ui-expanded-list

If you also want to have code that gets the change of the selected row in a list see here: https://community.creatio.com/questions/list-bind-selected-record-or-add-custom-handler-selectionchange

For removing the row toolbar menu with add,copy,delete, see here: https://customerfx.com/article/removing-the-row-toolbar-from-a-creatio-freedom-ui-list-component/

Ryan

Hello!

The feature you're looking to implement is not achievable using a no-code approach but can be done with low-code customization. To create a custom ordering solution, you'll need to modify the page's code and configure the sorting settings as follows:
Locate the configuration:
1. Open the page's code and find the section with viewModelConfigDiff.
2. Add the sorting configuration:
3. Include the sorting attribute:
In the viewModelConfig  block, add this line to include the new config: "ItemsSorting": {},
Identify your Gallery component in the modelConfig block and add the following code
"sortingConfig": {
 "attributeName": "ItemsSorting",
 "default": [
   {
     "columnName": "Name",
     "direction": "asc" // Use "desc" for Z-A sorting
   }
 ]
}
4. Save your changes:
Once the code is updated, save the changes. The data should now be displayed in the correct order.

If this is a classic detail, this marketplace add-on will allow you to group the rows of any list: https://marketplace.creatio.com/app/tree-view-creatio

Ryan

Hi Ryan,

I intend to do something like that.

SELECT username
FROM logs
GROUP BY username

I’m not sure if it’s possible to list the grouped data.

Thanks

 

Cristiano Carvalho,

Yes, that is what that marketplace add-on allows you to do - the column you select (in your case the username) will group the rows by that column, so rows with that username will be grouped below it  and can be expanded. 

You can see an example of this out of the box on the classic project page, the structure tab (the project tasks) group this way as well (it is grouped by the ParentId column). You can analyze the "ProjectStructureDetailV2" schema to see how it is implemented. 

Ryan

Ryan Farley,

I am afraid, this addon allows to display parent-child tree, but not group by category. 

Hello, yes, that's true. 

Do you know of another option to group by name?

Thanks

 

Dear Cristiano,

Unfortunately, the option to group the list is not currently available.

As a workaround, you can add two separate lists to the page. In the first list, include users, and in the second, logs. Then, apply a filter to the logs based on the selection in the users' list.

This setup allows you to select one or more users in the first list, and the second list will automatically display logs related to the selected users.

You can also set up a pivot table in Classic UI dashboards, which allows grouping by a certain column, but pivot tables also have some restrictions. You can read more about it in this article.

Additionally, I created an idea for our R&D team.

Have a great day!

Cristiano Carvalho,

If you want to create read-only detail, you can create VIEW with ParentId field. Then you can use this add-on.

But editable detail is much more difficult

Another option is to create 2 details - Contacts and Logs. So, Logs detail is filtered by selected Contact

Kind regards,

Vladimir

Hello Ahmad,

There is no such official documentation. Each business task needs to be reviewed separately to find the perfect solution. 

As I understood from the question described, you may use dataSources to cover your task. Please check the article to find out more.

Additionally, you may read here about the Creatio front-end architecture. 

You can try to create several cases (if you can split all your 12 stages of the process into several phases). 

Vladimir Sokolov,

We have tried to create several cases, it requires populating a start condition. The thing is that when the start condition changes based on the column value, it triggers unwanted behavior. The user need to manually confirm stage changes when the column value (start condition) is modified. 

What we expect is for the behavior to be consistent with how Dynamic Case Management (DCM) works in the "Normal" setup, where the UI immediately displays the stage changes when the column value is changed, even before the "Save" button is clicked.

Hello!

About several cases: At this moment we have only manual replacement and our developer's researching the possibility to automatically switching cases in future releases.

For the main question about the size and visibility of different cases, you can use the "Group with another stage" functionality.

Hello,

Unfortunately, the desired functionality cannot be implemented with user's methods. However, as a workaround, you can do the following:

1) Here is an example of the functionality you need. It describes how to filter dropdown values - https://customerfx.com/article/dynamically-filtering-a-lookup-on-a-creatio-freedom-ui-page/
 
2) Another option: create a dropdown on the page where macro source is selected. Then create a filtering business rule that will filter values in the parameter based on the added dropdown value. 

We want to assure you that we have created a request for our development team to implement this functionality in future versions of our application. 

Hello,

We recommend using development (dev) sites to test any development, including business processes. This approach enables you to identify and resolve potential errors in the developed functionality without impacting the production site, ensuring its stability and uninterrupted operation.

Best regards,
Antonii.

Sure, but assuming you reach a point where there many inter-related things and/or you're asked to add an small thing which could lead you to try every possible route in order to see if anything breaks, it takes time. So I as wondering if there is some kind of approach people take.

I was thinking of the possibility of using other business processes to simulate the actions of an user for unit testing. I haven't thought of it deeply, but an inmediate doubt that came to my mind was how could I recopile for example the results of a related process that was triggered by the testing process, or in general the results of a group of tests in a custom section

I don't know if another person has already done it

Hello,

You need to disable ShowWidgetOnLoginPage system setting in order to hide widget on the login page.

Best regards,
Pavlo!

Thanks, Pavlo. It worked!

How are you trying to do it? there is an element in the $context.attributes that must have the quickfilterName + "_value" and could be an array

Hi Jesus, I have tried to do it through that way but I only get undefined

hmm, if you do a console log to every change request in the handler (without specifying the attributeName) you can make sure you're using the correct name. I guess you've already done it, but just to make sure. 

Aditionally, there you could see in what format it comes. From what I see, it should show an array of objects, each object with an id and a displayValue

Probably the undefined is because of trying to get directly the value from the array without specifying which indexes. Or maybe you're trying to get the value from an inexistent field in the lookup. It's hard to tell without seeing the actual code

Carlos Soto,

Jesus is absolutely right. You may cover your task by taking the element code + "_value" in handler.

Please check one more time where exactly you are trying to take the filter value.

Hi Anhelina,

this is the code in the javascript of my form page

As you can see, the quickfilter does not have a control with which you can control the change in the field or recover the value that is set to it.

	"operation": "insert",
				"name": "QuickFilter_Loans",
				"values": {
					"layoutConfig": {
						"column": 1,
						"row": 1,
						"colSpan": 1,
						"rowSpan": 1
					},
					"type": "crt.QuickFilter",
					"config": {
						"caption": "#ResourceString(QuickFilter_Loans_config_caption)#",
						"hint": "",
						"icon": "filter-column-icon",
						"iconPosition": "left-icon",
						"defaultValue": [],
						"entitySchemaName": "DfcLoans",
						"recordsFilter": null
					}

I tried to replace the ListPageV2Template, but it doesn't work

Does anyone have some suggestions?

Hi Stefano,

Thanks for letting us know about this issue! The responsible team plans to submit the update to the Creatio Marketplace at the beginning of February.