Method and system for updating a filter logic expression representing a boolean filter

• US 9,589,070 B2
• Filed: 08/03/2012
• Issued: 03/07/2017
• Est. Priority Date: 10/10/2011
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Gitelman, Alex
• Primary Examiner(s): Beausoliel, Jr., Robert
• Assistant Examiner(s): Rayyan, Susan F
• Application Number:
  US13/566,095
• Publication Number:
  US 20130091153A1
• Time in Patent Office: 1,677 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/9032 Query formulation

Abstract

A method for automatically updating a filter logic expression representing a Boolean filter comprising a plurality of search conditions is disclosed. The method includes receiving a first indication to remove a first search condition from a condition list comprising search conditions. Each search condition is associated with an identifier and the first search condition is associated with a first identifier, and the search conditions are listed in sequential order according to the associated identifier. In response to receiving the first indication, a second search condition associated with a second identifier that sequentially follows the first identifier is identified, and the second search condition is reassociated with a third identifier that immediately precedes the second identifier. A filter logic expression comprising a plurality of identifiers and operators and representing a Boolean filter is then modified by automatically replacing any reference to the second identifier with the third identifier.

Claims

1. A method comprising:

providing, by a computer node, a filter logic expression comprising a plurality of search conditions separated by one or more Boolean operators, each of the plurality of search conditions being represented in the filter logic expression by an associated identifier;

providing, by the computer node, a list of the plurality of search conditions with their associated identifiers, the plurality of search conditions being displayed in sequential order based upon the identifiers;

identifying, by the node computer, a first search condition from the list of the plurality of search conditions in response to receiving a first indication to remove the first search condition from the list of the plurality of search conditions;

identifying, by the computer node, a second search condition of the plurality of search conditions associated with a second identifier, wherein the second identifier sequentially follows the first identifier;

reassociating, by the computer node, the second search condition with the first identifier in response to removing the first search condition from the list of the plurality of search conditions; and

modifying, by the computer node, the filter logic expression by automatically replacing any reference to the second identifier with the first identifier.

2. The method of claim 1 wherein each identifier is a number, and wherein the plurality of search conditions are displayed in numerical order according to the associated identifiers.

3. The method of claim 1 wherein each identifier is an alphabetical letter, and wherein the plurality of search conditions are displayed in alphabetical order according to the associated identifiers.

4. The method of claim 1 further comprising providing a user interface including a condition list and the plurality of search conditions.

5. The method of claim 4 wherein in response to receiving the first indication, the method further includes updating an appearance of the condition list included in the interface to indicate an impending removal of the first search condition.

6. The method of claim 5 wherein updating the appearance of the condition list comprises at least one of striking out the first search condition, highlighting the first search condition, bracketing the first search condition, and modifying the appearance of the first search condition.

7. The method of claim 1 further comprising:

receiving a second indication to delete from the filter logic expression information relating to the first identifier; and

deleting from the filter logic expression the information relating to the first identifier in response to receiving the second indication.

8. The method of claim 7 wherein prior to receiving the second indication, the method further comprises:

providing a user interface for displaying the filter logic expression;

scanning the filter logic expression to detect a reference to the first identifier; and

modifying an appearance of the detected reference to the first identifier in the filter logic expression.

9. The method of claim 8 wherein, in response to receiving the second indication, the method further includes updating the filter logic expression displayed by the user interface to indicate the deletion of the information relating to first identifier.

10. The method of claim 7 wherein the information relating to the first identifier includes at least one of the first identifier and an operator associated with the first identifier.

11. An apparatus comprising:

a processor; and

one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of;

providing a filter logic expression comprising a plurality of search conditions separated by one or more Boolean operators, each of the plurality of search conditions being represented in the filter logic expression by an associated identifier;

providing a list of the plurality of search conditions with their associated identifiers, the plurality of search conditions being displayed in sequential order based upon the identifiers;

identifying a first search condition from the list of the plurality of search conditions in response to receiving a first indication to remove the first search condition from the list of the plurality of search conditions;

identifying a second search condition of the plurality of search conditions associated with a second identifier, wherein the second identifier sequentially follows the first identifier;

reassociating the second search condition with the first identifier in response to removing the first search condition from the list of the plurality of search conditions; and

modifying the filter logic expression by automatically replacing any reference to the second identifier with the first identifier.

12. The apparatus of claim 11 wherein each identifier is a number, and wherein the plurality of search conditions are displayed in numerical order according to the associated identifiers.

13. The apparatus of claim 11 wherein each identifier is an alphabetical letter, and wherein the plurality of search conditions are displayed in alphabetical order according to the associated identifiers.

14. The apparatus of claim 11 further comprising instructions which, when executed by the processor, cause the processor to carry out the step of providing a user interface including a condition list and the plurality of search conditions.

15. The apparatus of claim 14 further comprises instructions which, when executed by the processor, cause the processor to carry out the steps of updating, in response to receiving the first indication, an appearance of the condition list included in the interface to indicate an impending removal of the first search condition.

16. The apparatus of claim 15 wherein the instructions for updating the appearance of the condition list comprises at least one of striking out the first search condition, highlighting the first search condition, bracketing the first search condition, and modifying the appearance of the first search condition.

17. The apparatus of claim 11 further comprising instructions which, when executed by the processor, cause the processor to carry out the steps of:

receiving a second indication to delete from the filter logic expression information relating to the first identifier; and

deleting from the filter logic expression the information relating to the first identifier in response to receiving the second indication.

18. The apparatus of claim 17 wherein prior to receiving the second indication, the apparatus further comprises instructions which, when executed by the processor, cause the processor to carry out the steps of:

providing a user interface for displaying the filter logic expression;

scanning the filter logic expression to detect a reference to the first identifier; and

modifying an appearance of the detected reference to the first identifier in the filter logic expression.

19. The apparatus of claim 17 wherein the information relating to the first identifier includes at least one of the first identifier and an operator associated with the first identifier.

20. A non-transitory machine-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to carry out the steps of:

providing a filter logic expression comprising a plurality of search conditions separated by one or more Boolean operators, each of the plurality of search conditions being represented in the filter logic expression by an associated identifier;

providing a list of the plurality of search conditions with their associated identifiers, the plurality of search conditions being displayed in sequential order based upon the identifiers;

identifying a first search condition from the list of the plurality of search conditions in response to receiving a first indication to remove the first search condition from the list of the plurality of search conditions;

identifying a second search condition of the plurality of search conditions associated with a second identifier, wherein the second identifier sequentially follows the first identifier;

reassociating the second search condition with the first identifier in response to removing the first search condition from the list of the plurality of search conditions; and

modifying the filter logic expression by automatically replacing any reference to the second identifier with the first identifier.