Unable to target specific attribute field

When running query using API, if the query has specific attribute to be filtered/output, it works.

However, when trying to create an Ad-hoc query trying to target specific attribute, I am unable to do so as I cannot find the specific query_field_id for the specific attribute, as they are the same for "ALL" specific attribute's field.

Using Get Query on a query that has filter/select field on specific attribute, I got:


{"query_field": {"id": 659,"available_field_name": "Import ID","selected_field_name": "Constituent Specific Attributes @Field1 Import ID","value_type": "Text","one_to_many": true,"output_sort_can_add_edit": true,"criteria_can_add_edit": false,"format_descriptor": "Alpha" },"user_alias": "" }, {"query_field": {"id": 656,"available_field_name": "Text","selected_field_name": "Constituent Specific Attributes @Field1 Description","value_type": "Text","one_to_many": true,"output_sort_can_add_edit": true,"criteria_can_add_edit": false,"format_descriptor": "Alpha" },"user_alias": "" }, {"query_field": {"id": 657,"available_field_name": "Comments","selected_field_name": "Constituent Specific Attributes @Field1 Comments","value_type": "Text","one_to_many": true,"output_sort_can_add_edit": true,"criteria_can_add_edit": false,"format_descriptor": "Alpha" },"user_alias": "" }, {"query_field": {"id": 658,"available_field_name": "Attributedate","selected_field_name": "Constituent Specific Attributes @Field1 Date","value_type": "Date","one_to_many": true,"output_sort_can_add_edit": true,"criteria_can_add_edit": false,"format_descriptor": "DateMDY" },"user_alias": "" }


however, query_field_id of 659 (import id), 656 (value/description of attribute), 657 (attribute comment), 658 (attribute date) is the same for every specific constituent attributes.


I also try using the attribute node instead of specific attribute, however, database query does not have the actual value/description of an attribute without targetting specific attribute. (you only get Category, Comments, Date, and Import ID)


{"query_field": {"id": 14342,"available_field_name": "Import ID","selected_field_name": "Constituent Attribute Import ID","value_type": "Text","one_to_many": true,"output_sort_can_add_edit": true,"criteria_can_add_edit": true,"format_descriptor": "Alpha" },"user_alias": "" }, {"query_field": {"id": 14339,"available_field_name": "Category","selected_field_name": "Constituent Attribute Category","value_type": "Text","one_to_many": true,"output_sort_can_add_edit": true,"criteria_can_add_edit": true,"format_descriptor": "Alpha" },"user_alias": "" }, {"query_field": {"id": 14340,"available_field_name": "Comments","selected_field_name": "Constituent Attribute Comments","value_type": "Text","one_to_many": true,"output_sort_can_add_edit": true,"criteria_can_add_edit": true,"format_descriptor": "Alpha" },"user_alias": "" }, {"query_field": {"id": 14341,"available_field_name": "Date","selected_field_name": "Constituent Attribute Date","value_type": "Date","one_to_many": true,"output_sort_can_add_edit": true,"criteria_can_add_edit": false,"format_descriptor": "DateMDY" },"user_alias": "" }


Is there a way to get to specific attribute using Ad-hoc query?

Is there a way to get ALL attribute's import id, category, description, comments, and date?

  • Alex Wong
  • Feb 23 2024
  • Attach files