Invalid Query Error

The Invalid Query error is issued in the following situations:

Invalid use of 'Boolean' in query condition: you have a condition in your simple query that does not return a boolean value or that is not using a Boolean operator correctly.

Launch the Query condition editor and change this condition in order to return a boolean value.

<query> must use at least one entity: your simple queries must have one or more entities to select from.

Launch your Simple query editor and add, at least, one entity to your query.

Output structure cannot contain structures <structures> with nested Records / Records Lists: you have a simple query that contains nested structures.

Fix the structures involved in your simple query or use other structure(s) that are not nested.

<Condition> query condition must include at least one 'Boolean' operator: the conditions of a simple query cannot be translated to an SQL query. For example, MyAttr + 2, this condition is not correct.

Edit this simple query and change its conditions in order to include at least one Boolean operator.

Ambiguous relations between <entity1> and <entity2> in <query>: you have more than one relationship between these two entities and the joins being used are not of the same type. For example, you have EntityA with two attributes whose type is EntityB Identifier and your query uses these two entities as below:

EntityA.Attribute1 = EntityB.Id

EntityA.Attribute2 = EntityB.Id (EntityA with or without EntityB)

i.e. respectively, an inner join and an outer join, Service Studio presents this error message.

Edit your join conditions and assure that the joins involving these entities are of the same type.

In the query ‘<query>’ the Foreign Entities are located in different databases: ‘<Foreign Entity 1>’, ‘<Foreign Entity 2>’,… in ‘<Database Connection A>’; ‘<Foreign Entity 3>’, ‘<Foreign Entity 4>’,… in ‘<Database Connection B>’; …: you are using Foreign Entities in the Simple Query that are located in different databases. Each Simple Query can only use Foreign Entities located in the same database.

Edit the Simple Query and put each group of Foreign Entities in its separate Simple Query - the groups are detailed in the error message to help you. If you have joins between Foreign Entities that have to be separated, join manually the result sets of their Simple Queries.

You can also contact your Service Center administrator in order to check if the Foreign Entities you are using are located in the correct databases.

Clicking the symbol will take you directly to the parent action flow. Open the Query editor to find the problem condition and then the Query Condition Editor where the Validate button gives you the precise cause of the problem.