Describe the bug
The query SELECT * FROM aws_organizations_account WHERE parent_id = 'r-kjsdw' AND id = 'xxxxxxxxxxxx'returns the value by making the GET API call since the "id" value is passed in the query parameter. However, it displays an empty result due to Steampipe's level filtration on the "parent_id" value("FromQual()" returns a null value if we don't include "parent_id" as optional quals).
Steampipe version (steampipe -v)
Example: v0.23.2
Plugin version (steampipe plugin list)
Example: v0.141.0
To reproduce
Run the query: SELECT * FROM aws_organizations_account WHERE parent_id = 'r-kjsdw' AND id = 'xxxxxxxxxxxx'
Expected behavior
It should return the result instead of empty rows.
Additional context
Add any other context about the problem here.
Describe the bug The query
SELECT * FROM aws_organizations_account WHERE parent_id = 'r-kjsdw' AND id = 'xxxxxxxxxxxx'returns the value by making the GET API call since the "id" value is passed in the query parameter. However, it displays an empty result due to Steampipe's level filtration on the "parent_id" value("FromQual()" returns a null value if we don't include "parent_id" as optional quals).Steampipe version (
steampipe -v) Example: v0.23.2Plugin version (
steampipe plugin list) Example: v0.141.0To reproduce Run the query:
SELECT * FROM aws_organizations_account WHERE parent_id = 'r-kjsdw' AND id = 'xxxxxxxxxxxx'Expected behavior It should return the result instead of empty rows.
Additional context Add any other context about the problem here.