tatay188 commented on issue #12314: URL: https://github.com/apache/cloudstack/issues/12314#issuecomment-3702498054
my fault, The statement was an example, my fault on grammar I should split in two to be overly clear. mysql> select id,name,uuid,unique_name,created, removed,state,guest_type from network_offerings where state="Disabled"; **OR** mysql> select id,name,uuid,unique_name,created, removed,state,guest_type from network_offerings where state="Removed"; he clause 'state="Disabled or Removed”’ is not a valid clause. My fault, I meant to write state="Disabled" ... or "Removed" Correct, we are on the same page with your statement "state=“Disabled”’ would be and it would show all currently “Disabled” offerings, including those that are removed. 'state=“Enabled”’ would show all enabled offering even when removed." I don't know how you called but is part of the db-consistency. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
