Entities Equivalent in Advanced Query

Entities Equivalent in Advanced Query

  

Hi,


I am trying to write an Advanced Query in Service Studio 8 and am looking for a little help.

I cant figure out what the equivalent to Entities in a query, i.e, in a query we can have "Entities.Status.Active", what would the SQL equivalent be?


Thanks,

Ben

Solution

{EntityName].[FieldName] = @ActiveStatus

If you want to use the value of Entities.Status.Active you have to add an input in which you assign this static value.


Solution