How to use slot value in MYSQL Query

Rasa Open Source
1

Hi Guys. Im trying to use my slot value as a variable that I want to retrieve from my database. To elaborate a variable location is declared. It is set to tracker.getSlot(“location”). So basically I want a query to be executed which used the value of location in my sql query. I am attaching pictures below.

10%20PM
10%20PM1682×752 189 KB
25%20PM
25%20PM1462×1950 1.09 MB
40%20PM
40%20PM1868×1488 373 KB
16%20PM
16%20PM1156×1590 216 KB

Thank you!

2

Hey @zaidalvi, can you try writing the story in below format:

intent_location_specific{"location":"value"}
  - slot{"location":"value"}
  - action_find_by_location
3

Thank you @JiteshGaikwad. Fixing my story to your pattern has fixed my errors. I have one more question at the moment. Some of my synonym are not working. For instance I have a location called “defence” (this word is in a different language in my nlu file. I have stated a synonym against this value but it does not work with my slot. Any ideas?

4

does this format work for rasa 2.0 as well?