# How to make dashboard tracker fields mandatory

**URL:** <https://www.epiusers.help/t/how-to-make-dashboard-tracker-fields-mandatory/63540>\
**Category:** Epicor ERP 9\
**Tags:** dashboard\
**Created:** [January 14, 2020, 3:49pm UTC](https://www.epiusers.help/t/how-to-make-dashboard-tracker-fields-mandatory/63540 "2020-01-14T15:49:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ftahir](https://www.epiusers.help/letter_avatar_proxy/v4/letter/f/e274bd/32.png) [@ftahir](https://www.epiusers.help/u/ftahir)\
**Post date:** [January 14, 2020, 3:49pm UTC](https://www.epiusers.help/t/how-to-make-dashboard-tracker-fields-mandatory/63540/1 "2020-01-14T15:49:58Z")

</div>

Hi there,

I am developing a dashboard. I have a tracker that filters on (say) 4 fields. I want to set Field 1 & Field 2 as mandatory filter and leave Field 3 & Field 4 optional. How can I achieve that?

If I am checking ‘criteria required’ box on tracker properties, it only forces any one field to be filled. But I want to have Field 1 & 2 mandatory.

Thanks.

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [January 14, 2020, 4:21pm UTC](https://www.epiusers.help/t/how-to-make-dashboard-tracker-fields-mandatory/63540/2 "2020-01-14T16:21:42Z")

</div>

A BPM on the BO Ice.DynamicQuery.Execute could detect the params uesed, and if they aren’t found, then show a message and exit.

---

<div class="post-metadata">

**Author:** ![ftahir](https://www.epiusers.help/letter_avatar_proxy/v4/letter/f/e274bd/32.png) [@ftahir](https://www.epiusers.help/u/ftahir)\
**Post date:** [January 14, 2020, 4:43pm UTC](https://www.epiusers.help/t/how-to-make-dashboard-tracker-fields-mandatory/63540/3 "2020-01-14T16:43:15Z")

</div>

Thanks Calvin.

Can you elaborate a bit more? I have not used BPM yet.

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [January 14, 2020, 5:11pm UTC](https://www.epiusers.help/t/how-to-make-dashboard-tracker-fields-mandatory/63540/4 "2020-01-14T17:11:51Z")

</div>

This would be a difficult BPM to try as your first. But if you are adventurous…

Method Directive:  
BO: Ice.DynamicQuery  
Method: Execute  
Type: Pre-Process

 ![image](https://epiusers.help/uploads/default/original/3X/f/6/f66c6761e4755ac989775cec51158b224f4db727.png)

**Show Message 0** is just to show the values of various fields in the query the dashboard executes

 ![image](https://epiusers.help/uploads/default/original/3X/f/9/f9e8219c335fc1a6718e1ed69be2c923270b1a61.png)

**Condition 0** checks for the two field names in the qry expression  
(replace “InvcHead\_InvoiceNum” and “InvcHead\_InvoiceDate” with your field names)

 ![image](https://epiusers.help/uploads/default/original/3X/1/2/126a69a8634b58b920d9b3ee50bf0bd2587cfdab.png)

**Show Message 1** Alerts the user that the required fields weren’t provided.

![image](https://epiusers.help/uploads/default/original/3X/6/0/605ddba584b7a7f518be5b64bf0749a36dbde79f.png)

Set Field 0 sets the qry so that no data is returned.

![image](https://epiusers.help/uploads/default/original/3X/e/c/ec0745a27d92d4df3c35465266c9b5eafa2f011a.png)

The expression I set it to is:

```auto
"(InvcHead_InvoiceNum <= N'0') AND (InvcHead_InvoiceDate <= N'1966-11-24T00:00:00')"

```

That’s a set of values that are guaranteed to not return any data.

If you don’t do the “Set Field” block, it would just return the data (using just the one param) to the dashboard

# EDIT!!!

That would run for every BAQ that is executed (dashboards, reports searches, etc…)

So you’d need to put another condition to check for the source that executed this.

---

<div class="post-metadata">

**Author:** ![ftahir](https://www.epiusers.help/letter_avatar_proxy/v4/letter/f/e274bd/32.png) [@ftahir](https://www.epiusers.help/u/ftahir)\
**Post date:** [January 14, 2020, 5:14pm UTC](https://www.epiusers.help/t/how-to-make-dashboard-tracker-fields-mandatory/63540/5 "2020-01-14T17:14:09Z")

</div>

Appreciate that. I will give it a try.