• Replies 7 replies
  • Subscribers 10 subscribers
  • Views 11285 views
  • Users 0 members are here
Options
Related

Use multiple "like" conditions in AML query?

KalleAnka
オフライン
Hi, I have: 
setType("Part");
setProperty("permission_name", "New %");
setPropertyAttribute("permission_name", "condition", "like");
var item = apply();
How do I change this to use multiple "like" conditions? I want to express something like:   "permission_name LIKE 'New %' OR permission_name LIKE 'In Work %'" Thanks,,,
Parents
  • Congretulations to this flawless victory! But a little bit more compact might be a glorious and unmatched Where query, e.g. setAttribute("where", String.Format("[Part].classification like '{0}' and [Part].state = '{1}'" , "Electrical/Resistor/%", "Released")); or setAttribute("where", String.Format("[Part].classification like '{0}' or [Part].classification like '{1}'" , "Assembly/Antenna%", "Electrical/Resistor/%"));
Reply
  • Congretulations to this flawless victory! But a little bit more compact might be a glorious and unmatched Where query, e.g. setAttribute("where", String.Format("[Part].classification like '{0}' and [Part].state = '{1}'" , "Electrical/Resistor/%", "Released")); or setAttribute("where", String.Format("[Part].classification like '{0}' or [Part].classification like '{1}'" , "Assembly/Antenna%", "Electrical/Resistor/%"));
Children
No Data