Queries using a LIKE or REGEXP pattern for the property name do not work

Created by: Henrik tom Wörden

Suppose you have the following structure: ent1 -> ent2 where ent2 has a name. Now you want to search for ent1s that reference an ent2 with some name, but you are not sure how that is spelled and you want to use "like ..." You could expect it to work like follows:

• FIND RECORD ent1 with ent2 like "some*" which does not work.
• FIND RECORD ent1 with ent2 with name like "some*" which does not work.
• FIND RECORD ent2 with name like "some*" also does not work.

Is this a bug or a feature? How am I supposed to solve this task?

BTW: FIND RECORD ent1 with ent2="something" does work.

Probably related to #87 (closed) .

See also

• this exception

Imported comments:

By Henrik tom Wörden on 2020-06-19T07:14:37.516Z

mentioned in commit a895cdff

By Timm Fitschen on 2020-06-16T10:51:15.423Z

mentioned in merge request caosdb-pyinttest!28 (merged)

By Timm Fitschen on 2020-06-16T10:15:13.855Z

mentioned in merge request !44 (merged)

By Timm Fitschen on 2020-06-16T09:04:58.588Z

mentioned in merge request caosdb-mysqlbackend!13

By Timm Fitschen on 2020-06-15T13:41:56.613Z

mentioned in commit caosdb-pyinttest@a1c23e77da8cd980ff9e72ebaf2b93c36260ceb0

By Timm Fitschen on 2020-04-27T10:30:15.039Z

changed title from Queries using the name as property do not work to Queries using a LIKE or REGEXP pattern for the property name do not work

By Timm Fitschen on 2020-04-27T10:29:24.214Z

changed the description

By Henrik tom Wörden on 2020-04-27T09:57:31.907Z

changed the description

By Henrik tom Wörden on 2019-11-13T13:22:18.519Z

This is not yet implemented. Conceptually, this should work.

By Henrik tom Wörden on 2019-11-08T15:18:10.059Z

changed the description