Solved

Today and future 7 tasks should show in mobile

  • 23 August 2022
  • 3 replies
  • 46 views
J
Rank
Badge +3

Hi,

My client wants to see only today task and the future 7 tasks in the mobile job list screen.

Is there a standard solution for this?

 

 

Thanks

icon

Best answer by Anjula Priyanath 23 August 2022, 11:22

View original

3 replies

Anjula Priyanath
Rank
Userlevel 6
Badge +14

Hi @Jayadeep,

Try with JobList screen filter.

  1. Navigate to JobList screen.
  2. Select Designer - Screen in the Global Menu.
  3. Modify filter. - Here you can define your logic.

Thanks.

Anjula
J
Rank
Badge +3

@Anjula Priyanath, 

Thanks, I am able to filter the job list based on days.

But my logic comprises of multiple conditions.

Will the logic allow only sql queries or can I use if else conditions in the logic.

If possible share a sample logic to use if else with sql query.

 

Thanks. 

Anjula Priyanath
Rank
Userlevel 6
Badge +14

Hi @Jayadeep,

You can use filter condition or client script for these filter. If you use a client script, you can write your logics and return the ‘where clause’ as a string depending on multiple logic. 

Filter properties

 

Client script to return where clause

 

Note - I’ve written this for Receiving screen, that why I used receiving related tables.

Anjula

Reply


Terms & ConditionsCookie settings