Data store : retreive a value by key

Wappler General
1

Hi all,

I’m trying to use the datastore to manage user UI preferences.
After the user is logged in, i load pref’s from the database with a SC and store it in datastore.
The datastore structure is very simple like this:
image
It’s works perfectly, BUT, i do not figure out how to retreive a user pref value from the datastrore with a key (which is “code”).
For example, i want to hide a Label if the user pref code BOOKS_EMP is equal to 1. I treid to put this in the dynamic attribute of the label:
image

image
image484×690 17.4 KB

But it doesn’t work ?

Can you help me please !

2

Not sure what you mean? Are you checking the code or something else?

3

After pref’s are loaded in the datastore, i have an array like this:
{$id: 1, code: “BOOKS_DF”, value: “2020-01-31”}
{$id: 2, code: “BOOKS_DD”, value: “2020-01-01”}
{$id: 3, code: “BOOKS_EMP”, value: “1”}
{$id: 4, code: “BOOKS_VIEW”, value: “2”}

I need to retreive the value of the key BOOKS_EMP to know if i must hide or not the label (just an example). 1=hide 0=show or whatever…

4

You can do this:

dataUserPrefs.data.where(`code`, 'BOOKS_EMP', '==')[0].value
5

Top thank’s Teodor !

For those how are nubies like me, it wrote exactly this on hide dynamic attribute.
dataUserPrefs.data.where('code','BOOKS_EMP','==')[0].value=='1'

Very tricky, is that some Js ? php ? could I have found this myself by referring to a particular documentation or language?

Thx again !

6

Well your use case is a bit too specific. If you have a known number of options you can just define them in the data store schema directly, like:

id, BOOKS_DF, BOOKS_DD, BOOKS_EMP, BOOKS_VIEW

So then you can directly select in the data picker without using where etc.

7

Your remark is very judicious. At this stage of my development, I don’t actually know the number of options, but it will inevitably stabilise. However, my application is going to be important and the number of options very important. In addition, I am in a context with a single database for several customers and several users per customer.
For the moment, my SC filters the preferences for each page, but perhaps performance issues will cause me to reconsider my choice.
In any case, I would like to reiterate my thanks for your (and also for your team’s) responsiveness. That’s also why I love wappler !

1 Like