Formula to Add a Link to Transaction Saved Search Which Opens Another Transaction Saved Search When Clicked
Published on
October 31, 2023 at 6:21:59 AM PDT October 31, 2023 at 6:21:59 AM PDTst, October 31, 2023 at 6:21:59 AM PDT
Scenario
There are times when in a master saved search, a user would want to have a link which when clicked would redirect the user to another saved search (child).
For example, a Master Saved Search shows the Invoices for all customers and the user would want to add a link that will show the list of all transactions for the customer regardless of type (i.e. another Transaction Saved Search).
- Navigate toLists>Search>Saved Searches>New
- ClickTransaction
- Search Title:EnterTitle
Example:Master Invoice Search - ClickCriteriatab
- ClickStandardsubtab
- Filter:
- SelectType
- Type:Selectany of
- SelectInvoice
- ClickSet
- SelectMain Line
- Main Line:SelectYes
- ClickSet
- ClickResultstab
- ClickColumnssubtab
- Field:
Note:For every required field use the drop-down menu to select it and once adjusted click Add if needed. - ClickSave
- Repeat the steps 1-10 and create another Transaction Saved Search
Example:Transaction Child Search - For step 6, only includeMain Linefilter
- ClickSave
Solution
To add a link redirecting a user from a Master Saved Search to a Child Search, customize the Master Search and addFormula (HTML)field.
- ClickEditby Master Saved Search
- ClickResultstab
- ClickColumnssubtab
- Field:
- SelectFormula (HTML)
- Formula:Enter'<a href="/app/common/search/searchresults.nl?searchid=XXX&Transaction&CU_Entity_INTERNALID=' || {customer.internalid} || '"<span style="color:blue">Transactions</a>'
Note:Replace the XXX by the Internal ID of the Transaction Child Search. This ID can be found in the URL as searchid=XXX. - Custom Label:EnterTransactions
- ClickAdd
- ClickSave & Run
- The columnTransactionswill contain a link that redirects a user to the Transaction Child Search.