Hi,
Answers to your questions
1.whenever job description table in dataverse gets created, and lets say we have 300 job postings items and few job status were closed ,inactive ,and few records seems to be active so how to ensure below custom prompt filters the data based on the status and is there a way we can filter only active or in progress statuses in the below prompt
Answer- I see there is an option to filter the dataverse table by attribute /column value, so we can filter out the status column accordingly and get that rows/records from that dataverse table.
2. Everytime it should not iterate the entire job postings dataverse tables where its inactive and outdated job postings but we are not capturing job statuses and there is no status columns for job descriptions.
Answer- I didn't understand by this question, in the first question, you have mentioned there is a status column where you need to filter the dataverse tables in first question, so need more clarification over this.
3.How we can filter based on Job descriptions for the respective candidates in the below custom prompt
I think you can re-design the prompt as shown below
Hi,
Based on data present in dataverse table having details of job posting under Job description attribute, could you help me to find the job description which suits the below candidate's experience and skills as shared below
Experience : {{Experience}}
Skills: {{skills}}
If you find any suitable job description matching experience and above skillsets, provide the job description value as output in following format shared below
Shortlisted for given job description.
if no such job description were found, provide output as not shortlisted.
See whether this can help you !