Skip to main content
June 7, 2021
Question

Search in child table fields from Records search box

  • June 7, 2021
  • 2 replies
  • 0 views

Hi All,

I created an entity backed record on the main table which works as expected. However, as part of requirement we require to do search on the data in the child table which has one-to-many relationship (for each entry in main table, there can be multiple entries in child table). I tried using expression-backed record. But I'm only able to display the entries of child table, but cannot search on those fields. Is there anyway we can do the search on child table from record default search?

Note: We are currently on 21.2 and explored the new feature of adding relationship for records. However,it does support only Many-to-One and one-to-one relationship which is of no use for our use case

    2 replies

    selvakumark
    Participating Frequently
    June 7, 2021

    Hi [mention:f7ad1e6b32764c8cbefd24ab9010924b:e9ed411860ed4f2ba0265705b8793d05],

    What is the source of your expression-backed record? One possible & performance-efficient solution is to use a stored procedure as the source and filter the data based on the requirement.

    stefanhelzle0001
    Brainy
    June 7, 2021

    Regarding the relationship types for records, documentation says that for Many-to-Many and One-to-Many we should use the old approach. This would typically be a view in DB.