Project

General

Profile

Feature #6899

goapiv2 Lead Filter

Added by Wittie Manansala over 1 year ago. Updated 22 days ago.

Status:
Closed
Priority:
Normal
Category:
Features
Start date:
07/17/2018
Due date:
% Done:

40%

Estimated time:

Description

Hi Team,

Baka pwede na natin enable sa bagong version natin to:

LEAD_FILTERS TABLE

Filter ID -This is the short name of a Lead Filter. This needs to be a unique identifier. Do not use any spaces or punctuation for this field. max 10 characters, minimum of 2 characters. 
Filter Name -This is a more descriptive name of the Filter. This is a short summary of the filter. max 30 characters, minimum of 2 characters. 
Filter Comments -This is where you can place comments for a Filter such as -calls all California leads-. max 255 characters, minimum of 2 characters. 

Admin User Group -This is the administrative user group for this record, this allows admin viewing of this recoird restricted by user group. Default is --ALL-- which allows any admin user to view this record. 
Filter SQL -This is where you place the SQL query fragment that you want to filter by. do not begin or end with an AND, that will be added by the hopper cron script automatically. an example SQL query that would work here is- called_count > 4 and called_count < 8 -. 
telephonyfilters01.jpg (89.8 KB) telephonyfilters01.jpg Chris Lomuntad, 05/15/2019 05:18 PM
telephonyfilters02.jpg (93.9 KB) telephonyfilters02.jpg Chris Lomuntad, 05/15/2019 05:18 PM
ALI1.png (35.6 KB) ALI1.png Jackie Alfonso, 09/25/2019 05:47 AM
ALI2.png (60.1 KB) ALI2.png Jackie Alfonso, 09/25/2019 05:47 AM
ALI3.png (105 KB) ALI3.png Jackie Alfonso, 09/25/2019 05:48 AM

History

#1 Updated by Wittie Manansala 9 months ago

  • Assignee changed from Demian Lizandro Biscocho to Alexander Jim Abenoja

#2 Updated by Demian Lizandro Biscocho 8 months ago

  • Category set to Features
  • Assignee changed from Alexander Jim Abenoja to Chris Lomuntad
  • Target version set to GOautodial CE v4

Chris,

Sa yo ko na assign to. Meron na tayo dati nito sa v3 if I'm not mistaken. Paki-coordinate sa NOC team.

#3 Updated by Chris Lomuntad 8 months ago

  • Status changed from New to In Progress

Oks dems... Check ko na lang yung sa v3...

#5 Updated by Chris Lomuntad 5 months ago

  • File telephonyfilters01.jpg added
  • File telephonyfilters02.jpg added
  • % Done changed from 0 to 40

#6 Updated by Chris Lomuntad 5 months ago

Team,

Eto yung changes/additional page para sa Lead Filter... Kulang pa yung mismong API functions nya.

Cheers,
Chris

#7 Updated by Chris Lomuntad 5 months ago

  • File deleted (telephonyfilters01.jpg)

#8 Updated by Chris Lomuntad 5 months ago

  • File deleted (telephonyfilters02.jpg)

#9 Updated by Chris Lomuntad 25 days ago

  • Status changed from In Progress to Feedback
  • Assignee changed from Chris Lomuntad to Wittie Manansala

Team,

Done creating the pages for adding, modifying and deleting of filters. Kindly test it on our test server. Thanks.

Cheers,
Chris

#10 Updated by Jackie Alfonso 23 days ago

Hi Sir Chris,

Base on my test the filter is now working. create a lead filter with Filter SQL "first_name in("ALICIA")" and its showing properly.

#11 Updated by Wittie Manansala 22 days ago

  • Status changed from Feedback to Closed
  • Assignee changed from Wittie Manansala to Chris Lomuntad

Also available in: Atom PDF

Go to top