Skip to main content
F
farhana1563
July 24, 2024
Question

Searching from Database with not matching two word

  • July 24, 2024
  • 10 replies
  • 0 views

I want search all records with not matching two keyword (CLOS & CANS) like:

1. ADVG XCLT QRPR

2. ADVG CLOS QRPR

3. ADVG CLOS CANS

4. ADVG PQRS QRPR

from the 4 rows I want to display first and last rows. Rows having two word like CLOS and CANS shall not be display.

So, I want to know which keyword I shall use in query function. Not Includes function work only on keyword. But this query have more than one keyword. Please advice.

    10 replies

    venkatrea696188
    venkatrea696188
    July 24, 2024

    Can't we achieve it through  Querylogic  "AND"  with multiple Queryfilters 

    pragnaj0001
    pragnaj0001
    July 24, 2024

    if u r using query record type, u can use list of query filters . if u r using db, u can using logical expression "AND".  

    Y
    yogip3177
    July 24, 2024

    You can try 'not includes' parameter. See the sample code for reference:

    filters: a!queryLogicalExpression(
    operator: "AND",
    filters: {
      a!queryFilter(
        field: 'recordType!xxx.fields.abc',
        operator: "not includes",
        value: "CLOS"
      ),
      a!queryFilter(
        field: 'recordType!xxx.fields.abc',
        operator: "not includes",
        value: "CANS"
      )
    },
    ignoreFiltersWithEmptyValues: true
  )

    F
    farhana1563Author
    July 24, 2024

    Thanks for your reply. but I want to call like this with single value selection from dropdown like:

    filters: a!queryLogicalExpression(
    operator: "AND",
    filters: {
    a!queryFilter(
    field: 'recordType!xxx.fields.abc',
    operator: "not includes",
    value:{ "CLOS", "CANS"}
    ),
    },
    ignoreFiltersWithEmptyValues: true
    )

    So I want to know if it is possible or not or which operation I have to use.

    Y
    yogip3177
    July 24, 2024
    No. You need to dynamically append a!queryFilter based on selection.
    a!queryFilter(
        field: 'recordType!XYZ.fields.abc',
        operator: "not includes",
        value: "Selected Value"
      )
    prasantap0900
    prasantap0900
    July 31, 2024

    a!queryRecordType(
    recordType: recordType!abc,
    filters: {
    a!queryFilter(
    field: recordType!abc.xyz,
    operator: "not includes",
    value: "CLOS"
    ),
    a!queryFilter(
    field: recordType!abc.xyz,
    operator: "not includes",
    value: "CONS"
    )
    },
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
    )

    -------------------------------------------------------------------------------------
    a!queryRecordType(
    recordType: recordType!abc,
    filters: a!queryLogicalExpression(
    operator: "AND",
    filters: {
    a!queryFilter(
    field: recordType!abc.xyz,
    operator: "not includes",
    value: "CLOS"
    ),
    a!queryFilter(
    field: recordType!abc.xyz,
    operator: "not includes",
    value: "CONS"
    )
    }
    ),
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
    )

    konduruc733182
    konduruc733182
    July 31, 2024

    prasantap0900
    prasantap0900
    July 31, 2024

    thanks for suggesting me [mention:2df2892a4df7486f9775b4d2f0e405fd:e9ed411860ed4f2ba0265705b8793d05] 

    a!queryRecordType(
recordType: recordType!abc,
filters: {
a!queryFilter(
field: recordType!abc.xyz,
operator: "not includes",
value: "CLOS"
),
a!queryFilter(
field: recordType!abc.xyz,
operator: "not includes",
value: "CONS"
)
},
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
)

-------------------------------------------------------------------------------------
a!queryRecordType(
recordType: recordType!abc,
filters: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: recordType!abc.xyz,
operator: "not includes",
value: "CLOS"
),
a!queryFilter(
field: recordType!abc.xyz,
operator: "not includes",
value: "CONS"
)
}
),
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
)

    Terms & ConditionsAccessibility statement