Jump to content
  • 0

Calculated field in Search Filter


Deadpool

Question

 I want to filter the records on the result of the calculated field that I created. I want to add a search field for that. Here is the formula that I am using "SELECT SUM (HFA_Publisher_Split) FROM L_License_Detail_List WHERE Track_ID = target.[@field:Track_ID]" . Can you please help me in this regard?

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Unfortunately, it is not possible to create a search filter in a Calculated field. As a workaround, you can create an actual field in your table and create an Application Task for your calculation instead.

You can refer to the following as an example.

1. Create an actual field that will populate the records from the child table based on the Calculation that you have.

image.thumb.png.aa4fcc76f6c2dd5b6dd42a47ea4fc3db.png

2. Create a Task that will SUM the HFA_Publisher_Split records from the child table and pass it to the parent table targeting the Track ID. 

image.thumb.png.1688759f937936c9aeab6689fbc9cac4.png

 

image.png.174a2b7acf7033e0365fcdcfb25cc649.png

Link to comment
Share on other sites

  • 0

As @Kenzo stated, DataPage search form cannot search values from calculated fields. Values of calculated fields are determined on DataPage load while the search form filters the records directly from the DataBase. From the Search form's perspective, the values of the calculated fields are yet to exist. 

You can use trigger and Task to repopulate values in your table so that the search form can search on them. Formula fields could work too! But only if the values you are computing does not include values outside the records.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...