Skip to main content
A
ahanchat5-Regular Member
5-Regular Member
April 14, 2016
Question

Why doesn't FindDataTableEntries work with multiple values is given Values infotable

  • April 14, 2016
  • 1 reply
  • 3547 views

When I happen to use FindDataTableEntries on DataTable, by setting multiple rows in Values Infotable, I get an error as below

Unable to Invoke Service FindDataTableEntries on WA_SampleGuidNameProductionValueTable : Invalid Number of values provided to FindDataTableEntries in WA_SampleGuidNameProductionValueTable

But FindDataTableEntries work for single row in Values infotable.

    1 reply

    A
    Aanjan5-Regular Member
    5-Regular Member
    April 14, 2016

    Anirudha, I believe FindDataTableEntries input parameter is not intended to work with a multiple row infotable. It only accepts a single row infotable, tries to match the specified values and then print them.

    A
    ahanchat5-Regular MemberAuthor
    5-Regular Member
    April 14, 2016

    Ok, Then which service to use if I have multiple values.

    I tried using QueryDataTableEntries as below, but I don't get any values. What is the right way to use QueryDataTableEntries?

    I appreciate your reply, I am stuck into an critical issue and it is affecting our production server. Please help.

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    var str1 = "19be81d24259853a99fc15fdcda63934521bae29";

    var str2 = "2052527c1afe8af884d387d544ab2d2b3c0e1ab9";

    var jsonArray = [str1, str2];

    var query = {

        filters: {

            type : "EQ",

            fieldName : "guid",

            values: jsonArray

        }

    };

    var values = me.CreateValues();

    var params = {

        maxItems: undefined /* NUMBER */,

        values: values /* INFOTABLE*/,

        query: query /* QUERY */,

        source: undefined /* STRING */,

        tags: undefined /* TAGS */

    };

    // result: INFOTABLE dataShape: "undefined"

    var result = me.QueryDataTableEntries(params);

    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

    A
    ahanchat5-Regular MemberAuthor
    5-Regular Member
    April 14, 2016

    Please note that there is typo, The type I have used is "IN"

    Terms & ConditionsCookie settingsAccessibility statement