機械翻訳について
  1. Oracle Fusion Cloud Customer ExperienceのOracle CX SalesおよびB2B Service REST API for Sales and Fusion ServiceのREST API
  2. 適応型検索
  3. 適応型検索の例
  4. 拡張問合せ記述子による検索

拡張問合せ記述子による検索

高度な問合せエンジンの設計および取込みに関する理解を深めるには、「問合せ式」トピックを参照してください。

次と等しい

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields":["PartyUniqueName", "PrimaryAddress"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q":{"op": "$eq" , "attribute": "PartyUniqueName", "value": "A-Mark Precious Metals (Santa Monica, US)"}
}

次と等しくない

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields":["PartyUniqueName", "PrimaryAddress"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q":{"op": "$ne" , "attribute": "PartyUniqueName", "value": "A-Mark Precious Metals (Santa Monica, US)"}
}

存在する

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields":["PartyUniqueName", "PrimaryAddress"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q":{"op": "$pr" , "attribute": "PrimaryIndustry"}
}

存在しない

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields":["PartyUniqueName", "PrimaryAddress"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q":{"op": "$npr" , "attribute": "PrimaryIndustry"}
}

すべて

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields":["PartyUniqueName", "PrimaryAddress"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q":{"op": "$all" , "attribute": "PartyUniqueName", "value": "Technologies United"}
}

任意

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields":["PartyUniqueName", "PrimaryAddress"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q":{"op": "$any" , "attribute": "PartyUniqueName", "value": "Technologies United"}
}

なし

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields":["PartyUniqueName", "PrimaryAddress"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q":{"op": "$none" , "attribute": "PartyUniqueName", "value": "Technologies United"}
}

In

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields":["PartyUniqueName", "PrimaryAddress"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q":{"op": "$in" , "attribute": "PartyUniqueName", "value": "Technologies United"}
}

次に含まれない

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields":["PartyUniqueName", "PrimaryAddress"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q":{"op": "$notin" , "attribute": "PartyUniqueName", "value": "Technologies United"}
}

次の間にある

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields": ["PartyUniqueName","PrimaryAddress","CreationDate"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q" : {"op": "$wi", "attribute": "CreationDate", "value1": "now-1y/y", "value2": "now"}
}

より大きい

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields": ["PartyUniqueName","PrimaryAddress","CreationDate"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q" : {"op": "$gt", "attribute": "CreationDate", "value": "now-1y/y"}
}

次以上

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields": ["PartyUniqueName","PrimaryAddress","CreationDate"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q" : {"op": "$ge", "attribute": "CreationDate", "value": "now-1y/y"}
}

次より小さい

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields": ["PartyUniqueName","PrimaryAddress","CreationDate"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q" : {"op": "$lt", "attribute": "CreationDate", "value": "now-1y/y"}
}

次と等しいリース

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields": ["PartyUniqueName","PrimaryAddress","CreationDate"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q" : {"op": "$le", "attribute": "CreationDate", "value": "now-1y/y"}
}

あいまい一致

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields":["PartyUniqueName", "PrimaryAddress"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q":{"op": "$fm" , "attribute": "PartyUniqueName", "value": "United"}
}

問合せ記述子を使用した演算子検索

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields": ["PartyUniqueName","PrimaryAddress","CreationDate"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q": {"op": "$and",
        "criteria": [
                {"op": "$eq",
                "attribute": "PrimaryAddress.State",
                "value": "CA"},
                {"op": "$co" ,
                "attribute": "PartyUniqueName",
                "value": "Oracle"}]}
}

または問合せ記述子を使用した演算子検索

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity":"Account",
    "fields": ["PartyUniqueName","PrimaryAddress","CreationDate"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q": {"op": "$or",
        "criteria": [
                {"op": "$sw",
                "attribute": "PartyUniqueName",
                "value": "United"},
                {"op": "$co" ,
                "attribute": "PartyUniqueName",
                "value": "Oracle"}]}
}

問合せ記述子を使用した演算子検索ではありません

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{   "entity":"Account",
    "fields": ["PartyUniqueName","PrimaryAddress","CreationDate"],
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q": {"op": "$not",
            "criterion": {"op": "$sw",
            "attribute": "PartyUniqueName", "value": "United"}}
}

ネストされたレコード/外部キー属性の問合せ

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{    "entity" : "Account",
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q":
        {"op": "$eq" ,
        "attribute": "PrimaryAddress.ListOfPartySiteUses.SiteUseType",
        "value": "BILL_TO"}
}

ネストされたリスト属性の問合せ

cURLコマンド

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

リクエスト・ペイロードの例

{   "entity" : "Account",
    "sort": [{ "attribute":"PartyUniqueName","direction":"ascending"}],
    "q":
        {"op": "$eq" ,
        "attribute": "ListOfAddresses.City",
        "value": "REDWOOD SHORES"}
}