Skip to main content
August 23, 2021
Solved

how can i make a search form through which i can fetch data ?

  • August 23, 2021
  • 5 replies
  • 0 views

This is the what i want , please reply .

Thank You in advance.

    5 replies

    stefanhelzle0001
    Brainy
    August 23, 2021
    armandov0001
    August 23, 2021

    You could save all values into one big local variable.

    Then use the one variable you just created, passing as arguments into the expression rule that you use to query into your database directly.

    August 23, 2021

    Thanks Arosario , Can you please show it via an example if possible

    armandov0001
    August 23, 2021

    1. create local variables for each text field as null,

    2. the variable you create to hold those values:

    i'm assuming that you have created a cdt


    local!filter: 'type!{urn:com:appian:types}CDT_TYPE_EXAMPLE'(
    firstName: local!firstName,
    lastName: local!lastName,
    location: local!location,
    applicationType: local!applicationType,
    applicationStatus: local!applicationStatus,
    fromDate: local!fromDate,
    toDate: local!toDate
    )

    3. each textField you need to save them using "saveInto" from textField properties

    4. create a local variable to hold your data from an expression rule which is querying through your database.

    5. you will have something like this:

    local!data: rule!EXPRESSION_RULE_QUERY_DATABASE(
    firstName: local!firstName,
    lastName: local!lastName,
    location: local!location,
    applicationType: local!applicationType,
    applicationStatus: local!applicationStatus,
    fromDate: local!fromDate,
    toDate: local!toDate
    )

    The reason for doing this is letting your search be more dynamic