Skip to main content
raghavak0001
raghavak0001
May 22, 2024
Question

query database empty values

  • May 22, 2024
  • 4 replies
  • 0 views

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 

    4 replies

    stefanhelzle0001
    stefanhelzle0001
    May 22, 2024

    Do you have a specific reason for not using records to query that data?

    raghavak0001
    raghavak0001Author
    May 22, 2024

    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 

    stefanhelzle0001
    stefanhelzle0001
    May 22, 2024

    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?

    Terms & ConditionsAccessibility statement