Enhancement #1467

Support for IN and NOT IN operators in the rules

Added by Blatti Yves 11 months ago. Updated 7 months ago.

Status:ClosedStart date:11/20/2018
Priority:NormalDue date:
Assignee:Blatti Yves% Done:

100%

Category:EXTRACT
Target version:4.5.1
Sponsor: Ergonomic impact:

Ease the rules input for admin

Functional impact:

None


Description

To allow the comparison of a variable with several values, add support for IN and NOT IN (SQL equivalent) operators

example 1 :

productguid IN ("70370f51-ec38-4eeb-b0e2-5489ffa03969", "65939378-46bf-4d76-a74c-a01a94ad8381", "196")

this rule must currently be written as such:

productguid "70370f51-ec38-4eeb-b0e2-5489ffa03969" OR productguid "65939378-46bf-4d76-a74c-a01a94ad8381" OR productguid == "196")

example 2 :

productguid NOT IN ("70370f51-ec38-4eeb-b0e2-5489ffa03969", "65939378-46bf-4d76-a74c-a01a94ad8381", "196")

this rule must currently be written as such:

productguid != "70370f51-ec38-4eeb-b0e2-5489ffa03969" AND productguid != "65939378-46bf-4d76-a74c-a01a94ad8381" AND productguid != "196")

These operators are compatible with others (assignees and geographical) and can be combined with ANDs or ORs.

example 3 :

productguid IN ("70370f51-ec38-4eeb-b0e2-5489ffa03969", "196") AND surface < 10000

Source (french) : https://projets.asitvd.ch/issues/19613

History

#1 Updated by Blatti Yves 11 months ago

  • Description updated (diff)

#2 Updated by Blatti Yves 7 months ago

  • Functional impact set to None
  • Ergonomic impact set to Ease the rules input for admin

#3 Updated by Blatti Yves 7 months ago

  • Status changed from Request For Comments to Accepted

#4 Updated by Blatti Yves 7 months ago

  • Status changed from Accepted to Affected

#5 Updated by Blatti Yves 7 months ago

  • Assignee changed from Technical Committee to Blatti Yves

#6 Updated by Blatti Yves 7 months ago

  • Status changed from Affected to Resolved

#7 Updated by Blatti Yves 7 months ago

  • Status changed from Resolved to To merge

#8 Updated by Blatti Yves 7 months ago

  • % Done changed from 0 to 100

#9 Updated by Blatti Yves 7 months ago

  • Status changed from To merge to Closed

Also available in: Atom PDF