How to validate user input with MS SQL Table ?

Hi prup
first you have to write query entity to fetch table data and then a!queryentity().data.PR No hear you wil get list of {PN No}
then by using contains() function you can search the entered PR NO

example:

load(
Local!PRNoList: a!queryEntity().data.PRNO,
a!sectionLayout(
label :"",
contents: a!columnsLayout(
columns: {
a!columnLayout(
contents: {
a!textField(
label: "PR NO",
value: ri!PRNO,
saveInto: ri!PRNO,
validations: if(
contains(
local!PRNoList,
ri!prNo
),
"PR No Exists",
{}
)
)
}
)
}
)
)
)

Hi Krishna Chaitanya I have almost two hundred thousand (2,00,000) record in PR table and when i used the Query rule i was able to fetch only 2000 records. If i try to fetch all record i get "Function evaluation error : Memory threshold reached during output conversion". Is there anyway to fix this problem ?

Hi Krishna Chaitanya i know the concept now but need help with syntax. I have created the Query Rule CheckPRNumber() and if i pass the PR number as parameter then it returns the value.

The same Query Rule i am trying to call in my interface like this - 

a!integerField(
      label: "PR",
      labelPosition: "ABOVE",
      value: ri!PRnumber,
      saveinto: ri!PRnumber,
      refreshAfter: "UNFOCUS",
      validations: {if(rule!CheckPRNumber(ri!PRnumber), {}, "Invalid PR Number")}
    )

But i am getting error - Error evaluating function 'queryruleexec' : No value received for input [PRnumber] in query rule [CheckPRNumber].