hi i have a query that i am using to fetch the
data from post grace sql to appian but while i am making a manual query in that query i have empty values as some contion
in the above condition we have empty values whic is not considerding by plugin and displaying the below error
please give me any solution on this
Discussion posts and replies are publicly visible
Do you have a specific reason for not using records to query that data?
due to postgrace sql group by restriction i am folowing this way to fetch duplicate records , after fetching the data i want make group by on one particular coulmn and want to see the latest records in decending order
Grouping and sorting is baked into records. But I am not sure whether you would want to discuss that.
In your SQL snippet, I see that you reference one field like this: "account.relationship_status" and the other field without a leading table name. Could that be the issue?
no i have a table and select queries and all for understanding pupose i have given one of the condtion fromthe sp wher i have empty value check