Sunday, December 2, 2018

Display The Search Result Of The Custom Line Field Added As A Footer Filter On A Saved Transaction Search That Exceeded The 10,000 limit

Create New Custom Line Field
1. Navigate to Customization > Lists, Records & Fields > Transaction Line Fields > New
2. Enter Label, ex. Event (Hidden Line Level)
3. Type = Free-Form Text; Store Value = F (uncheck)
4. On the Display tab select, Display Type = Hidden
5. On the Validation & Defaulting, set the Default Value =  ex. {custcol_event_orderlines} and check Formula box. (Note: {custcol_event_orderlines} is the ID of the original custom line field)
6. Click on Save button.

Replace the old custom line field footer filter with the new custom line field created above.
1. Navigate to Lists> Search> Saved Searches> Edit the Search> Available Filters tab
2. Replace the old custom line field footer filter with the new custom line field created above.
3. Click on Save & Run button
4. On the result page, manually enter the values on the footer filter.

No comments:

Post a Comment