Project

General

Profile

Actions

Feature #6899

closed

goapiv2 Lead Filter

Added by Wittie Manansala almost 6 years ago. Updated over 4 years 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 -. 

Files

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
Actions #1

Updated by Wittie Manansala over 5 years ago

  • Assignee changed from Demian Biscocho to Alexander Jim Abenoja
Actions #2

Updated by Demian Biscocho over 5 years ago

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

Chris,

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

Actions #3

Updated by Chris Lomuntad over 5 years ago

  • Status changed from New to In Progress

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

Actions #5

Updated by Chris Lomuntad about 5 years ago

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

Updated by Chris Lomuntad about 5 years ago

Team,

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

Cheers,
Chris

Actions #7

Updated by Chris Lomuntad about 5 years ago

  • File deleted (telephonyfilters01.jpg)
Actions #8

Updated by Chris Lomuntad about 5 years ago

  • File deleted (telephonyfilters02.jpg)
Actions #9

Updated by Chris Lomuntad over 4 years 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

Actions #10

Updated by Jackie Alfonso over 4 years 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.

Actions #11

Updated by Wittie Manansala over 4 years ago

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

Also available in: Atom PDF

Go to top