When I perform a search for records in a table that have the "Modified Date" property between two dates, records from tables other than the one used for the search are returned. The mistaken records' .table property incorrectly list the selected table.
def get_recently_modified_records(
table: granta.Table,
minimum_date: str,
maximum_date: str,
) -> list[granta.Record]:
utils.logger.info(
f"Getting records modified between {minimum_date} and {maximum_date}"
)
modified_criterion = granta.SearchCriterion(
granta.PseudoAttributeDefinition("modifiedDate"), # type: ignore
"BETWEEN",
(minimum_date, maximum_date),
)
return table.search_for_records_where([modified_criterion, table_criterion])
Adding a new criterion for the table returns an error stating that the table name psuedo attribute cannot be used for searching.
table_criterion = granta.SearchCriterion(
granta.PseudoAttributeDefinition("tableName"), # type: ignore
"CONTAINS",
table.name,
)
