Время создания
Filters
Freedom
Landing page
landingpage
business rule
Filters
look up filters
Sales_Creatio
8.0

Hi Team,

Could anyone suggest how we can implement a dependent lookup filter on a landing page in freedom UI?

For example, the Sub Product lookup should display only the relevant values based on the Product selected by the user.

If anyone has implemented something similar or can share any documentation, reference, or guidance, it would be greatly appreciated.

Thanks in advance!


 

Like 0

Like

0 comments
Show all comments
Studio_Creatio

Hello

I'm working on a Creatio application with two sections:

  1. Application (Service Request)
  2. License

Each License belongs to a specific Application.

I have already created a Request Number lookup field in the License section, so each License is linked to its corresponding Application, and this relationship works correctly.

Now I want to achieve the reverse: on the Application page, I want to display the related License automatically.

To do this, I added a License Number lookup field to the Application section (lookup to the License object). However, I cannot get it to populate automatically with the related License.

I tried several approaches, including using a Business Process with Read Data and Modify Data, but I haven't been able to make it work.

What is the recommended or best-practice approach in Creatio for implementing a one-to-one relationship like this? Should I use:

  • A Business Process?
  • A Business Rule?
  • A Detail instead of a lookup?
  • Or is there another recommended configuration?

Any guidance or examples would be greatly appreciated. Thank you!

Like 0

Like

1 comments

Hi,

For a true one-to-one relationship, I would not recommend maintaining two independent lookup fields unless you really need to store the reverse reference for reporting/integration purposes.

The cleaner approach is to keep a single source of truth:

License.Request Number -> Application

Then, on the Application page, display the related License through the page configuration rather than trying to populate Application.License Number automatically.

If you are using Freedom UI, the best fit is usually Multiple data sources. Add License as an additional/secondary data source on the Application page and configure the relation criteria using the existing lookup:

License.Request Number = current Application

After that, you can place the needed License fields directly on the Application page. This is the closest match for a real 1:1 UI, because the user sees License data as part of the Application page without duplicating the relationship.

Documentation:
https://academy.creatio.com/docs/8.x/no-code-customization/customization-tools/ui-and-business-logic-customization/multiple-data-sources

A Business Rule is not the right tool for this. Business rules are mainly for UI behavior, visibility, required fields, validation, etc. They do not automatically query a related child record and populate a reverse lookup.

A Business Process can do it, but only if you intentionally want to denormalize the data. In that case, you would need to handle all scenarios: License creation, changing the Application on the License, deleting/unlinking the License, and preventing more than one License per Application. Otherwise the two lookup fields can become inconsistent.

Show all comments

I completely love the "Live Data Update" option for objects, one of my fav features to be added in Creatio. However, there are many cases where I want to be able to override that behavior and not have the live data update message sent to the UI. For example, if I am doing hundreds of adds/updates in a process, I likely don't want all those updates to go to the UI since that sort of thing can cause a lot of "flickering" and lag for the user that triggered the process as each message is received and the UI loads the data. Another case is where I am loading in a large amount of data from an external source via OData, the user context that the OData connection is using will receive the messages for all the adds/updates. The same for Excel imports, these should have Live Data Update off by default. There are many cases where the Live Data Update feature could cause a negative impact on the system and is unnecessary since it's not something that is for the user.

Please provide a way that the Live Data Update feature can be bypassed/disabled for single (or batch of) transactions for scenarios such as:

  1. OData connections
  2. Entity object adds/updates
  3. Processes - Ideally, as an option for a single Add Data or Modify Data element, or at least as an option for the entire process
  4. Excel imports (should be bypassed/disabled by default for these)

Thank you.

Ryan

1 comments

Highly agree, this would definitely be a very useful feature for bigger data updates!

Show all comments
Discussion
datetime
Filtering
configuration
Charts
dynamic folder

It would be very useful in having good, consistent reporting to extend the current date macros available for doing so. Currently, if I want to filter to only include the rolling year's values, I have to put in a filter like Date >= Previous days <365> (and another for Date <= Today, if dates can be in the future) but this is quite clunky and not always the most clear (from memory, Previous Days does not include today's date, hence the greater than or equal to).

 

Even worse is that there is no real way (without doing something like creating a custom date object & maintaining the lookups to it for all objects with a date) to put a filter on to say "show me the last x complete months", with the partial workaround being similar to the above one, but this does not fulfil the "complete months" aspect of the filter.

I would propose the following would be very useful additions to the filtering setup used in folder config, BP read data steps, chart/metric config, list filtering config & other areas that filtering can be set up throughout Creatio:

High priority:

  • Previous x for each of the dropdown's sections, so week, month, quarter, except for "Every year"
  • Following x for each of the dropdown's sections as above

Nice to have:

  • A checkbox/similar on Previous/Following macros to select whether the current day/week/month etc should be included, to both remove the slight ambiguity and give users more control without needing 2 date filters
2 comments

Hello Harvey! 

Thank you for your suggestion.

We have submitted this idea to our Development Team for evaluation and consideration for implementation in one of the upcoming releases. 

Have a nice day!

This is very much needed and would be fantastic additions!

Ryan

Show all comments
recordpermission
permissions
8.3.4
Sales_Creatio_enterprise_edition
8.0

Does anyone know how this feature released in 8.3.4 can be used?

https://academy.creatio.com/docs/8.x/resources/release-notes/8-3-4-twin-release-notes#title-advanced-customization

 

I do not currently see any additional options in the object permissions section when compared against 8.3.3 for putting in place custom record-level access rights, and can't see any new documentation around it in the academy.

Like 4

Like

1 comments

Hello.

The official article describing the new functionality is currently being prepared and will be available shortly.

Once the article is published, it will contain the relevant details about the functionality, its configuration, and usage.

Best regards,
Antonii.

Show all comments